Cisco Prime Database Variables in CLI Template

[leonardomachado]

Is there any way to run a sql on the Cisco Prime Infrastructure DB? How? Any map of the database tables available? I would like to create my own query.

[balaji.bandi]

As for as i know Prime run PGSQL as a database, not sure we can able to access the Database, but we do have shell access to look at it, never tried myself, not cisco suggest to play with DB adding or removing any fields as they are fixed schema.

[leonardomachado]

I found many orcle process running.

There is a sqlplus in /opt/oracle/ase/product/12.1.0/dbhome_1/bin/

But if I run sqlplus it ask me to set ORACLE_HOME. I am playing with diffent homes by now.

[balaji.bandi]

Sure you can play at risk, as mentioned it is not suggested, but if not in production or can take the risk, bear in mind if you upgrade the schema will overwrite the chages.

[leonardomachado]

I just want to test some queries and reverse engeneering the database schema. I could not find the database schema picture anyware. I would never dare to input changes into the schema.

[leonardomachado]

Do you know any good tutorial to show how to create advanced templates in Cisco Prime using DB Variables?

[balaji.bandi]

not tried it, some document may help ypu :

https://www.cisco.com/c/en/us/td/docs/net_mgmt/prime/infrastructure/3-1/user/guide/pi_ug/config-temp.html