Systems Management (OpenView-OP Mgmt) Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

DB table for Templates on node

SOLVED
Go to Solution
Honored Contributor [Founder]

DB table for Templates on node

Dear Folks,

 

I have requirement to fetch the policies/templates assigned to each node, i can use ovpolicy command but this will give details is text form .

I required it in easy way direct from DB in tabular format.

having OMU 8.34

oracle 10g as DB

 

Thanks,

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
4 REPLIES
Honored Contributor [Founder]

Re: DB table for Templates on node

Hi All,

Able to find it by joining three different tables.

regards,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Frequent Advisor

Re: DB table for Templates on node

Can you share your solution?

 

 

HPE Expert

Re: DB table for Templates on node

Hello,

 

One way to get the node to policy assignments (after resolving node group and policy group assignments) is the Node Config Report:

# /opt/OV/bin/OpC/call_sqlplus.sh node_conf | more

 

Best regards,

Tobias

 

Honored Contributor [Founder]

Re: DB table for Templates on node

Hi,

I used below db query,

select a.NODE_ID,NODE_NAME,c.TEMPLATE_NAME,c.TEMPLATE_DESCR,a.TEMPLATE_ID,STATUS_FLAG from OPC_NODE_CONFIG a,OPC_NODE_NAMES b,OPC_SOURCE_TEMPL c where a.NODE_ID = b.NODE_ID and a.TEMPLATE_ID = c.TEMPLATE_ID

I will try for call_sqlplus.sh too.

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.