Script: Query Value from SQL Database and Log Event

This sample monitoring script illustrates how run a T-SQL query on a database and log an event based on value returned. Good example of how to dynamically create the connection string when database server & database name must be discovered at runtime.

In this sample, we actually run a query to retrieve the ‘Pending Actions’ count from the SCOM 2007 Operational database. Since the name and server location are up to the administrator, this script actually retrieves the server and database name from the registry (when run on Mgmt Server or RMS), and runs the query.

If the count of Pending Actions is greater than your user defined threshold, an event is logged. This could be used with an alert-generating rule to create an alert.

To see this script in action, try the sample OpsMgr 2007 Extensions MP, which will raise an alert when you have pending actions waiting for your attention in the Operations Console.