I have an identical one running in a python script that returns around 26k values, however the exact same query in the app only returns around 14k values. I also enabled debug logging & don't see any errors.
My query is as follows:
SELECT IPAddress AS ip, SubnetId, DhcpClientName as dns, ToLower(MAC) AS mac FROM IPAM.IPNode WHERE mac IS NOT NULL
Python code:
qr = swis.query("SELECT IPAddress AS ip, SubnetId, DhcpClientName as dns, ToLower(MAC) AS mac FROM IPAM.IPNode WHERE mac IS NOT NULL")
Any advice on next steps to troubleshoot would be appreciated.
... View more