截屏视频帮助

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

创建时间: 07 10 月 2012 | 5 条评论
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'

评论 条评论跳转至最新评论

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

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

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

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

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