Pablo
SELECT CONVERT(VARCHAR(20), TimeAdded, 102) AS DayAdded, COUNT(*) AS NumAlertsPerDay
FROM Alert WITH (NOLOCK)
WHERE TimeRaised is not NULL
GROUP BY CONVERT(VARCHAR(20), TimeAdded, 102)
ORDER BY DayAdded DESC
2018.09.12 589
2018.09.11 1430
2018.09.10 776
2018.09.09 2013
2018.09.08 882
2018.09.07 1032
2018.09.06 996
2018.09.05 3082
2018.09.04 127
2018.09.03 16
2018.09.02 6
2018.09.01 3