Some Sample Reports...

Published Feb 14 2019 09:48 PM 87 Views
First published on TECHNET on Sep 25, 2009

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
http://www.microsoft.com/info/cpyright.htm


Daniel Savage


Sample.Report.Library.xml

%3CLINGO-SUB%20id%3D%22lingo-sub-340891%22%20slang%3D%22en-US%22%3ESome%20Sample%20Reports...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340891%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Sep%2025%2C%202009%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EBack%20at%20MMS%20this%20year%20we%20presented%20a%20session%20on%20authoring%20reports.%20During%20that%20session%20my%20colleague%20Vitaly%20created%20a%20SQL%20stored%20procedure%20that%20allowed%20us%20to%20create%20a%20server%20overview%20report%20showing%20key%20server%20metrics%20such%20as%20Processor%20Count%2C%20Physical%20Memory%2C%20CPU%20Utilization%2C%20Availability%20and%20Logical%20Disk%20Space.%20%26nbsp%3BI%20have%20now%20eventually%20gotten%20round%20to%20making%20this%20report%20available%20in%20sample%20(non-production%20J%20)%20form%20so%20you%20can%20see%20the%20approach%20we%20took.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThis%20is%20a%20useful%20report%26nbsp%3Bas%20it%26nbsp%3Bdraws%20server%20information%20from%20multiple%20data%20sources%20in%20the%20DW%20and%20presents%20them%20in%20a%20clear%20tabular%20form.%20It%20also%20enumerates%20all%20logical%20disks%20and%20presents%20their%20storage%20usage%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F75621iC222766386568228%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThe%20report%20and%20the%20relevant%20stored%20procedures%20that%20it%20uses%20are%20in%20the%20Sample%20MP%20attached.%20Simply%20import%20and%20give%20it%20a%20go.%20%3CB%3E%20Requires%20R2%20RTM.%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThis%20report%20takes%20%26nbsp%3Bgroup%20as%20a%20parameter%20and%20I%20also%20wanted%20to%20share%20this%20query%20as%20I%20have%20been%20asked%20about%20it%20several%20times.%20This%20returns%20a%20list%20of%20all%20groups%20similar%20to%20what%20you%20would%20see%20in%20the%20groups%20tab%20under%20authoring%20in%20the%20console.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESELECT%20DisplayName%20FROM%20vManagedEntity%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWhere%20ManagedEntityTypeRowID%20in%20(%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESELECT%20ManagedEntityTypeRowID%20from%20dbo.ManagedEntityDerivedTypeHierarchy%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E((%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESELECT%20ManagedEntityTypeRowId%20from%20vmanagedentitytype%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWhere%20managedentitytypesystemname%20%3D%20'system.group')%2C0))%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EORDER%20BY%20DisplayName%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F75622i8BAD42E257A7D6F2%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ELastly%20there%20is%20a%20second%20report%20in%20the%20Sample%20MP%20that%20allows%20you%20to%20view%20alerts%20generated%20by%20a%20particular%20MP%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F75623iF8FB28F193331362%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThis%20posting%20is%20provided%20%22AS%20IS%22%20with%20no%20warranties%2C%20and%20confers%20no%20rights.%20%3CBR%20%2F%3EUse%20of%20included%20utilities%20are%20subject%20to%20the%20terms%20specified%20at%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Finfo%2Fcpyright.htm%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Finfo%2Fcpyright.htm%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EDaniel%20Savage%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2FTNBlogsFS%2Fprod.evol.blogs.technet.com%2Ftelligent.evolution.components.attachments%2F01%2F4616%2F00%2F00%2F03%2F28%2F33%2F19%2FSample.Report.Library.xml%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Sample.Report.Library.xml%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-340891%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Sep%2025%2C%202009%20Back%20at%20MMS%20this%20year%20we%20presented%20a%20session%20on%20authoring%20reports.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-340891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESystem%20Center%20Operations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 11 2019 08:16 AM
Updated by: