Create/Edit DQL report options
Prev Using Data Insight reports Next

Create/Edit DQL report options

Use this dialog to create an instance of a report.

Table: Create/Edit DQL report options

Option

Description

Report Information

Enter information in the following fields:

  • Name - A logical name for the report.

  • Description - A short description of the data contained in the report.

  • Report Type - This field is pre-populated as DQL Report by default.

  • Output format - Click the check-box to indicate that you want the report output in a CSV file.

  • Maximum Reports to preserve-Select the number of report output you want the system to preserve. The default value to preserve the report output is unlimited.

  • Schedule - Select the schedule at which you want the report to run.

  • Copy output to- Enter a path to copy report output files. To successfully copy a report output to an external computer, you must ensure that the Secondary Logon windows service is running in the Management Server.

  • Select Credentials to access "Copy output to" path - Select a credential from the drop-down menu, so that Data Insight can direct the report output to the specified location. Additionally you can use the option for adding a new set of credentials if the required credentials are not already added. The credentials must have folder-level read, write, create, and delete permissions on the external computer where the report output is copied.

  • Overwrite option - Selecting this option overwrites the earlier report output files. If you clear this check box, Data Insight creates a new folder with a report run ID for every report run, and saves the report in the new folder.

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 Symantec Data Insight Programmer's Reference Guide.

Click Use Template to use the queries provided by Data Insight as templates. Using the drop-down lists 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 Choose file to browse to the CSV file containing the bulk input and click Upload the file.

For details on how to use the content of CSV file as arguments in a query, refer Symantec Data Insight Programmer's Reference Guide.

Optionally, click Advanced Options > 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:

  • Create new tables.

  • Delete tables from the report output.

  • Insert data from existing tables in the output database into new tables.

  • Use CASE statements in SQL.

  • Create indexes on tables before performing joins.

Click View empty DQL output database schema to view the schema of the tables which will be generated by DQL.

Click Check DQL syntax to view syntax errors for your DQL query.

Following is an example of a query that you can write 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.

DQL Query

from path

get extension, count(extension), sum(size)
where path.msu.name = "<Share Name>"
and type = "file"
and isdeleted = 0
group by extension

Advanced Options

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;

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 > SMTP 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:

  • Archiving (Enterprise Vault) - Select this option to archive data using Symantec Enterprise Vault. If you select this option you must specify a retention category and a post-processing action.

  • Custom Action 1 / Custom Action 2 - Select this option to specify a custom action defined by a custom script.

See About managing data using Enterprise Vault and custom scripts .
Prev Up Next
Creating custom templates for DQL queries Home Considerations for importing paths using a CSV file