DQL Query to find a specific filename
How do I look for a specific file? Ie what’s the field for “filename” ? Using DQL report, I can find all files with extension “url” What do I change to find a specific file (HELP_DECRYPT.URL) FROM path GET absname, size AS size_bytes, formatdate(created_on,'YYYY/MM/DD HH:MM:SS Z') AS creation_time, formatdate(last_accessed,'YYYY/MM/DD HH:MM:SS Z') AS last_accessed_time, formatdate(last_modified,'YYYY/MM/DD HH:MM:SS Z') AS last_modified_time IF type = "FILE" AND extension IN ("url") SORTBY size DESCDQL Use case
I have a potential opportunity for Data Insight with a focus around leveraging the Data Insight Query Language and am looking for additional help. I am starting to look at the Data Insight SDK guide to understand things but have one quick question (and perhaps many more difficult ones) The first question is, can I create variables/tokens within the syntax of the DQL and pass it through the Data Insight Report builder or do I have to leverage an outside process and call the SDK somehow? So the example is to query the Data Insight data for all shares with a specific name in it. Would I be able to token this within the Data Insight UI so each time the report ran it prompted me for the value or would I have to create separate form to pass this into the query? I am still gathering new information and will update this post when that is available.
DQL - Bulk input of search paths
Hi, I have a report which searches a list of pathsfor certain types of files such as vmdk, for example. FROM dfspath GET absname IF extension = 'vmdk' AND (substri(dfspath.absname, '<search path1>')=1 OR substri(dfspath.absname, '<search path2>')=1) Is there a way to read in the list of search paths from a CSV file rather than hard-coding them into the report. I tried using the IN FILE expression but this looks for a exact match of the pathnames whereas we are search for files below these paths. Alternatively, does DQL support wild characters such as '*' or '%' Any advice is much appreciated as always. Phil
Data Insight Self SErvice Portal
Hello, I'm looking for guideance, help and understanding around the Data Insight Self Service Portal. More specifically use cases, how are you using this product? Another question: How can I schedule my workflows to happen on a re-occuring basis? Once the workflow is terminated as complete it seeems I have to create another workflow. Which in my mind could lead to a large number of workflows in the system. The documentation seems to be pretty light on this product. Thanks, Jonathan