02-19-2016 09:48 AM
Is it possible to fetch
if yes any sql query , we need this details for differenr master server
Solved! Go to Solution.
02-22-2016 02:15 AM
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'
02-22-2016 02:15 AM
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'
02-24-2016 01:34 AM
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
02-24-2016 01:43 AM
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
02-24-2016 10:21 AM
Cool