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):
- Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \\\’New\\\’
- Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \\’New\\’
GO
3.Select count (*) FROM [dbo].[Workspaces] (NOLOCK) where Status = \\’New\\’
GO
Thanks & Regards
Kumar