02-21-2018 02:27 AM
The Script should produce a backup report with the following tables
eg
Client Hostname | Last Successful Backup | Size of Backup | Last Successful Restore |
ClientA | Feb 18, 2018 9:03:20 AM | 130GB | Feb 18, 2018 9:03:20 AM |
02-27-2018 02:02 AM
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