Skip to main content
Matrix42 Self-Service Help Center

Query Analyzer


Query Analyzer is a tool that allows you to analyze and validate ASQL queries before you add and use them in the following areas of DWP, for instance:

For more details on ASQL basic approach, syntax and functions see ASQL page.

This tool is helpful when you need to write a complex query and instantly view the results, as well as adjust and fix your query before adding it to the above-mentioned areas of DWP.

Additionally, Query Analyzer can be used to get data without login to the system or SQL Server connection.


Query Analyzer can be accessed directly from the Application Server. Open the file that is located inroot\bin\QueryAnalyzer.exe 

Query Analyzer UI Elements


To run the query enter the following data:

  1. CI/DD: choose a Configuration Item or a Data Definition you would like to query. Start typing the name of the schema element for suggestions:
  2. Where clause: enter the filtering condition for the chosen CI/DD.  It is used to retrieve only those records that fulfill a specified condition, for instance, the following query extracts all Incidents from the SPSActivityClassBase Data Definition: 
  3. Column clause: defines how to format the result-set

The expressions in the Column clause must define an alias if they are not direct attributes of the base class.

Query options

  • run query.png Click the icon to execute the query;
  • asql_to_sql.png  Transforms the ASQL request into SQL statement;

Query results

  • Results: this section shows the result of the successfully run query
  • SQL: transforms the ASQL request into SQL statement
  • Messages: error log of the run queries
  • Was this article helpful?