DB table for Templates on node (379 Views)
Reply
Honored Contributor
Piku
Posts: 4,072
Registered: ‎06-17-2010
Message 1 of 5 (379 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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Honored Contributor
Piku
Posts: 4,072
Registered: ‎06-17-2010
Message 2 of 5 (367 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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Frequent Advisor
foresight
Posts: 33
Registered: ‎09-23-2011
Message 3 of 5 (356 Views)

Re: DB table for Templates on node

Can you share your solution?

 

 

HP Expert
tobias_m
Posts: 258
Registered: ‎05-06-2010
Message 4 of 5 (333 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,072
Registered: ‎06-17-2010
Message 5 of 5 (323 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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
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.