SQL Server Reference for Configuration Manager Reports
Updated: January 1, 2014
Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager
The SQL statement is the principal element in a System Center 2012 Configuration Manager report that defines which data the report gathers and returns as the result set or multiple result sets. The topics in this section provide detailed information about the common functions and joins used in SQL statements and about using the query design tools found in SQL Server to help you to easily write effective SQL statements.
In This Section
SQL Statement Reference for Configuration Manager Reports
Provides detailed information and examples for using SQL aggregate functions, joins, and the keyword phrase NOT IN.Using Query Designer to Write Report SQL Statements for Configuration Manager Reports
Provides information about using the query design tools found in SQL Server to create or modify queries in Configuration Manager reports.How to Create a SQL Statement by Using Query Designer
Provides information about how to use Query Designer to help create SQL statements that you can use in your reports.