O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building SQL queries the easy way

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.

Getting ready

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required