Home
Analysis Engine Reports
Report Features
Report SQL
You can view the basic SQL (not including any filters or sort options used) executed for the report by clicking on the view icon.

Analysis Engine Reports
- Assets Reports
- Discovery Reports
- License Reports
- Report Features
  - Report Repository Selection
    Each report has an option to select the Repository of your choice. Based on the repository selected from the drop-down menu, you can view the report data.
  - Report Filters
    Each report has two filters Vendor and Product. Some reports have additional filters available, like System. You can select multiple inputs from the Vendor filter. Each vendor can be associated with multiple products.
  - Report Column Sorting
    Each report has sorting enabled on the Vendor and Product columns. Other reports, such as Module Compilers, have sorting enabled on the Compiler and Compiler Version columns.
  - Report Download
    Each report has a download icon available for downloading the displayed report in CSV format.
  - Report SQL
    You can view the basic SQL (not including any filters or sort options used) executed for the report by clicking on the view icon.
- Report Navigation
  Each report has a pagination feature to move to Start and End page.
- Report Positioning
- Reports with Toggling Options
- Reports with CrossTab
- Report Columns
  Though all the reports have similar functionality, they have different columns. All the columns pertaining to different reports are explained in the following tables.
- Drill-down Reports

Report SQL

You can view the basic SQL (not including any filters or sort options used) executed for the report by clicking on the view icon.

This SQL can be used as a basis for constructing customized report queries. Your constructed SQL can be executed using the ZAO V2.1 'post' API service. See the 'Admin' section for more information regarding the ZAO API service.

When you click on the

icon, the SQL will be displayed in a new window.

Click the Copy icon to copy the shown SQL.

When you click on the copy icon, the icon will change to copied and a window is displayed with a close button to close the window.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site.