DB table for Templates on node (252 Views)
Reply
Honored Contributor
Piku
Posts: 3,687
Registered: ‎06-17-2010
Message 1 of 5 (252 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,687
Registered: ‎06-17-2010
Message 2 of 5 (240 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: 32
Registered: ‎09-23-2011
Message 3 of 5 (229 Views)

Re: DB table for Templates on node

Can you share your solution?

 

 

Please use plain text.
HP Expert
tobias_m
Posts: 200
Registered: ‎05-06-2010
Message 4 of 5 (206 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,687
Registered: ‎06-17-2010
Message 5 of 5 (196 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