Never mind, I just realized out that I was missing the IP contained in tblAssets (tblAssets.IPAddress) Regards,RAA wrote:Is there any other table keeping IP addresses information for my assets other than tblNetwork and tblLinuxNetworkDetection? I'm ...
Is there any other table keeping IP addresses information for my assets other than tblNetwork and tblLinuxNetworkDetection? I'm running my query using a SQL UNION, which should be good enough to get all IPs but I'm missing some assets IPs (some of th...