cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Report - VADP Client names

old_mate
Level 4
Partner Accredited Certified

OpsCenter 7.1 (Windows)

NBU 7.1.0.4 (Solaris)

Hi all,

I'm trying to run a restore report for all of our VMs which are backed up via VADP.

When running the restore report it will only list the recovery host (media server) as the client and not the actual name of the VM.

Does anyone know a way around this where I can get the actual client name?

Thanks!

6 REPLIES 6

bpdown
Level 4

I have the same issue. My whole environment is virtual and therefore I cannot do a meaningful restore report at all.

This seems like a big oversight from Symantec.

Can anyone test on NBU 7.5 please?

bpdown
Level 4

Anyone? Symantec employees?

MilesVScott
Level 6
Certified

Here is a basic one based on any archive job, but Im sure you will want to define the columns a bit more:

SELECT * FROM domain_JobArchive WHERE type = '2'

 

If you need anything else in the report let me know and I can see what I can do.

tom_sprouse
Level 6
Employee Accredited Certified

old mate,

First, Upgrade OpsCenter to 7.1.0.4 - as the OpsCenter host must me at or higher then the NBU host.

Secondly, it will depending on the report you are running.

If you have created a custom report / tabular - add the job directory column... this should tell you the information you are looking for.

Or, if you can provide details of what you are specifically looking for in the report, perhaps I can see if there is something canned, or custom I can offer.

--Tom

 

 

old_mate
Level 4
Partner Accredited Certified

Hi guys, 

Thanks for your assistance.

Unfortunately, neither of the suggestions resulted in obtaining the names of individual VMs which have been restored. 

Tom - I have upgraded to 7.1.0.4 and added the Job Directory column into a customised restore report. Within the Job Directory column only a / is displayed (No VM name).

Miles - With that SQL query, the Client name displays the recovery host (media server), not the VM that has been restored.

Basically looking for a restore report with the following info.

Master Server

Client Name

Job Start Time

Job End Time

Job size (MB)

Job Status Code

Exit Status

 

Thanks!

 

MilesVScott
Level 6
Certified

I have one other possibility but I havent been able to test this code much.

 

SELECT * FROM domain_Job WHERE id IN (SELECT id FROM domain_JobArchive WHERE type = '2')

 

Let me know if that looks somewhat correct...