This chapter will explore methods for retrieving and manipulating data collected within SCOM and show you how this data can be presented back to your organization in a meaningful way. The methods shown in this chapter can be modified to suit your organizational needs.
The recipes in this chapter will cover the following scenarios:
Building SQL queries
Understand the information you would like to retrieve and how to achieve this by using SQL queries
Creating SQL reports
Understand how to tackle the SQL query you created and explore how you can transform the data returned and present it as a SQL report using SQL Report Builder
Publishing SQL reports
Understand how to publish SQL reports for viewing within the SCOM console
Creating reports within the Operations console
Understand how you can create and save reports within the SCOM console
Scheduling reports
Understand how you can schedule reports within the SCOM console
Creating notifications and subscriptions
Understand how you can subscribe...