Query 1 :
How to filter IP address in the below table, I need to able to find cells in the IP address column which are empty, When i try to filter i get the below window, I cannot filter the IP address column using this. Please let me know.
Query 2 :
We are also seeing that the IP addresses are getting mismatched, We have upgraded to the latest version as well.
Please help on these 2 issues.
Just to clarify the question N1, are you referring to the devices where IP address column is empty, in other word no IP address is associated with them?
For the second question, please open a support ticket and provide more details and we are glad to assist.0
Hi Wahi ,
Thank you for your response
For N1, Yes, like this , Please see below . We just need to know how we can filter the empty cells on the IP address column
For the second query, I have been told that a ticket has been raised by my colleague, He is following up.0
You cannot filter by IP is NULL on the UI, as this filter is intended to use some values. But this can be accomplished very easily using this DOQL
from view_device_v1 d
left join view_ipaddress_v1 ip on ip.device_fk = d.device_pk
where ip.ip_address is null
this will list all devices where no IP associated with them.
To run the query please use the following URL:
Replacing the D42_IP with your appliance IP or DNS
And use “,” as column separator0
Please sign in to leave a comment.