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