Back at MMS this year we presented a session on authoring reports. During that session my colleague Vitaly created a SQL stored procedure that allowed us to create a server overview report showing key server metrics such as Processor Count, Physical Memory, CPU Utilization, Availability and Logical Disk Space. I have now eventually gotten round to making this report available in sample (non-production J ) form so you can see the approach we took.
This is a useful report as it draws server information from multiple data sources in the DW and presents them in a clear tabular form. It also enumerates all logical disks and presents their storage usage:
The report and the relevant stored procedures that it uses are in the Sample MP attached. Simply import and give it a go. Requires R2 RTM.
This report takes group as a parameter and I also wanted to share this query as I have been asked about it several times. This returns a list of all groups similar to what you would see in the groups tab under authoring in the console.
SELECT DisplayName FROM vManagedEntity
Where ManagedEntityTypeRowID in (
SELECT ManagedEntityTypeRowID from dbo.ManagedEntityDerivedTypeHierarchy
SELECT ManagedEntityTypeRowId from vmanagedentitytype
Where managedentitytypesystemname = ‘system.group’),0))
ORDER BY DisplayName
Lastly there is a second report in the Sample MP that allows you to view alerts generated by a particular MP:
This posting is provided “AS IS” with no warranties, and confers no rights.
Use of included utilities are subject to the terms specified at