Use this query to find your overall hot fix compliancy rate.


Keep in mind that there are a few things that will affect this rate, for example:

         Delete Aged Inventory History setting

         Delete Obsolete Client Discovery Data setting



Set Nocount OFF

Declare @Installed as int

Declare @Total as int

Declare @Per as Float


set @Installed = (SELECT SUM(CASE WHEN patch.Status0 = ‘Installed’ THEN 1 ELSE 0 END) as ‘Installed’ FROM v_GS_PATCHSTATEEX  patch)

set @Total = (SELECT count(patch.Status0)FROM v_GS_PATCHSTATEEX  patch)

set @Per = (select Sum(@installed*100/@total))


SELECT @Installed as ‘Installed’,

            @total as ‘Total’,

            @Per as ‘Percent’