Custom Report Edit Page:
Data Source
Tab:
Parameterized Query
Tab

When you define an SQL query for a new custom report or filter, you can write an SQL query to run on the CMD. When you modify an SQL query for an existing custom report or filter, you can write an SQL query to run on the CMD. The
Parameterized Query
tab lets you write the SQL query that you want to run on the CMDB. This tab is primarily a free-form text box that lets you write the SQL code, or paste it from the Clipboard. The Object Explorer panel lets you select source fields from the CMDB and inject them into the query. Injecting source fields simplifies the writing of the query.
You need the Edit SQL privilege to create or modify SQL queries, and you should have a good understanding of the CMDB table structure. If you want to apply scoping to the query results, you need to include the appropriate SQL code in the query.
Options on the
Parameterized Query
tab
Option
Description
Text box
Lets you type the SQL query text.
You can type the SQL from scratch, or paste it from the Clipboard.
If you want to add a source field into your SQL query, click in the SQL code at the location where you want to add the specified object or field and then click
Add
in the
Object
or
Field
line.
Object
Lets you select the database table that you want to use.
Field
Lets you select the table column that you want to use.
Alias
Lets you type the alias names for the database table and the table column.