‎11-08-2019 10:16 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Description,
Max(Convert(date,tblQuickFixEngineering.InstalledOn)) As lastPatchDate,
tblAssets.Lastseen
From tblQuickFixEngineering
Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Not In ('') And IsDate(tblQuickFixEngineering.InstalledOn) =
1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Description,
tblAssets.Lastseen,
IsDate(tblQuickFixEngineering.InstalledOn)
Having Max(Convert(date,tblQuickFixEngineering.InstalledOn)) < GetDate() - 60
Order By lastPatchDate Desc
‎11-11-2019 06:11 PM
Select Top 1000000 tsysOS.OSname,
Count(tblAssets.AssetID) As Total
From tblQuickFixEngineering
Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tsysOS.OSname Not In ('') And tblAssetCustom.State = 1 And
IsDate(tblQuickFixEngineering.InstalledOn) = 1
Group By tsysOS.OSname
Having Max(Convert(date,tblQuickFixEngineering.InstalledOn)) < GetDate() - 60
Order By Total Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now