cancel
Showing results for 
Search instead for 
Did you mean: 

Report SQL error on date and time

Kleber_Marra
Level 4
Partner Accredited Certified

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

1 REPLY 1

Kleber_Marra
Level 4
Partner Accredited Certified

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