There’s a series of useful SCOM database queries written by Kevin Holman (http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx). I got a bit tired of copy-pasting them over and over again. That’s why i created a small Reports Management Pack that you can import.
After you’ve imported it, you’ll find the new Report under the “Reporting” pane.
Run it and you will get your result. I’m planning to include some more useful queries later on.
You can download the Management Pack Here
Samuel
Bert Pinoy
David Biot
Geert Brumagne
ginodh
jaspervd86
matthiaswaltniel
Samuel Dubrul
Thanks Samuel!
you’re welcome
Nice work…! thank you.
I updated the MP.
– 0 20 30 are automatically replaced to Raw, Hourly and Daily
– Full path of FileName is now showing the whole path