Hello DI/DQL community, I am getting into some custom reporting with DQL and came across this sample query: Get the name, size, active data size, percentage of data size that is active, openness, and number of active users for each share FROM ...
i'm writing a batch script that deploys the reportcli.exe command to automatically create and run a set of reports based on the results of another report. So far it all works fine except for the exclude_group and exclude_user attributes in the report...
Currenty running 4.5 Data Insight, and looking for some thoughts on how to report on old data. I've been using the 'Data Aging' report, and our org needs data broken down by 1 year, 3 years, 5 years, and 7 years. Regardless of how I set the inte...
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_by...
I need to create a high-level report which amongst other things needs to give the number of files and folders for each physical and DFS share, which in theory I should be able to get from the MSU table (msu.file_count) however this particular field o...
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 (a...
Is there a way to customize the templates that are used for emailing DI reports, in the way that emails sent from the DI Portal Server can be customised and personalised to make them more friendly? Kind Regards Phil.
I attempted to add my questions as a comment on a similar DI Reporting Issue forum, but I'm not sure if my response was received. Here is my question: I have ran into a couple issues with reporting in DI: Is there a way to display more than the to...
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 show the number of people with access levels of create, read, write, and delete per site, but can you also demonstrate th...
Hello, To give some context to my issue, when HTML and CSV files are sent over SMTP in my company's network, they are stripped due to a company zip file policy. My question is: Is there a way to prevent these files from being stripped without chan...
Is there anyway of optimizing DQL such that engine will take notice of the device.name fields in the WHERE clause; such that it only runs the query on the indexer(s) associated with the specified devices? The problem that I having is that the DQL qu...
Is there a way to report the last access time for users? We are embarking on an access recertification program that requires a custom entitlement report to determine whether or not access to shares or folders should be revoked. This is a complex rep...
Data Insight has a useful feature where objects such as filers or shares can be placed into containers to faciliate management, for example to group together the filers that reside within the same data centres to enable more granular management and r...
I have a customer who requires a custom report for Data insight to filter out some of the records. I'm hoping to use DQL for this, but struggling to find an equivalent of the LIKE and NOT LIKE statement in SQL. The nearest thing I can find in the pro...
When running reports in Data Insight, we need to expand the number of results in the reports. In another site, Data Insight is configured to have about 99999999999 counts before truncation, because a Conf file was able to be edited. No one recorde...
When user lists contens of some folder, Data Insight generates READ event for all files in that folder. Is it normal? Maybe there is any way to fix it? Because it's not very informative, for example, if we have data owner policy whoch counts read+wri...
