Veritas Data Insight User's Guide
- Section I. Introduction
- Section II. Data Insight Workspace
- Navigating the Workspace tab
- Analyzing data using the Workspace views
- Viewing access information for files and folders
- Viewing user activity on files or folders
- About visualizing collaboration on a share
- Viewing access information for users and user groups
- Section III. Data Insight reports
- Using Data Insight reports
- About Data Insight security reports
- Permissions reports
- Permissions Search report
- Creating a Permissions Query Template
- Permissions Query Template actions
- Ownership Reports
- About Data Insight storage reports
- About Data Insight custom reports
- Managing reports
- Viewing reports
- Using Data Insight reports
- Section IV. Remediation
- Configuring remediation workflows
- Managing workflow templates
- Creating a workflow using a template
- Managing workflows
- Using the Self-Service Portal
- About the Self-Service Portal
- Managing data
- About managing data using Enterprise Vault and custom scripts
- About adding tags to files, folders, and shares
- Managing permissions
- Configuring remediation workflows
- Appendix A. Command Line Reference
Create/Edit DQL report options
Use this dialog to create an instance of a DQL report.
Table: Create/Edit DQL report options
Option | Description |
---|---|
Report Information | Enter information in the following fields:
|
Query | Write your DQL query in the space provided. You can provide multiple DQL queries separated by a space or a newline. This creates a DQL output with multiple tables for corresponding to each DQL queries. While writing the query you must adhere to the syntax and guidelines of the Data Insight Query Language (DQL). For more information about creating DQL queries, see the Veritas Data Insight Programmer's Reference Guide. Click Use Template to use the queries provided by Data Insight as templates. Click tthe drop-down to select a category and a template. Once you have selected a template, you can edit it as per your needs. See About DQL query templates. You can use a CSV file to feed a bulk input to a query. Click to browse to the CSV file containing the bulk input and click the file.For details on how to use the content of CSV file as arguments in a query, refer to the Veritas Data Insight Programmer's Reference Guide. |
Optionally, click Run SQL commands on generated DQL output database. This displays a text area where you can type the SQL commands that enable you to access and manipulate the DQL output database. The feature enables you to do the following: >Click View DQL output database schema to view the schema of the tables which get generated by DQL. Click Check DQL syntax to view syntax errors for your DQL query. Following is an example of a query to get a report that provides the distribution of files and storage per extension in a share. Replace <Share Name> with the name of the share in your environment. from path get extension, count(extension), sum(size) where path.msu.name = "<Share Name>" and type = "file" and isdeleted = 0 group by extension create table Cap_EXT(path_rowid INTEGER, extension TEXT, no_files INTEGER, size_MB INTEGER); insert into Cap_EXT select path_rowid, COALESCE(NULLIF(extension,''), 'Unclassified File Group') , "count(extension)", round("sum(size)"/1024.0/1024.0, 2) from path order by "sum(size)" desc; Following is an example of a query to get a report that provides the classification results for all files that are tagged as containing Personally Identifiable Information (PII). DQL Query For more examples, refer to the Veritas Data Insight Programmer's Reference Guide. | |
Notification | Enter email addresses of users you want to send the report to. If the size of the attachment is above the configured limit, an email is sent without the attachment. You can configure the size of the attachment under Settings > |
Remediation | Use this tab to instruct Data Insight to execute predefined actions on a report output. Select Take action on data generated by report to enable automatic processing of data generated by a report. Select any of the following:
See About managing data using Enterprise Vault and custom scripts . |