Saviynt Solutions

 SELECT     U.USERNAME,            U.FIRSTNAME,            U.LASTNAME,            U.EMAIL,            U.EMPLOYEETYPE,            U.CUSTOMPROPERTY9  AS 'JOINER DAT',            U.CUSTOMPROPERTY10 AS 'LOA START DAT',            U.CUSTOMPROPERTY8  AS 'MOVER DAT',            U.CUSTOMPROPERTY13 AS 'TERMINATION DAT',            U.CUSTOMPROPERTY17 AS 'CORPORATE ID',            E.DISPLAYNAME      AS 'APPLICATION NAME',            AT.ACCOUNTNAME,            AT.TASKKEY tasks,            AT.TASKDATE 'TASK CREATED ON',            CASE   ...

 SELECT SUBSTRING_INDEX(FROM_UNIXTIME(fired_time/1000),".",1) AS start_time, NOW() AS CurrentTime, trigger_name, job_name FROM qrtz_fired_triggers WHERE DATE_ADD(FROM_UNIXTIME(fired_time / 1000), INTERVAL 20 MINUTE) < NOW()

SELECT TRIGGERNAME AS 'Job_Name', EXTERNALCONNECTION AS 'Connection', SYSTEMNAME AS 'Application', SAVRESPONSE AS 'Job_Status', E.JOBSTARTDATE, JOBENDDATE, JOBNAME, I.LOGDATAASXML AS LOGS FROM ECMIMPORTJOB E, IMPORTLOG I WHERE ( SAVRESPONSE != 'Success' OR SAVRESPONSE IS NULL OR SAVRESPONSE = '' ) AND JOBSTARTDATE > DATE_SUB(NOW(), INTERVAL 1 HOUR) AND I.JOBID = E.JOBID AND JOBNAME NOT IN ('AsyncRequestRetryJob','AnalyticsESJob')  GROUP BY JOBNAME, TRIGGERNAME UNION  SELECT TRIGGERNAME AS 'Job Name', EXTERNALCONNECTION AS 'Connection', SYSTEMNAME AS 'Application', SAVRESPONSE AS 'Job Status', E.JOBSTARTDATE, JOBENDDATE, JOBNAME, 'No Logs' AS LOGS FROM ECMIMPORTJOB E WHERE ( SAVRESPONSE != 'Success' OR SAVRESPONSE IS NULL OR SAVRESPONSE = '' ) AND JOBSTARTDATE > DATE_SUB(NOW(), INTERVAL 1 HOUR) AND JOBNAME NOT IN ('AsyncRequestRetryJob','AnalyticsESJo...