Home Orlando Now Platform Capabilities Now Platform capabilities Configuration Management Database Querying the CMDB Create reports in CMDB Query Builder

Create reports in CMDB Query Builder

The Orlando release is no longer supported. As such, the product documentation and release notes are provided for informational purposes only, and will not be updated.

Create reports in CMDB Query Builder

Use CMDB Query Builder reports to show the results of a CMDB query or a Service Mapping query. Create a basic report, or a dynamic report that automatically updates when the results of the associated saved query change.

Create a dynamic report

After running a saved query in the CMDB Query Builder, create a dynamic report that continuously updates to show the latest query results. You can use a dynamic report as any other report created using Reporting and you can add it to Performance Analytics dashboards.

Before you begin

Ensure that the query that you want to create a dynamic report for is a saved query, and that there is a specified schedule for the query. Also, run the saved query and ensure that all query results are visible.

Role required:

To create: cmdb_query_builder and report_user
To view: Reporting role requirements might apply, see Administering reports for Reporting role requirements.

In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

About this task

The Create Report button in CMDB Query Builder which is used to create a dynamic report, is activated only if:

The query is saved
The query has a schedule
The entire set of query results is present after a query run

The initial dynamic report that you create, is based on the results from the initial run of the saved query. Then, on every subsequent run of the saved query, the associated report automatically updates with the latest query results.

However, if you change the query definition itself, the query and the report are no longer in sync and you must create a new report.

Procedure

Navigate to Configuration > CMDB Query Builder.
In the Saved Queries tab, select the saved query for which you want to create a report.
Ensure that the query has a specified schedule.
Click Run and ensure that all query results appear. Click Load All Results if available, to load all results.
The Create Report button is enabled only if all query results are showing.
Click Create Report.
If the CMDB Query Builder displays the query results in a new tab, then after the new tab opens with the query results, return to the CMDB Query Builder window.
In the Report Designer, click Next or Back to view and configure the new report in the Data, Type, Configure, and Style tabs.
The report is pre-populated with the CMDB query results and a few other report details.
- Report name is set to the name of the saved query.
- Source type is set to Data source.
- Data source is set to the table in which the query results are stored.
- Query Sys ID is the ID of the latest run of the query.
For more details about Reporting and about configuring a report in the Report Designer, see Reporting, Creating reports.
Click Save or Run.

Result

CMDB Query Builder creates a report source which you can attach to a report and use with dashboards. For more details about report sources, see Report sources.

What to do next

Use either of the following steps to view the new report source. The name of the new report source is set to the name of the CMDB query it was created from, and cannot be changed.

In Query Builder, click Saved Queries. In the Saved Queries window, click the Query Information icon in the tile of the saved query. Scroll to the bottom of the information list and then click the link under Report source.
Navigate to Reports > Administration > Report Sources and locate the new report source.

Create a basic report

After running a query in the CMDB Query Builder, you can create a basic report that is scoped to the query execution.

Before you begin

The UI16 plugin (com.glide.ui.ui16) must be activated.

Role required:

View report: cmdb_query_builder or cmdb_query_builder_read
Create report: cmdb_query_builder or cmdb_query_builder_read, and report_user

In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

Procedure

Navigate to Configuration and click CMDB Query Builder.
Build a query.
In the query results pane, click the list context menu and select Bar Chart or Pie Chart.

Result

The Reports application creates a basic report, which is scoped to the query execution and is static.

Previous topic

Next topic

Release version

Create reports in CMDB Query Builder

The Orlando release is no longer supported. As such, the product documentation and release notes are provided for informational purposes only, and will not be updated.

Create reports in CMDB Query Builder

Create a dynamic report

Before you begin

Role required:

To create: cmdb_query_builder and report_user
To view: Reporting role requirements might apply, see Administering reports for Reporting role requirements.

In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

About this task

The Create Report button in CMDB Query Builder which is used to create a dynamic report, is activated only if:

The query is saved
The query has a schedule
The entire set of query results is present after a query run

However, if you change the query definition itself, the query and the report are no longer in sync and you must create a new report.

Procedure

Navigate to Configuration > CMDB Query Builder.
In the Saved Queries tab, select the saved query for which you want to create a report.
Ensure that the query has a specified schedule.
Click Run and ensure that all query results appear. Click Load All Results if available, to load all results.
The Create Report button is enabled only if all query results are showing.
Click Create Report.
If the CMDB Query Builder displays the query results in a new tab, then after the new tab opens with the query results, return to the CMDB Query Builder window.
In the Report Designer, click Next or Back to view and configure the new report in the Data, Type, Configure, and Style tabs.
The report is pre-populated with the CMDB query results and a few other report details.
- Report name is set to the name of the saved query.
- Source type is set to Data source.
- Data source is set to the table in which the query results are stored.
- Query Sys ID is the ID of the latest run of the query.
For more details about Reporting and about configuring a report in the Report Designer, see Reporting, Creating reports.
Click Save or Run.

Result

CMDB Query Builder creates a report source which you can attach to a report and use with dashboards. For more details about report sources, see Report sources.

What to do next

Use either of the following steps to view the new report source. The name of the new report source is set to the name of the CMDB query it was created from, and cannot be changed.

In Query Builder, click Saved Queries. In the Saved Queries window, click the Query Information icon in the tile of the saved query. Scroll to the bottom of the information list and then click the link under Report source.
Navigate to Reports > Administration > Report Sources and locate the new report source.

Create a basic report

After running a query in the CMDB Query Builder, you can create a basic report that is scoped to the query execution.

Before you begin

The UI16 plugin (com.glide.ui.ui16) must be activated.

Role required:

View report: cmdb_query_builder or cmdb_query_builder_read
Create report: cmdb_query_builder or cmdb_query_builder_read, and report_user

In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

Procedure

Navigate to Configuration and click CMDB Query Builder.
Build a query.
In the query results pane, click the list context menu and select Bar Chart or Pie Chart.

Result

The Reports application creates a basic report, which is scoped to the query execution and is static.

How search works:

Topics are ranked in search results by how closely they match your search terms

Create reports in CMDB Query Builder

Create reports in CMDB Query Builder

Create a dynamic report

Create a basic report

On this page

Create reports in CMDB Query Builder

Create reports in CMDB Query Builder

Create a dynamic report

Create a basic report

Log in to personalize your search results and subscribe to topics