T-SQL:
SELECT
TOP 50 UPPER(LoggingComputer) as 'Computer Name',
COUNT(*) AS 'Total Events'
FROM EventallView with (NOLOCK)
WHERE TimeGenerated > dateadd(dd,-7,getutcdate()) -- Scoped to within last 7 days
GROUP BY LoggingComputer
ORDER BY 'Total Events' DESC
Resources:
OpsMgr 2012 – Grooming deep dive in the OperationsManager database
|
|
|
|
|
|