Number of alerts raised per day for last 28 days


/*Number of alerts raised per day for last 28 days.*/
USE OperationsManagerDW
SELECT CONVERT(VARCHAR(10), DBCreatedDateTime, 101) AS Date, COUNT(*) AS Alerts
FROM  Alert.vAlert
WHERE (DBCreatedDateTime BETWEEN DATEADD(day, -27, GETDATE()) AND GETDATE())
GROUP BY CONVERT(VARCHAR(10), DBCreatedDateTime, 101)
ORDER BY Date DESC

Back to SQL queries main menu


Comments (2)

  1. Hi Lisa,

    No problem.  Just replace the WHERE clause in the above statement from:

    WHERE (DBCreatedDateTime BETWEEN DATEADD(day, -27, GETDATE()) AND GETDATE())

    To:

    WHERE (CONVERT(VARCHAR(10), DBCreatedDateTime, 101) BETWEEN ‘DD/MM/YYYY’ and ‘DD/MM/YYYY’)

    Just plug in your date range.

    -Jonathan

  2. lisa says:

    Hi, Jonathan

    Do you know how to specify the data range instead of the last 28 days? for example from Nov 1 to Nov. 28