vManagementPack This view provides information about the Management Packs in the Operations Manager environment and can be joined to the vManagedEntityType, vMonitor, and vRule views. vRelationship This view provides relationship information, which can be used to retrieve group membership for Managed Entities. This view can be joined to the vManagedEntity view on the SourceManagedEntityRowId and TargetManagedEntityRowId columns. vRelationshipType This view provides information about the type of relationships identified in the vRelationship view and can be joined to other views on the RelationshipTypeRowId column. vManagementGroup This view provides information Management Groups that send data to the Data Warehouse and can be joined to several other views on the ManagementGroupRowId column. Inside a Generic Report Before you start building your own queries, it may be helpful to see how the queries for the built-in reports work. The sections below look at the queries used by three existing reports from the Microsoft Generic Report Library: The Availability report, the Alerts report, and the Performance report. For each report, the query is located in a stored procedure. The stored procedures are reproduced here so you can see the Transact-SQL code. The Alert Report The purpose of the Alert report is to present a simple list of alerts raised by the managed objects specified in the parameters of the report. The report in the Generic Library can list events of all severities (Information, Warning, and Critical) and all Priorities (Low, Medium, and High). For each alert, it provides the Alert Name, Repeat Count, Priority, the Object that raised the alert, and the first and last dates where the alert appeared. This deals with Alert data, so it uses the vAlert view. First, it retrieves the AlertName, Severity, and Priority, which are all basic information. It also retrieves the ManagedEntityRowId, which will be used as a foreign key later in the query: SELECT Alert.vAlert.AlertName, Alert.vAlert.Severity,
vManagementPack This view provides information about the Management Packs in the Operations Manager environment and can be joined to the vManagedEntityType, vMonitor, and vRule views. vRelationship This view provides relationship information, which can be used to retrieve group membership for Managed Entities. This view can be joined to the vManagedEntity view on the SourceManagedEntityRowId and TargetManagedEntityRowId columns. vRelationshipType This view provides information about the type of relationships identified in the vRelationship view and can be joined to other views on the RelationshipTypeRowId column. vManagementGroup This view provides information Management Groups that send data to the Data Warehouse and can be joined to several other views on the ManagementGroupRowId column. Inside a Generic Report Before you start building your own queries, it may be helpful to see how the queries for the built-in reports work. The sections below look at the queries used by three existing reports from the Microsoft Generic Report Library: The Availability report, the Alerts report, and the Performance report. For each report, the query is located in a stored procedure. The stored procedures are reproduced here so you can see the Transact-SQL code. The Alert Report The purpose of the Alert report is to present a simple list of alerts raised by the managed objects specified in the parameters of the report. The report in the Generic Library can list events of all severities (Information, Warning, and Critical) and all Priorities (Low, Medium, and High). For each alert, it provides the Alert Name, Repeat Count, Priority, the Object that raised the alert, and the first and last dates where the alert appeared. This deals with Alert data, so it uses the vAlert view. First, it retrieves the AlertName, Severity, and Priority, which are all basic information. It also retrieves the ManagedEntityRowId, which will be used as a foreign key later in the query: SELECT Alert.vAlert.AlertName, Alert.vAlert.Severity,
OM2007_ReportAuthoringGuide.docx