Broadcasting live from Redmond, Washington
Did you know you can use PowerShell to create an Excel list of all of the rules in your imported Management Packs? It's pretty easy -- just follow these steps:
- On your Management Server, open the Command Shell by clicking Programs->System Center->Command Shell.
- In the command window, type:
get-rule | select-object @{Name="MP";Expression={ foreach-object {$_.GetManagementPack().DisplayName }}},DisplayName |
sort-object -property MP | export-csv "c:\rules.csv"
Open the file C:\rules.csv in Excel and expand out the first column to get a view like this (click for larger picture):
The export-csv cmdlet that the output is piped into is a handy one to know about. You can use it to use to put information extracted with PowerShell into a comma separated format that can be read by Excel.
[Edit: Updated first line to clarify that this outputs rules for Management Packs that are already imported and to include link to larger picture.]
New Comments to this post are disabled
About Jonobie Ford
I joined Microsoft in October of 2006, right in the middle of a flurry of Ops Manager activity. After joining, I started work on planning for the Management Pack guides and later wrote the Active Directory MP Guide. Prior to joining Microsoft, I was a writer at IBM in the Tivoli brand, most recently for the Response Time Tracker product, although I also worked on the Enterprise Console product.
I now work as the content publishing manager for System Center Capacity Planner, System Center Service Manager, and the Connector and Cross-Platform extensions for Operations Manager.
