MOM 2005 Query: Find Clients who are being rejected
The following query will find all clients whose configuration or data package is being rejected by the MOM Management Server in the past day.
-- Scott Moss
-- 12/16/2007
-- MOM 2005 OnePoint DB Query
-- to find all clients whose configuration or data package is being rejected
-- for the past one day
--
Select Distinct
ComputerName [Management Server],
Message
From SDKEventView
Where Source = 'Microsoft Operations Manager'
And Message Like '%rejected%'
And (DateDiff(d, TimeGenerated, GetDate()) <= 1)
Visit myitforum Blog http://myitforum.com/cs2/blogs/smoss/default.aspx