Modules
Browse queries by module.
All Modules
ARS Requests ARS Tasks Accounts Accounts, Endpoint Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Customers Email History Endpoints Enhanced Query Entitlement Values External Connections Job Control Panel Request Access Role Assignments Roles Rules Rulesets Security Systems User Accounts User Group User Groups Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLESJob Failure Details
Module: Job Control Panel
Description
Query to fetch which analytics has failed among the category in RunAllAnalyticsJob job type. Ex: if deprovision category has 3 analytics and 1 of them failed, then to get that particular analytics this query helps.
Dynamic Input
Job Name
Execute in
Data Analyzer, Analytics
SQL Query
select e.jobid, e.triggername, e.jobstartdate, e.jobenddate, i.importlogid, i.logdataasxml from ecmimportjob e join importlog i on i.jobid = e.jobid where e.triggername = '<JOB NAME>' and i.logdataasxml like '%failure%'
Comments
You can add the filter of start and end dates.
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!