We are going through an Audit and I need to show the backup logs for 3 servers i backup with Netbackup for the last 3 months . Any idea how i can do this from ops center . cannot see any out of the box reports in there . I am using Ops center 18.104.22.168
Solved! Go to Solution.
domain_JobArchive.clientName as 'Client',
domain_JobArchive.Statuscode as "Status",
domain_JobArchive.policyName as "Policy Name",
domain_JobArchive.ScheduleName as "Schedule Name",
lookup_policytype.name as "Policy Type",
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
from domain_JobArchive, lookup_policytype
domain_jobarchive.type in (0)
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <=1
domain_JobArchive.clientName like 'client1'
domain_JobArchive.clientName like 'client2'
domain_JobArchive.clientName like 'client3'
order by endTime desc
Thank you learnt a lot today :)