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

You can view the resolved query of a custom report or filter that you create or modify. The Resolved Query tab displays the SQL code that is run on the CMDB. Any parameters that you have specified are set to the appropriate testing values.
If you view a resource query, you can set the query mode from the
Resource Query Mode
drop-down list:
Normal
Shows the default resolved query. The default resolved query is generated from the resource query that you specified in the Query Builder, with no further additions.
Create Snapshot Data Table
Adds the SQL code to the query that creates a snapshot data table for the query results. The modified query is shown.
Save Snapshot Data
Adds the SQL code to the query that saves the query results in a snapshot data table. The modified query is shown.
Load Snapshot Data
Adds the SQL code to the query that extracts the query results from a snapshot data table instead of the CMDB. The modified query is shown.