Chain of custody report...showing backup image ID and Media ID

[ESM_Admin]

Hello folks,

I have a situation where I need to create a report in Opscenter to generate the following type of report. This report used to be available on VBR but its not available on Opscenter 7.x

PLEASE HELP!!!

Report on backup client to show the following:-

Job ID,

Status,

Master Server

Media Server

Backup Start/End time

Backup Image name

Copy #

Media ID on which the backup image is written to

Pool name on which the backup image is written to if it is written on 'disk storage'

[ESM_Admin]

bump! anything guys?

[tom_sprouse]

ESM_Admin,

I have been working on custom SQL for several issues, and believe this can be done....

I will update once I am able to get this one ironed out.

--Tom

[ESM_Admin]

I'll be watching this thread!

[tom_sprouse]

ESM,

I wanted to provide something, but I am still having a hard time with the following

• --- mediaid (as there maybe more then 1 per backup id) 
• --- volume pool (tied to media id)
• --- copy number

However, I was able to write the following, which may be of use...providing most of what you had asked for.

SELECT

domain_job.id AS "Job Id", 

domain_job.statuscode AS "Status Code", 

domain_masterserver.friendlyname AS "Master Server", 

domain_job.mediaservername AS "Media Server", 

UTCBigintToUTCTime(domain_job.starttime) AS "Job Start Time", 

UTCBigintToUTCTime(domain_job.endtime) AS "Job End Time", 

domain_image.id AS "Backup ID"



FROM domain_job

JOIN domain_masterserver

ON domain_job.masterserverid = domain_masterserver.id

JOIN domain_image

ON domain_job.id = domain_image.jobid

[ESM_Admin]

Hi Tom,

Appreciate your efforts!

i will try this one out but I really need the one with media ID.

It was available in VBR... too bad its not there anymore in Opscenter....i will reply back as well if I find out.

TY