‎04-14-2020 11:06 AM
Select Top 1000000
Case
When tblAssetRadarDevice.DeviceName Is Not Null Then
tblAssetRadarDevice.DeviceName
When tblAssetRadarDevice.MacAddress Is Not Null Then
tblAssetRadarDevice.MacAddress
Else ''
End As DeviceName,
tblAssetRadarDevice.DomainName,
tblAssetRadarDevice.MacAddress,
tblAssetRadarDevice.DiscoveredBy,
tblAssetRadarDevice.Ipv4Address,
tblAssetRadarDevice.Ipv6Address,
tblAssetRadarDevice.IpSubnet,
tblAssetRadarDevice.DefaultGateway,
tblAssetRadarDevice.Manufacturer,
tblAssetRadarDevice.FirstSeen,
tblAssetRadarDevice.LastSeen,
tblAssetRadarDevice.PingTtl,
tblAssetRadarDevice.Rtt
From tblAssetRadarDevice
where tblAssetRadarDevice.MacAddress NOT IN (Select tblNetwork.MACaddress FROM tblNetwork)
Order By tblAssetRadarDevice.LastSeen Desc,
tblAssetRadarDevice.MacAddress
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now