Systems Management (OpenView-OP Mgmt) Practitioners Forum
cancel

DB table for Templates on node

SOLVED
Go to solution
Piku
Acclaimed 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
Piku
Acclaimed Contributor.
Solution

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.
foresight
Respected Contributor.

Re: DB table for Templates on node

Can you share your solution?

 

 

tobias_m
Acclaimed Contributor.

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
Piku
Acclaimed 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.