Find All New Computers That Entered Your Network in the Last Week
Check which new devices have entered your IT 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. Once you have the information, you can check whether the new computers were expected on uninvited strangers.
New Computers Found in the Last 7 Days Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tsysOS.Image As icon,
tblAssets.Firstseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Firstseen > GetDate() - 7 And tblAssetCustom.State = 1
Order By tblAssets.Firstseen Desc,
tblAssets.AssetName
