Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-16-2014 09:12 PM
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?
Any help?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-17-2014 05:42 PM
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%')
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-23-2014 01:12 AM
Perfect timing, was working on this myself this morning. Will keep this for future patch blunders.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-17-2014 05:42 PM
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%')