cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RTI_IT
Champion Sweeper
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?
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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%')

View solution in original post

2 REPLIES 2
novasam
Engaged Sweeper III
Perfect timing, was working on this myself this morning. Will keep this for future patch blunders.
RCorbeil
Honored Sweeper II
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%')