Backup Logs for last 3months for a server

Hi,

Here is a simple query that show ciient, policy name, status, end time. It only shows parent job result.

You can change the %Oracle% to match which ever policy you're looking to report on.

select
domain_JobArchive.clientName as 'Client',
domain_JobArchive.Statuscode as "Status",
domain_JobArchive.policyName as "Policy Name",
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
from domain_JobArchive
where
domain_jobarchive.type in (0)
and
domain_jobarchive.parentjobid=domain_jobarchive.id
and
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 3
and
domain_JobArchive.policyName like '%Oracle%'

Thanks Rian however the policy conatins so many clients and just need to report on 3 clients in the policy for the last 3 months

Ok,

Try

select
domain_JobArchive.clientName as 'Client',
domain_JobArchive.Statuscode as "Status",
domain_JobArchive.policyName as "Policy Name",
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
from domain_JobArchive
where
domain_jobarchive.type in (0)
and
domain_jobarchive.parentjobid=domain_jobarchive.id
and
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 3
and
domain_JobArchive.clientName like '%Client1%'

and
domain_JobArchive.clientName like '%Client2%'

and
domain_JobArchive.clientName like '%Client3%'

The report pulling back no data . not sure what am doing wrong

changed teh %Client1% to client names

tried the top one with the policy name and same thing , not pulling back any data
 

Tried using a client in the normal ms-windows type policy and the scripts seems to work . However the clients needed are in a Policy Type - Vmware

also would be nice to have another colum showing if the backup was a diff or Full backup if possible

Thank you for all your help

Lets stick with one client. I think I should maybe use OR and not AND.

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
domain_jobarchive.parentjobid=domain_jobarchive.id
and
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 3
and
domain_JobArchive.clientName like '%Client1%'

seems to be coming back with an error

OpsCenter-10881:Failed to execute specified SQL-- SQL Anywhere Error -131: Syntax error near 'domain_jobarchive' on line 16.

Sorry, I forgot one AND.

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
domain_jobarchive.parentjobid=domain_jobarchive.id
and
DATEDIFF(month,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 3
and
domain_JobArchive.clientName like '%Client1%'

Thanks Riaan The script seems to be now running but pulling back no data