# 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