| title | titleSuffix | description | ms.date | ms.subservice | ms.service | ms.topic | ms.assetid | author | ms.author | manager | ms.localizationpriority | ms.collection |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
How to view the SQL Statement for reports |
Configuration Manager |
Information to find out what SQL statement is used in a Configuration Manager report. |
04/30/2019 |
sdk |
configuration-manager |
how-to |
e596b1be-c09e-4e44-a400-43345ab0f71b |
banreet |
banreetkaur |
apoorvseth |
low |
tier3 |
Reports in Configuration Manager can be based on simple SQL statements or very complex ones that prompt the user for information, join several Microsoft SQL Server views, and use filters to limit the results. Use the following procedure to find out what SQL statement is used in a Configuration Manager report.
-
In the Configuration Manager console, select Monitoring.
-
In the Monitoring workspace, expand Reporting, and then select Reports.
-
Select the report for which you want to view the SQL statement and then, in the Home tab, in the Report Group group, select Edit.
-
The Report Builder window opens. In the Report Data pane, expand Datasets to view the data sets for the report.
-
Double-click a dataset to open the Dataset Properties dialog box.
The first dataset is typically (but not always), the main SQL statement for the report. Other datasets might contain the SQL statements that can be used to present a list of items for a user to choose from, such as a list of computers.
-
You can view and modify the SQL statement for the dataset in the Query field.
-
Close the Dataset Properties dialog box.
-
Close Report Builder.