BAU - Job Monitoring

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','AnalyticsESJob') GROUP BY JOBNAME, TRIGGERNAME

Comments

Post a Comment

Popular posts from this blog

Enhanced Query - To Update Account Status and Name

select accountkey as accounts__primarykey, 'SUSPENDED FROM IMPORT SERVICE' as accounts__status, CONCAT(name,'-Deleted on-', DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'))as accounts__name from accounts where endpointkey=527 and name='CN=INRVCH,OU=User Accounts Vista,OU=User Accounts,OU=User Directory,DC=asia-pac,DC=xx,DC=com'  and status not in ('SUSPENDED FROM IMPORT SERVICE') limit 1;
Read more

Connection Config - STATUS_THRESHOLD_CONFIG

 {   "statusAndThresholdConfig": {    "inactivateAccountsNotInFile": true    "statusColumn":"userlock",    "activeStatus":["0","128","192"],     "accountThresholdValue": 500,     "deleteLinks": false,     "correlateInactiveAccounts": true,        } } ----------------------------------------------------------------------------- When account import run above STATUS_THRESHOLD_CONFIG is used to check. ----------------------------------- inactivateAccountsNotInFile  ==> True/false true ---> Account status 1/2 ( Active/Inactive) Day 1 --> 100 Accounts import Day 2 --> 90 Diff= 10  ( 90= Active , 10 Inactive)  ------------------------------------------------------------------------------ ----------------------------------- inactivateAccountsNotInFile  ==> True/false false ---> Account status 1/SFIS ( Active/SUSPENDED FROM IMPORT SERVICE.) Day 1 --> 100 Ac...
Read more

Email variables _ Register User

ServiceAccountOwnerMap ------- [:] entitlements ------- [] accessapprovers ------- com.saviynt.ecm.workflow.Access_Approvers : 812 jbpm_activity_name ------- Third Party Registration Approvers allApproversComments ------- null fullrowhtmltablerows ------- listofallrolesinrequest ------- [] approvedEntitlementsOwners ------- [] entitlementshtmltablerowsv2 ------- entitlementshtmltablerowsv3 ------- ServiceAccountType ------- requestlink ------- null/jbpmworkflowmanagement/showrequestdetails/TP Registration Approvals.553050?reqid=433 allRejectorsComments ------- null rolesApprovedOrRejected ------- [] rolename ------- request_access ------- com.saviynt.ecm.workflow.Request_Access : 456 users ------- XXXX allRejectors ------- [] requestid ------- 553050 rolemap ------- [:] baseUrlForEmail ------- https://dev.saviyntcloud.com/ECM assignee ------- XXXX activityname ------- Third Party Registration Approvers ServiceAccountFlag ------- false request ------- com.saviynt.ecm.workflow.ARS_Reques...
Read more