Modules

Browse queries by module.

All Modules

ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLES

Failed Job Details

Module: Job Control Panel
Description

Get the details of all the Jobs that have failed in the system

Dynamic Input

nan

Execute in

Analytics

SQL Query 
SELECT ecm.jobid,
ecm.triggername as job_name,
ecm.jobstartdate,
ecm.jobenddate,
ecm.savresponse,
coalesce(e1.endpointname, e2.endpointname) as endpointname,
coalesce(e1.endpointkey, e2.endpointkey) as endpointkey
FROM ecmimportjob ecm
LEFT JOIN securitysystems s1
ON s1.externalconnection = (SELECT e2.externalconnectionkey
FROM externalconnection e2
WHERE
e2.connectionname = ecm.externalconnection)
LEFT JOIN endpoints e1
ON e1.securitysystemkey = s1.systemkey
LEFT JOIN securitysystems s2
ON s2.systemname = ecm.systemname
LEFT JOIN endpoints e2
ON e2.securitysystemkey = s2.systemkey
WHERE ecm.savresponse != 'success';
Comments

nan

Job History- WSRETRY

Module: Job Control Panel
Description

Get all Job history that ran for a particular Jobtype (all WSRETRY Jobs)

Dynamic Input

Job Name

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT JOBID,
TRIGGERNAME AS JOB_NAME,
JOBNAME AS JOB_TYPE,
EXTERNALCONNECTION,
IPADDRESS,
JOBSTARTDATE,
JOBENDDATE,
SEC_TO_TIME(
TIMESTAMPDIFF(SECOND, JOBSTARTDATE, JOBENDDATE)
) AS RUNTIME,
JOBGROUP,
SAVRESPONSE,
SYSTEMNAME,
TRIGGERTYPE,
UPDATEUSER,
COMENTS
FROM ecmimportjob
WHERE jobname='WSRETRYJOB';
Comments

nan

Jobs Details of a specific Job

Module: Job Control Panel
Description

Get all Job details that are currently setup for a specific Job

Dynamic Input

Job Name

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT
JOBID,
TRIGGERNAME AS JOB_NAME,
JOBNAME AS JOB_TYPE,
EXTERNALCONNECTION,
IPADDRESS,
JOBSTARTDATE,
JOBENDDATE,
SEC_TO_TIME(
TIMESTAMPDIFF(SECOND, JOBSTARTDATE, JOBENDDATE)
) AS RUNTIME,
JOBGROUP,
SAVRESPONSE,
SYSTEMNAME,
TRIGGERTYPE,
UPDATEUSER,
COMENTS
FROM ecmimportjob
where TRIGGERNAME LIKE '%DefaultDetectiveExternalClassificationRulesTrigger%'
ORDER BY JOBSTARTDATE DESC;
Comments

nan

Job History- Job Group

Module: Job Control Panel
Description

Get all Job history that ran for a particular Job Group

Dynamic Input

Job Category

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT JOBID,
TRIGGERNAME AS JOB_NAME,
JOBNAME AS JOB_TYPE,
EXTERNALCONNECTION,
IPADDRESS,
JOBSTARTDATE,
JOBENDDATE,
SEC_TO_TIME(
TIMESTAMPDIFF(SECOND, JOBSTARTDATE, JOBENDDATE)
) AS RUNTIME,
JOBGROUP,
SAVRESPONSE,
SYSTEMNAME,
TRIGGERTYPE,
UPDATEUSER,
COMENTS
FROM ECMIMPORTJOB
WHERE JOBGROUP = 'SAP';
Comments

nan

Query copied!