Need a script to Create Custom report in NetBackup Opscenter Analytics

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