Forum Discussion

Kleber_Marra's avatar
Kleber_Marra
Level 4
6 years ago

Report SQL error on date and time

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

  • Kleber_Marra's avatar
    Kleber_Marra
    Level 4
    6 years ago

    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