07-13-2010 02:51 PM
07-26-2010 07:52 AM
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
07-28-2010 05:15 AM
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