SQL Server Reference for Configuration Manager Reports

Oppdatert: januar 2014

Gjelder for: 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.

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.

Se også

-----
For additional resources, see Information and Support for Configuration Manager.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012 Configuration Manager. For instructions and examples, see Search the Configuration Manager Documentation Library.
-----
Vis: