How to monitor SQL DB Fragmantation with SCOM

How to monitor SQL DB Fragmantation with SCOM

Description :

I have prepared this Powershell script to use it with SCOM. Of course it can be used as a standalone script too. I am basically creating a Rule in SCOM to trigger the below script which logs an event into the Application Event Log. Later on I am […]

Read More

Monitor Notebook Battery Health with Powershell in SCOM

Description :

I have prepared this Powershell script to use it in SCOM but of course it can be used also as a standalone script or it can be scheduled in Task Manager too.

The logic behind it was to log an event into the clients application event log and collect […]

Read More

T-SQL : Search for Historical Alerts and Events inside the SCOM Data Warehouse for a specific server and between dates

Description :

There are several T-SQL queries available on the internet especially from Microsoft PFE Kevin Holman regarding searching for Events or Alerts on the OpsMgr Operational Database but not for the Data Warehouse database. In some troubleshooting scenarios or forensic analysis historical data (events or alerts) related to a […]

Read More

SCOM 2012 R2 UNIX/Linux Discovery can fail with error message : “Data at the root level is invalid. Line 2, position 1”.

Problem Description :

The UNIX/Linux Discovery Wizard in SCOM 2012 R2 can fail with the error message : “Data at the root level is invalid. Line 2, position 1” .

Solution :

This problem can of course have different reasons but in our case we figured out that the problem is caused […]

Read More

Part 12 : SCOM 2012 R2 HealthService Event Reference / PoolManager

PoolManager

HealthService uses PoolManager to manage the resource pools it belongs to. PoolManager creates a new pool object for each resource pool. Each such pool also has three sub-parts:

    Process Sends lease requests
    Observer Handles lease requests
    Client Sends check requests and handles check ACKs

A lease is like a ticket that contains availability […]

Read More

Part 11 : SCOM 2012 R2 HealthService Event Reference / JobManager

JobManager

When running a task from the console, either on a management server or on an agent, HealthService uses JobManager to run the task.

EventID=9000
Severity=Error Message=The task status was changed to Failed on restart and was unable to be resumed because the System Center Management service was shut down

EventID=9001 […]

Read More

Part 10 : SCOM 2012 R2 HealthService Event Reference / DataPublisherManager

DataPublisherManager

DataPublisherManager publishes the data for each data source, for example, published data that needs to be written to the databases.

EventID=8000
Severity=Warning Message=A subscriber data source in management group %1 has posted items to the workflow, but has not received a response in %5 minutes Data will be queued to […]

Read More

Part 9 : SCOM 2012 R2 HealthService Event Reference / DiscoveryManager

DiscoveryManager

DiscoveryManager handles the scheduling and processing of discovery rules. It also has a sub-feature that manages the schedules for each discovery rule.

EventID=10000
Severity=Warning Message=A scheduled discovery task was not started because the previous task for that discovery was still executing %n%nDiscovery name: %2 %nInstance name: %3 %nManagement group name: […]

Read More

Part 8 : SCOM 2012 R2 HealthService Event Reference / SecureStorageManager

SecureStorageManager

SecureStorageManager loads or unloads and resolves any RunAs profiles and locally associates their RunAs accounts by applying the SecureReferenceOverride. This is the equivalent of applying a normal override for a workflow, but it associates the user account configured in RunAs accounts that have been associated with the locally used […]

Read More

Part 7 : SCOM 2012 R2 HealthService Event Reference / HealthManager

HealthManager

HealthManager is responsible for managing the state of each existing monitor, for each instance that is local to its HealthService. For example, if you have a free space monitor targeting the LogicalDisk class, HealthManager manages the state of each logical disk monitor belonging to each locally discovered LogicalDisk instance. […]

Read More