08-18-2015 07:49 AM
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 7.6.0.4
Solved! Go to Solution.
08-20-2015 06:22 AM
select
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
where
domain_jobarchive.type in (0)
and
lookup_policytype.id=domain_JobArchive.policyType
and
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <=1
and
domain_JobArchive.clientName like 'client1'
and
domain_JobArchive.clientName like 'client2'
and
domain_JobArchive.clientName like 'client3'
order by endTime desc
Thank you learnt a lot today :)
08-20-2015 06:38 AM
Thank goodness :)
08-20-2015 07:15 AM
file attached
08-20-2015 07:16 AM
file attached
I take we just add
and
domain_JobArchive.clientName like '%Client1%'
and a code to sort by date
08-20-2015 07:16 AM
file attached
08-20-2015 07:16 AM
see attached . Thanks again for all your help
08-20-2015 07:17 AM
output attached for 1 months rather than 3