Highlighted
Micro Focus Expert
Micro Focus Expert
539 views

Support Tip: How to find a node with known core id?

Jump to solution
How to find node hostname, label in OMU (Operations Manager for Unix) database based on core id?
 
The OM (Operations Manager) agent core ID is stored in "agent_id" column of "opc_nodes" table in OMU database.
 
To find out node hostname and label by coreid (core id) use the following SQL query:
 
echo "select n.agent_id, n.label, nn.node_name \
from opc_nodes n, opc_node_names nn \
where n.node_id=nn.node_id(+) and n.agent_id='CORE_ID';" | \
/opt/OV/bin/OpC/opcdbpwd -e sqlplus -s
 
Replace the 'CORE_ID' (in quotes) with real OM agent core id.
 
Also use the following command later to verify it:
/opt/OV/bin/OpC/utils/opcnode -list_id node_name=<put_node_name_here>
 
This command will fetch node’s CoreID on the OMU management server.
Micro Focus Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
If you liked it I would appreciate KUDOs. Thanks
1 Solution

Accepted Solutions
Micro Focus Contributor
Micro Focus Contributor

Re: Support Tip: How to find a node with known core id?

Jump to solution

Good Info Vlad!

 

Regards,

 

Alex.

Alex Herrera
OMU support
TSIA Certified Support Professional (Chris Reed)
aleherma@hp.com

HP Software values your feedback regarding your overall Support experience. Contact us at software.satisfaction@hp.com or my manager directly.



View solution in original post

0 Likes
3 Replies
Micro Focus Contributor
Micro Focus Contributor

Re: Support Tip: How to find a node with known core id?

Jump to solution

Good Info Vlad!

 

Regards,

 

Alex.

Alex Herrera
OMU support
TSIA Certified Support Professional (Chris Reed)
aleherma@hp.com

HP Software values your feedback regarding your overall Support experience. Contact us at software.satisfaction@hp.com or my manager directly.



View solution in original post

0 Likes
Jeroen Peereboom Acclaimed Contributor.
Acclaimed Contributor.

Re: Support Tip: How to find a node with known core id?

Jump to solution
I created an sql-report for this, such that call_sqlplus.sh can be used.

It is a pity opcnode -list_nodes does not accept id=<core_id> as selection mechanism.
Maybe in a future release?

JP
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Support Tip: How to find a node with known core id?

Jump to solution

Hi Jeroen,

 

Thanks for your input.

I will check if any ER already exist for this.

If none, we can definitely create one for it.

 

 

 

Micro Focus Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
If you liked it I would appreciate KUDOs. Thanks
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.