tom@techcolumnist:~$

~/2007/08/01/of-updates-per-month.md

# of updates per month

---
author: 
date: 
read: 1 min
tags: [reporting, sms2003]
---

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