Video Screencast Help

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

Created: 07 Oct 2012 | 5 comments
ESM_Admin's picture

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'

 

 

 

Discussion Filed Under:

Comments 5 CommentsJump to latest comment

tom_sprouse's picture

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

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

 

tom_sprouse's picture

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

 

 

 

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

 

ESM_Admin's picture

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