→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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