Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tsysOS.OSname, tblAssets.Description, tblAssets.Lastseen As [Last Seen], tsysOS.Image As icon From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssets.Lastseen < GetDate() - 30 And tblAssetCustom.State = 1 Order By [Last Seen] Desc, tblAssets.AssetName
Explore the full platform, free for 14 days.
No credit card required.