Report Showing Security Update KB3008923

[RTI_IT]

I need a report that shows all computers with the Microsoft Security Update KB3008923. This update is known to break CRM products and is affecting one of our apps. I see there is LS built in report for KB963093, I need that same thing but for KB3008923.

Any help?

[novasam]

Perfect timing, was working on this myself this morning. Will keep this for future patch blunders.

[RCorbeil · Accepted solution]

If you want to list machines with particular KB updates in place, you can do it like this:

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
FROM
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
  tblAssetCustom.State = 1
  AND Exists (SELECT
                tblQuickFixEngineering.AssetID
              FROM
                tblQuickFixEngineering
                Left Join tblQuickFixEngineeringUni ON tblQuickFixEngineeringUni.QFEID = tblQuickFixEngineering.QFEID
              WHERE
                tblQuickFixEngineering.AssetID = tblAssets.AssetID
                And tblQuickFixEngineeringUni.HotFixID LIKE 'KB3008923%')