worker bee (1/11/2012)

---

That got it, I had to do some working around on it but I got what I was looking for. Thank you for putting me in the right direction. Next time I will try to more descriptive, sorry about that. I am just a complicated nerd...lol 😀

SELECT COUNT(*) AS [Count], Heading, Value, ServerName, Metric,

CONVERT(VARCHAR(10), UTCOccurrenceDateTime, 111) AS 'CountDate'

FROM dbo.Alerts

WHERE (Heading LIKE 'Disk %')

AND (Heading NOT LIKE 'Disk C%')

AND (Value >= 95.00)

AND (Metric = 64)

AND (UTCOccurrenceDateTime >= DATEADD(day, DATEDIFF(day, 0, GETUTCDATE()), 0))

GROUP BY Heading, Value, ServerName, Metric,

CONVERT(VARCHAR(10), UTCOccurrenceDateTime, 111)

HAVING(COUNT(Heading) < 2500000)

ORDER BY ServerName