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’ |