How to find your overall hot fix compliancy rate

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’