Video Screencast Help

Where can i find sql code behind each report?

Created: 26 Mar 2010 • Updated: 29 Oct 2010 | 3 comments

You know, i think its fantastic that symantec allows us to create custom reports, even down to the sql level. However, it would be VERY helpful if when we go to create a new report, that we could copy the sql code off of a previous report to modify. Does anyone know where this information can be found? Does support provide these? If they don't, should we add this as an idea?

Comments 3 CommentsJump to latest comment

Zenshai's picture

You can find any SQL that VBR executes through the portal in the server logs. The most recent log will be found under <VBRDIR>\Server\Logs\vbr-web0.0.log, I'd suggest running your report and immediately opening it up.

The only thing is that you will notice the parameters are passed in separately so you will have to reinsert them into your SQL before the query is able to run independently.

Symboy's picture

If you are using NOM , you have a check box on the left "Show Query " . Unfortunately I don't see that option in Opscenter .

Note: If this post provides you with a solution don't forget to mark the discussion as solved.

Carlos V's picture

I have VBR, and need to create a report about the schedules of our policies, to determine our backup window.  How can I do that?