04-23-2013 06:31 PM
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!
04-28-2013 11:13 PM
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?
05-21-2013 11:01 PM
Anyone? Symantec employees?
05-31-2013 06:49 AM
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.
05-31-2013 09:41 AM
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
06-02-2013 05:14 PM
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!
06-03-2013 07:00 AM
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...