Report for KB Articles

[abustraan]

There is a solved question for creating a report for finding a specific Windows Update but it is for the older version of Lansweeper.

SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description,
dbo.TsysLastscan.Lasttime AS Lastscanned
FROM dbo.tblComputers INNER JOIN
dbo.TsysLastscan ON dbo.tblComputers.Computername = dbo.TsysLastscan.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputers.Computername NOT IN
(SELECT computername
FROM tblquickfixengineering
WHERE hotfixid = 'KB958644')) AND (dbo.TsysLastscan.CFGname = 'QUICKFIX')
ORDER BY dbo.tblComputers.Domain, dbo.tblComputers.Computername

I've tried substituting Table the table: upgrade_tblcomputers but apparently it doesn't have the same fields.

Any help?

[abustraan]

That's Awesome!!

[Hemoco · Accepted solution]

A sample report can be seen below. Replace YourFix with the hotfix ID you would like to report on.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineering.InstalledOn,
tblQuickFixEngineeringInstalledBy.InstalledBy,
tblQuickFixEngineering.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Inner Join tblQuickFixEngineeringInstalledBy
On tblQuickFixEngineeringInstalledBy.InstalledByID =
tblQuickFixEngineering.InstalledByID
Where tblQuickFixEngineeringUni.HotFixID = 'YourFix' And tblAssetCustom.State =
1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblQuickFixEngineering.Lastchanged Desc

[kingdwight]

@Lansweeper... This worked for me!

[abustraan]

Utimately it would be systems with a specified update. There is an update that causes a known issue with one of our software programs and I was trying to track down which systems have the update so I can uninstall it and set it to ignore.

[Hemoco]

Are you trying to list computers with or without the specified update? The 4.2 report lists computers without the specified update.