Jetzt Ausprobieren

New Devices Found in the Last 24 Hours Audit

Hardware History Security

Find New Devices in Your Network

Keep track of all new devices discovered in the last 24 hours. 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 know what has entered your network, you can check whether these devices were expected or if an uninvited guest joined your LAN. New devices found in the last 24 hours

New Devices Found in the Last 24 Hours Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssets.Firstseen > GetDate() - 1 And tblAssetCustom.State = 1
  And tblAssets.Assettype <> -1 And tblAssets.Assettype <> 66
Order By tblAssets.AssetName

Show

Hide