Hello,

I have a requirement to extract information from SCOM into a multidimensional data warehouse that will be conformed with information form other systems.

One particular set of data I must fetch from SCOM is the percent up/down time of all hosts in a monthly period, which will populate a fact table in my data warehouse.

At the moment we have some report creators downloading this information from SCOM as a CSV file. However I have no idea where this data actually comes from in the SCOM databases. Could someone please advise?

Thank you for your time.

Regards,
P.