Keep track of all new devices discovered in the last 7 days. Check which new devices have entered your environment. With the new bring your own device culture and with the increased mobility of computers, it is hard to keep track of what devices connect to your networks. This report will help you get more insight into what enters the network. New unknown devices could also lead to security breaches in the worst cases, so it is more important than ever to know what is in your network. Find what’s new in your network, and check whether it is expected or not.
New Devices Found in the Last 7 Days Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Location,
tblAssets.IPAddress,
tblAssets.Firstseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.Firstseen > GetDate() - 7 And tblAssetCustom.State = 1
And tblAssets.Assettype <> -1 And tblAssets.Assettype <> 66
Order By tblAssets.AssetName
