Create custom SQL query in OpsCenter

[zumatech]

Has anyone been able to create a custom SQL query in Netbackup OpsCenter? Whatever SQL query I enter when I try to create a new report, it would say "Enter a valid query." What does Symantec consider valid? For example, is this query valid?

select * from backupfinaljob

This query isn't valid either. Can someone give me an example of a valid query?

[AAlmroth]

As far as I know, there is no such table/view in OpsCenter. It existed in VBR, but doesn't seem to exist in OpsCenter.
I think you will have to get the new db schema for OpsCenter, as you cannot expect VBR names anymore.

Perhaps you could try to use nb_Job to get the jobid, then go to nb_JobAttempLog to get the attemptID, followed by the corresponding nbJobAttempt.

Or use the nom_NBJob view, and look for the highest AttemptNumber (which I guess would be the final job try).

Probably doesn't answer your question fully though...

/A
 

[Andy_C]

Check out my blogg on Media reports at https://www-secure.symantec.com/connect/blogs/creating-media-usage-reports 

PM me If you would like me to send you a list of tables, views or procedures.

Regards,

Andy C