cancel
Showing results for 
Search instead for 
Did you mean: 

Sql query for no of jobs

Pangal
Level 5

Is it possible to fetch 

 

  • Number of NetBackup job during the year 2015
  • Number of failed and partially successful jobs during the year 2015

 

if yes any sql query , we need this details for differenr master server

1 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Very simplistic, you can modify as required.

 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000'

 

and 

 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode not in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000'

View solution in original post

4 REPLIES 4

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Very simplistic, you can modify as required.

 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000'

 

and 

 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode not in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000'

Pangal
Level 5

Thanks riaan , i will update you with the results soon

for specific master server 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000' and domain_MasterServer.id

=247

 

Pangal
Level 5

corrections

 

select
count (domain_jobarchive.statuscode)
from domain_jobarchive
where domain_jobarchive.statuscode in (0)
and
domain_JobArchive.endTime BETWEEN '142007040000000000' AND '145160640000000000' and domain_jobarchive.masterServerId=247

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Cool