‎08-08-2013 01:19 AM
Solved! Go to Solution.
‎08-09-2013 07:01 PM
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
‎08-09-2013 07:05 PM
‎08-09-2013 07:01 PM
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
‎08-23-2021 05:54 PM
‎08-09-2013 06:37 PM
‎08-09-2013 06:17 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now