Exchange Storage Info in SCOM database
I have SCOM set up with exchange monitoring. I need to query the SQL database and find out the amount storage space utilized by the exchange servers that SCOM is monitoring. I am able to connect to the database via SQL Studio, I am not sure what table this data may be stored in. I have ran a few queries, but none of them give me this information. Where is this type of info stored in the SCOM database? I need to get this from the SQL DB and not a SCOM report. Thanks
April 26th, 2012 2:33pm

This data might not even be present. Which scom rule collects this data you are interested in?Rob Korving
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2012 8:02am

Honestly I don't know. I am just learning SCOM, we have a client that has SCOM set up, but they don't know a whole lot about it either. I was hoping someone here might know. I set up a Virtual machine so I could tinker with SCOM myself and try to figure it out as well, but I am not sure where to look. I added all of the exchange add ins for SCOM (or at least I believe I did) but I don't know what all this will track.
April 27th, 2012 9:03am

To find all data submitted by a MP into the DB is pretty intense. I am not sure if anyone has created such a SQL query yet. Regardless, here are a few links that can get you started in your quest for how much data is being deposited and from where (which MP/rule/monitor/etc): Hope these help. Keep in mind some need to run against opsdb and others against datawarehouse. Regards, Blake Email: mengotto<at> Blog:
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2012 4:25am

Thanks I'll check it out
April 30th, 2012 9:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics