‎03-07-2018 02:55 PM
Solved! Go to Solution.
‎03-07-2018 07:43 PM
‎03-07-2018 07:43 PM
‎03-07-2018 04:48 PM
‎03-07-2018 04:43 PM
‎03-07-2018 04:27 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName As Asset,
tblAssets.Domain,
tblAssetCustom.Manufacturer As Make,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Username As [User],
tblAssets.Firstseen As [First Seen],
tblAssets.Lastseen As [Last Seen],
tblAssetCustom.PurchaseDate As [PC Purchase Date],
tblAssetCustom.Warrantydate As [Warranty End Date],
DateAdd(year, 5, tblAssetCustom.PurchaseDate) As [Replacement Date],
Max(tblQuickFixEngineering.Lastchanged) As [Last Patch Detected]
From tblAssets
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Group By tsysOS.Image,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname,
tblAssets.Username,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
Order By Asset
‎03-07-2018 03:56 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now