List All Devices Which Have Not Been Seen During the Last 30 Days in Your Network
The larger a network, the harder it is to always know exactly which devices are in your network. Once multiple people start adding or removing devices for various reasons like repairs it can be hard to keep an overview of what is still active in your network at a given time. Find devices that might have network connectivity issues or which might have been removed unknowingly with this report.
Device Not Seen in the Last 30 Days Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType, tblAssets.Username, tblAssets.Userdomain, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, Coalesce(tsysOS.OSname, tblMacOSInfo.SystemVersion, tblLinuxSystem.OSRelease) As OS, tblAssets.SP, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID Where tblAssets.Lastseen < GetDate() - 30 And tblState.Statename = 'Active' Order By tblAssets.IPNumeric, tblAssets.Domain, tblAssets.AssetName