# of updates per month

This report shows you the number of updates that were released each month for each product.

SELECT TOP (100) PERCENT CAST(DATEPART(YYYY, DateRevised0) AS CHAR(4)) + '/' + RIGHT(CAST(100 + DATEPART(MM, DateRevised0) AS CHAR(3)), 2) AS [Year/Month], Product0 AS Product, COUNT(*) AS Count
FROM dbo.v_HS_PATCHSTATEEX
WHERE (Severity0 > '5')
GROUP BY CAST(DATEPART(YYYY, DateRevised0) AS CHAR(4)) + '/' + RIGHT(CAST(100 + DATEPART(MM, DateRevised0) AS CHAR(3)), 2), Type0, Product0
HAVING (Type0 = 'microsoft update')
ORDER BY [Year/Month] DESC, Product

Leave a Reply