cancel
Showing results for 
Search instead for 
Did you mean: 

Need a script to Create Custom report in NetBackup Opscenter Analytics

wtoo
Level 2

The Script should produce a backup report with the following tables

eg

Client HostnameLast Successful BackupSize of BackupLast Successful Restore
 ClientAFeb 18, 2018
9:03:20 AM
 130GBFeb 18, 2018
9:03:20 AM
    
    
    
    
1 REPLY 1

wtoo
Level 2

I need assistance to add last successful backup and last successful restore

SELECT
domain_JobArchive.clientName as 'Client',
domain_JobArchive.bytesWritten as 'Job Size',
UTCBigIntToNomTime(domain_JobArchive.startTime) as 'Start Time',
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time',
lookup_JobType.name as 'Job Type',
domain_JobArchive.throughPut as 'Throughput'
FROM domain_JobArchive, lookup_JobType
WHERE
domain_JobArchive.type=lookup_JobType.id
AND DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24
ORDER BY
lookup_JobType.name