Count of HF by Month

This query will give you a count of all hot fixes by Month. Keep in mind that a hot fix will have multiply version for example Windows 2000, Windows 2003, Windows XP, etc.

select

            datepart (YY,daterevised0) as ‘Year’,

            datepart (MM,daterevised0) as ‘Month’,

            count(datepart (MM,daterevised0)) as ‘Count’

from

            v_GS_PATCHSTATEEX

Group by

            datepart (YY,daterevised0),

            datepart (MM,daterevised0)

Order by

            datepart (YY,daterevised0),

            datepart (MM,daterevised0)