cancel
Showing results for 
Search instead for 
Did you mean: 

OPS center - documentation for table of DB

scerreti
Level 4
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 4

AAlmroth
Level 6
Partner Accredited
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

Christoph_Linde
Level 5
Employee
This button exists in VBR, but not in OpsCenter.

klimt84
Not applicable

So, how we could find SQL tables in OpsCenter?

Thanks,

Baris

scerreti
Level 4
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