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

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

Summary:   

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

 

Instructions: 

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 0.0.0.0.

·         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 "0.0.0.0"|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 "0.0.0.0"
 

Additional Information:  

See the eHealth administration guide

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1878245.aspx