Which PCs are missing Hotfixes?

I was discussing with a friend how to determine the over all hot fix complicacy level, the other day, hence yesterday’s query. But what I wondering was why my test lab was not at 100% compliancy.  It will take a while for that to happen only because I have not rolled out IE 7 to Windows XP systems yet. Anyways I used this query to determine which PCs were not up to date.

 

SELECT CS.Name0,

Patch.ID0,

Patch.Product0,

Patch.Severity0,

Patch.Status0,

Patch.TimeAuthorized0,

Patch.TimeDetected0,

Patch.Title0,

Patch.Type0

FROM   v_GS_COMPUTER_SYSTEM CS,

v_GS_PATCHSTATEEX Patch

WHERE            Patch.ResourceID = CS.ResourceID

AND Patch.Status0<>’Installed’

Leave a Reply

Your email address will not be published. Required fields are marked *