Tag Archives: sql query

Who was the last person to modify SCOM roles?

It might be useful to periodically keep track of changes made to the Security-User Roles section of SCOM. You are going to know who you have given the ability to make modifications, but it is not quite as easy to see which … Continue reading

Posted in SCOM 2012 SP1 | Tagged , , , , , , , , , , , , , , | Leave a comment

Datawarehouse Database Cleanup SQL query

IMPORTANT: Always perform a FULL Backup of the database before doing anything to it !!! This article applies to SCOM 2007 and SCOM 2012 Somtimes you may have event storms where you end up having old entries in the Data … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , , | 1 Comment

SQL Query to report on how many times a particular alert has triggered

Here is a very useful SQL Query that you can use to determine how many times a particular alert has fired, when it fired and what host it fired on. Open up Microsoft SQL Server Management Studio on your Datawarehouse … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , | Leave a comment

Check last user to modify SCOM user roles

Attached is a simple guide that shows you how to run a SQL query against your Operations Database to see which one of your SCOM Admins made the most recent change to the SCOM user roles. Check last user to modify … Continue reading

Posted in Misc Stuff, SQL Queries | Tagged , , , , , , , , , | Leave a comment

Addressing database bloat

Database grooming is a well documented topic when it comes to working with SCOM. Only old state change data for monitors that are currently in a HEALTHY state, AT THE TIME that grooming runs are groomed out.  OLD state change events for monitors that … Continue reading

Posted in SQL Queries | Tagged , , , , , , , | Leave a comment