cancel
Showing results for 
Search instead for 
Did you mean: 

extract job data from BEDB database

Alun_Rodgers
Level 4
Hi,
 
I've been asked to produce a list of all remote servers backed up by specific jobs (upwards of 20 jobs running on 5 media servers) and the amount of data backed up by each job sub totalled for each remote server.
 
Does anyone know if any of the tables/views in the BEDB database will be able to produce that info?
 
I have found the vwJobHistorySummary2ProtectedServer view which shows all the remote servers and can be sorted by Job name; but the TotalDataSizeBytes field only lists the total for the job rather than by each server backed up.
 
Thanks,
 
Alun.
1 REPLY 1

Ken_Putnam
Level 6
To get what you want, I think you'll have to parse the job logs