cancel
Showing results for 
Search instead for 
Did you mean: 

OPS center - documentation for table of DB

Hello,
i'm new on NBU. I have tried to do some reports using OPSCenter but the template reports does not contain the info i need.

I have looked in the documentation if there is a list of table/columns for report based on my SQL. I haven't found anything ...

I have read in a post that when report is displayed i can see the sql with a button... i haven't found the button!

Can anyone help me?

OPSCenter 7.0 running on windows system.


Thanks,
Sergio
4 Replies

OpsCenter Analytics license

OpsCenter Analytics license is required for custom SQL, or so I believe. You would then have the "famous" button to see what SQL query is executed.

/A

This button exists in VBR,

This button exists in VBR, but not in OpsCenter.

So, how we could find SQL


So, how we could find SQL tables in OpsCenter?

Thanks,

Baris

perhaps i have a

perhaps i have a workaround:
in opscenter server, under C:\Program Files\Symantec\OpsCenter\server\db there is a zip named db_sqls.zip. inside the zip, there is the folder "70" and inside this the file named schema.xml


In this file you have all the table of opscenter.

i know, this is only a workaround ...

sergio