DB table for Templates on node (385 Views)
Reply
Honored Contributor
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 1 of 5 (385 Views)
Accepted Solution

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.
Honored Contributor
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 2 of 5 (373 Views)

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
foresight
Posts: 33
Registered: ‎09-23-2011
Message 3 of 5 (362 Views)

Re: DB table for Templates on node

Can you share your solution?

 

 

HP Expert
tobias_m
Posts: 268
Registered: ‎05-06-2010
Message 4 of 5 (339 Views)

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
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 5 of 5 (329 Views)

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.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.