Is there anyone who remember how can we obtain a list of devices in a group with Ip address trough the command line in eHealth??
You'll have to build a join.
select b.name as group_name, a.name as element_name, a.alias as element_alias, a.formatted_ip_address from nh_element a, nh_group b, nh_group_members c where
b.name='Your_group' andb.group_id=c.group_id and a.element_id=c.element_id;
Can you rephrase the question?
Otherwise, the followings apply:
- A list of devices within a certain group 'nhListElements -inGroup GROUPNAME'. 'nhGroup -list' to get a listing of all groups.
- A list of elements with certain properties 'nhListElements -where ipAddr ="220.127.116.11". Also nhListElements -showDciFields will tell you what are the properties on which you can filter by the clause '-where'. nhListElements -h would display some useful examples.
Or maybe this can help you.
No. The nhListElements only give a list of name of devices, nothing else. I dont't need find anything. I found this command but I can't filter by group:
$NH_HOME/bin/sys/nhisql "select name,formatted_ip_address from nh_elemes";
Anyway, thank you for your help. I forget a lot of thing of eHealth application....
Retrieving data ...