How to Find Out Which Group Is Created on What Backend Poller in an Ehealth Cluster?

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

Usually a user would like to know which group is created on what backend poller in an ehealth Cluster. This article answers this question.

Question:

How to Find Out Which Group Is Created on What Backend Poller in an Ehealth Cluster?

Environment:
ehealth cluster
Answer:

INSTRUCTIONS

  1. Start sqlplus

    In Windows:  sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%
    In Solaris/Linux:  sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING
  2. Enter the following query to retrieve the group and the machine information.
     
    select g.name as group_name,m.name as machine_name 
    2 from nh_group g, nh_machine m 
    3 where g.machine_id=m.machine_id; 
     
    QUERY OUTPUT
     
    The table below shows an example of the output the query might display. 
    It shows that a group named EventSourceAll is created on a machine named test1 and another group devendraWanInterfacel is created on a machine named test2. 
     
    GROUP_NAME                             MACHINE_NAME 
    ---------------------------------------------------------------- 
    EventSourceAll                            test1 
    devendraWanInterface                 test2