This recipe is a simple primer on how to create very simple queries to retrieve information from the Microsoft SQL database of a System Center component. The recipe uses the System Center Configuration Manager component as the target.
You must have deployed a System Center 2012 Configuration Manager environment. The environment must have the Reporting Services Point role enabled and functional. Additionally, you must have system discovery and inventory enabled.
The account you use to perform the steps in this recipe must have access to the SQL Server with read access to the Configuration Manager database. The steps use the Microsoft SQL Server Management Studio (MSSMS) tool.
The recipe's goal is to create ...