cancel
Showing results for 
Search instead for 
Did you mean: 

opscenter analytics

rookie11
Moderator
Moderator
   VIP   

Hello all,

i hav opscenter anaytics 7.6.0.1 I need a customized report which contains all clients, policies, backup start time end time and average run time for backups. please help

3 REPLIES 3

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Try this one

 

select
NOM_DateDiff(domain_JobArchive.startTime, domain_JobArchive.endTime) as "JobDuration",
domain_JobArchive.clientName as 'Client',
domain_JobArchive.filesBackedUp as "Files",
domain_JobArchive.throughput as "Throughput",
domain_JobArchive.scheduleType as "Schedule Type",
domain_JobArchive.scheduleName as "ScheduleName",
domain_MasterServer.friendlyName as "MasterServer",
domain_JobArchive.policyType as "Policy Type",
domain_JobArchive.policyName as "Policy Name",
(domain_JobArchive.preSISSize)/1024 as "Protected",
adjust_timestamp(domain_JobArchive.startTime,14400000 ) as "Start Time",
adjust_timestamp(domain_JobArchive.endTime,14400000 ) as "End Time",
(domain_JobArchive.bytesWritten)/1024 as "KbytesWritten",
nb_JobBackupAttributesArchive.destStorageUnit as "Storage Unit"
from domain_JobArchive left outer join nb_JobArchive nb_JobArchive on domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id left outer join nb_JobArchive a1 on domain_JobArchive.masterServerId = a1.masterServerId and domain_JobArchive.clientName = a1.clientName and domain_JobArchive.id = a1.id left outer join nb_JobBackupAttributesArchive nb_JobBackupAttributesArchive on domain_JobArchive.masterServerId = a1.masterServerId and domain_JobArchive.clientName = a1.clientName and domain_JobArchive.id = a1.id AND a1.masterServerId = nb_JobBackupAttributesArchive.masterserverId and a1.clientName = nb_JobBackupAttributesArchive.clientName and a1.id = nb_JobBackupAttributesArchive.jobId inner join domain_Policy domain_Policy on domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo inner join domain_MasterServer domain_MasterServer on domain_MasterServer.id = domain_JobArchive.masterServerId
where ( ( (domain_JobArchive.isValid = '1') AND (domain_JobArchive.filesBackedUp NOT IN (0 ) AND (domain_JobArchive.policyType NOT IN (-1, 34 )) AND (domain_JobArchive.type NOT IN (30, 31, 32, 33, 34 )) ) AND ( (domain_JobArchive.type IN (1, 0, 7, 6 )) ) ))
ORDER BY UPPER("domain_MasterServer"."friendlyName" ) ASC , "Start Time" ASC , "domain_JobArchive"."id" ASC

VoropaevPavel
Level 4
Partner Accredited

Hi Riaan,

Just wondering, did you create this query by custom report? On which OpsCenter version?

Joining syntax looks different.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

I created it myself using custom SQL query (i don't know SQL btw). My opscenter is 7.6.0.1.