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 http://jama00.wordpress.com/
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): http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx http://blogs.technet.com/b/jonathanalmquist/archive/2009/04/25/operations-manager-2007-sql-queries.aspx Hope these help. Keep in mind some need to run against opsdb and others against datawarehouse. Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
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