11-28-2019 03:26 PM
Hi Everyone, how are you?
I'm running this query and is returning me with the start and end time totally different from OpsCenter itself, can you help me?
select domain_jobarchive.clientname as "Client"
,nb_jobdbinstancearchive.dbname as "Database"
,"DBA"."UTCBigintToUTCTime"(domain_jobarchive.starttime) as "Start Time"
,"DBA"."UTCBigintToUTCTime"(domain_jobarchive.endtime) as "End Time"
,domain_jobarchive.statuscode
from nb_jobdbinstancearchive
join domain_jobarchive
order by domain_jobarchive.endtime desc;
Best Regards
Marra
12-10-2019 07:03 AM
I'm found the answer,
select domain_jobarchive.clientname
,nb_jobdbinstancearchive.dbname as "Database"
,"DBA"."UTCBigIntToNomTime"(domain_jobarchive.starttime) as "Start Time"
,"DBA"."UTCBigIntToNomTime"(domain_jobarchive.endtime) as "End Time"
,domain_jobarchive.statuscode
from nb_jobdbinstancearchive
join domain_jobarchive
where datediff(hour,UTCBigIntToNomTime(domain_JobArchive.endTime),getdate())<= 24
AND nb_jobdbinstancearchive.dbname != 'AUTOMATIC_DATABASE_BACKUP'
AND nb_jobdbinstancearchive.dbname != '$ALL'
AND domain_JobArchive.statusCode NOT IN (2,25,48,156,2074,2106 )
order by domain_jobarchive.statuscode desc;
Regards,
Marra