This converted the date but now I need to count...

SELECT

CONVERT(VARCHAR(10), UTCOccurrenceDateTime, 111)

FROM Alerts

WHERE (Heading LIKE 'Disk %') AND (Heading NOT LIKE 'Disk C%') AND (Value >= 95.00)

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

GROUP BY Heading, Value, ServerName, UTCOccurrenceDateTime

HAVING (COUNT(Heading) < 2500000)

ORDER BY UTCOccurrenceDateTime, ServerName