DB table for Templates on node (273 Views)
Reply
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 1 of 5 (273 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,

Please use plain text.
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 2 of 5 (261 Views)

Re: DB table for Templates on node

Hi All,

Able to find it by joining three different tables.

regards,
Please use plain text.
Frequent Advisor
foresight
Posts: 33
Registered: ‎09-23-2011
Message 3 of 5 (250 Views)

Re: DB table for Templates on node

Can you share your solution?

 

 

Please use plain text.
HP Expert
tobias_m
Posts: 214
Registered: ‎05-06-2010
Message 4 of 5 (227 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

 

Please use plain text.
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 5 of 5 (217 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,
Please use plain text.
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