Tag Archives: OperationsManager database

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

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

SQL queries for Operations Database

NOTE:-This post covers SQL queries for the Operations Manager Database not the Datawarehouse. A good and quick way to get information about your SCOM environment is to run SQL queries against the databases. Connect to SQL Server Management Studio on your … Continue reading

Posted in SQL Queries | Tagged , | Leave a comment

Event IDs 2115 with source HealthService appear in the event viewer on the SCOM server

Issue Microsoft Systems Center Operations Manager (SCOM) is running on Microsoft Windows 2008 and has Service Pack 1 (SP1) installed on it. Here is the description of the alert being generated in the SCOM operator console: Alert description: Data Warehouse … Continue reading

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