After some delays I have finished the V2 version of the ScomExcelWorkbook.
See old V1 post here: https://michelkamp.wordpress.com/2012/11/25/scom-and-excel-a-perfect-couple/
1) More types to query
The types below can now be used in the Type column:
2) Combine data on same sheet
When you make a pivot table from a SCOM data sheet you will notice that if you want to combine data of 2 data sheets into one pivot table it will be a challenge to get it work. So I have made a feature that you can append data to one SCOM data sheet. The only thing you will have to do is to use the same sheet name and type in the query rows. See below for a example.
3) Extended Properties
Since I was too lazy to hard type every property name in a column I made it dynamic. Cost me some time to get the object type casting generic but again I learned a lot more of C# reflection. And that’s what I do it for “learning on the job”.
As always , some speed-up and code simplifying was done.
Okay nice but how to get it…
In my V1 version I decided to only give the download to people that did a PM. I have had a lot of PMs and good responses. This was great but took a lot of time to process. So now I will publish it on my public SkyDrive link below. But you are free to leave me a comment I really would appreciate that.
Download it and give it a try. Please please let me know if you like it or have suggestions/problems.
O yea before I forget:
The sheet contains sample query’s you can delete every line after row 4. And put your own ones in. Some help can be found here: