We run the "Application Availability - Last Month" report every month. This month it just keep showing February, instead of January.
Can somebody explain why that would be happening? Here is the SQL form report writer:
DECLARE @utcOffset int
DECLARE @actualMonths int
SET @utcOffset = datediff(minute, getdate(), getutcdate())
SET @actualMonths = datediff(month, 0, getdate())
SELECT
max(APM_ApplicationStatus.[TimeStamp]) as [Month],
Nodes.Caption,
APM_Application.Name AS ApplicationName,
sum(APM_ApplicationStatus.PercentAvailability * APM_ApplicationStatus.RecordCount) / sum(APM_ApplicationStatus.RecordCount) AS PercentAvailability
FROM APM_ApplicationStatus with(nolock)
INNER JOIN APM_Application with(nolock) ON APM_Application.ID = APM_ApplicationStatus.ApplicationID
INNER JOIN Nodes with(nolock) ON Nodes.NodeID = APM_Application.NodeID
WHERE APM_ApplicationStatus.[TimeStamp] >= dateadd(minute, @utcOffset, dateadd(month, @actualMonths - 1, 0)) AND
APM_ApplicationStatus.[TimeStamp] < dateadd(minute, @utcOffset, dateadd(month, @actualMonths, 0))
GROUP BY APM_Application.ID, APM_Application.Name, Nodes.Caption
ORDER BY Nodes.Caption, APM_Application.Name
