Building SQL queries
This recipe will describe the steps you need to build a SQL query that will extract application information from your SCOM databases. This method can be used to collect other information from the databases to suit your organizational needs.
In this recipe, we will look at scenarios for which we require data to be extracted from our environment using SQL queries.
This scenario will demonstrate how you can retrieve a list of distributed applications from your environment and identify the health status of each.
Getting ready
The preparation for this recipe is to ensure you have the appropriate access to read your SCOM databases and access to SQL Server 2012 Management Studio.
How to do it...
Perform the following steps to build, test, ...
Get Microsoft System Center 2012 R2 Operations Manager Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
