cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
EOINT
Engaged Sweeper
I have browsed a quite a few posts and havent found the exact answer. I am looking to take the information from the Asset\Quickfix link and basically have a report that will list each asset with all the KB's/Hotfixes installed.

I know i can look for a specific KB, I can find a report on when an update was installed, but not all 3. I am not an expert on SQL - Itcould look like something like this

ASSETNAME - Update installed - Updates Installed (Listed)

Any help would be appreciated.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Hotfixes are stored in tables tblQuickFixEngineering and tblQuickFixEngineeringUni. You could use a report like the following example:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineering.InstalledOn
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID,
tsysOS
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblQuickFixEngineering.InstalledOn Desc

View solution in original post

2 REPLIES 2
sumatia
Engaged Sweeper II
Instead of listing all the hotfixes for one system, is it possible just to list when was the last update installed?
Daniel_B
Lansweeper Alumni
Hotfixes are stored in tables tblQuickFixEngineering and tblQuickFixEngineeringUni. You could use a report like the following example:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineering.InstalledOn
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID,
tsysOS
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblQuickFixEngineering.InstalledOn Desc