Custom Report Edit Page: Data Source Tab: Parameterized Query Tab
Data Source
Tab: Parameterized Query
TabWhen 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.
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. |