30.10 Query

30.10.1 Creating a Query

Example: Creating a Print Query

1) In the navigation bar, go to Query, right-click and select New Query to open the query creation interface.

2) Select Print Report Template → Standard Print Statistics, or choose another custom print statistics template, then click OK.

Once the query is created, it inherits the selected template’s condition and statistical settings. The right-click menu allows you to rename, delete, or move the query.

30.10.2 Performing a Query

To perform a query, select a query under the Query node in the navigation bar. At the top of the data display area on the right, you can modify the query conditions and statistics type. After making changes, click Save at the top-right. The next time this query is selected, the saved conditions and statistics type will be applied by default.

Query Conditions: Include date range, computer scope, user scope, and advanced conditions.

Statistics Type:

• For trend queries, you can also select the statistical unit. Available time units are: Day, Week, Month, Quarter, Year.
• Example: If the query condition is set to the previous month:
  • Selecting Day as the statistics type will generate results for each day.
  • Selecting Week will generate results for each week.

After selecting the query conditions and statistics type, click Statistics to start the calculation. Once complete, the results will be displayed as a chart and table.

• Viewing Details: Double-click a row in the statistical table to view detailed log entries.
• Adjusting Columns: Right-click a column header to add or remove displayed columns.

30.10.3 Other Operations

On the right side of the query conditions in the data display area, you can perform the following operations on the selected query:

Reset

Click Reset to restore the query conditions and statistics type to the last saved state.

Save

Click Save to store the current query conditions and statistics type. The next time this query is selected, the saved conditions and type will be applied by default.

Save Results

After running a query with a selected set of conditions and statistics type, click Save Results. After specifying a name, the results can be found under Reports → Data Center.

Save as Template

Click Save as Template, enter a name, and a template creation dialog will appear. The new template inherits the current query’s conditions and statistics type but can be fine-tuned as needed. Saved templates can be found under Reports → Template Management.

Generate Report

Click Generate Report to open the periodic report creation dialog. The new report will inherit the current query’s conditions and statistics type, which can be modified if necessary.