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 Honored Contributor

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 Honored Contributor

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

 

Highlighted
Honored Contributor Honored Contributor

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.