DQL Report does not output to 1 file 5.0.1
I am using DI 5.0.1 and I am not able to have the DQL report to output to 1 single file. Is anyone else having this issue? I have a DQL query and when I am pulling some of the AD Attributes, it will separate the files. I even have put 'format user AS csv' at the end and it still puts it into multiple files. From user get name, principal_name, login, Home_directory, Department If Home_Directory not in ('nowhere') format user AS CSV; Please help!
DQL: Sum the Sum of Total Access, Exporting Dashboards
Is there a way to use DQL to demonstrate the sum of the sum of total access for sites? For example, you can generate reports to showthe number of people with access levels ofcreate, read, write, and delete per site, but can you also demonstrate that total per person? We are looking to determine an individual's level of access to each site monitored by DI, summed per level of access. In addition to this, can you export the graphs and dashboards generated to Excel? You can save the raw data in table format, but the graphs would also be helpful. Thanks! Evan
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 DESC