2 queries

Aftab Ashiq

• February 28, 2023 05:52

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.

 

0

• 

  Wahi Narsisian

  • February 28, 2023 07:26

  Hello Aftab,

  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
• 

  Aftab Ashiq

  • February 28, 2023 07:36
  • Edited

  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
• 

  Wahi Narsisian

  • February 28, 2023 09:23

  Hello Aftab,

  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

  select d.name

  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:

  https://D42_IP/admin/rackraj/tools/d42viewer/doql/

  Replacing the D42_IP with your appliance IP or DNS

  And use “,” as column separator

  

  0

Please sign in to leave a comment.