→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
abustraan
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
abustraan
Engaged Sweeper III
That's Awesome!!
Hemoco
Lansweeper Alumni
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
@Lansweeper... This worked for me!
abustraan
Engaged Sweeper III
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
Lansweeper Alumni
Are you trying to list computers with or without the specified update? The 4.2 report lists computers without the specified update.