How do I get a list of my elements by IP?

Document ID : KB000044003
Last Modified Date : 14/02/2018
Show Technical Document Details


How would I see all of my elements by IP address to see how many actual devices I have discovered?



The easiest way to find the information you want is with a SQL query.

All of the details about your elements are stored in the NH_ELEMENT table.

Here is the query you would use to list the number of the distinct IP addresses excluding any with

·         You will need to source your eHealth environment and be logged in as NH_USER.

$NH_HOME/bin/sys/nhisql "select distinct formatted_ip_address from nh_element"|grep -v ""|wc –l

If you wanted to see the actual addresses themselves you could use this query:

$NH_HOME/bin/sys/nhisql "select distinct formatted_ip_address from nh_element"|grep -v ""

Additional Information:  

See the eHealth administration guide