SQL Query MP

Hi Team,

Kindly confirm if this SQL Query MP supports SCOM 2019.

Also could you please share us the details how to enable this monitor.

 

Regards,

Kumar B

Do you mean this one:

https://squaredup.com/blog/a-new-free-management-pack-to-create-scom-monitors-from-any-sql-query/

If so, then I believe it was developed on SCOM 2016 and will work on 2019.

Based on my testing it works fine in SCOM 2019 but does require the legacy SQL management packs to discover the databases for the query wizard. A new version will be required to use the database discovery from the universal SQL MP, not sure if that’s in development. It is one of the main reasons we have held off on migrating to the new SQL MPs.

  • David

Hi All,

Does this MP work in SCOM 2012 R2. IF yes, then please guide us how can we achieve the below mentioned request for monitoring.

Request

SCOM perform a SQL query?

If the output of the query is more than 50, an alert should be generated.

These three queries should be executed (apart from each other):

  1. Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \\\'New\\\'
GO
  1. Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \‘New\’

GO

3.Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \‘New\’

GO

 

Thanks & Regards

Kumar