Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ufficioced
Champion Sweeper
I created a report for finding Asset Radar entries not present in any mac address previously scanned in some asset, do you think I did it right?

Here is the report I created:


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


0 REPLIES 0

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now