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