cancel
Showing results for 
Search instead for 
Did you mean: 

Backup Logs for last 3months for a server

yobole
Level 6

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

26 REPLIES 26

yobole
Level 6

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 :)

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Thank goodness :)

yobole
Level 6

file attached

yobole
Level 6

file attached

I take we just add

and
domain_JobArchive.clientName like '%Client1%'

 

and a code to sort by date

 

 

yobole
Level 6

file attached

yobole
Level 6

see attached . Thanks again for all your help

yobole
Level 6

output attached for 1 months rather than 3