We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Getting Job details in analytics

Romain
New Contributor
New Contributor

Hello,

What is the table that contains job details ?
We would need to have an analytics that could contain (for UserImportJob) : 
  - Start Date of the job
  - End date of the job
  - Number of users in feed

Regards,

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

SELECT EC.JOBNAME,EC.EXTERNALCONNECTION,EC.SAVRESPONSE AS RESPONSE, EC.JOBSTARTDATE,EC.JOBENDDATE, SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(REPLACE(IL.LOGDATAASXML,'','@'),'','&'),'&',1),'@',-1) AS TOTAL_IMPORT_TIME FROM ECMIMPORTJOB EC, IMPORTLOG IL WHERE EC.JOBID = IL.JOBID AND EC.JOBNAME = 'USERIMPORTJOB' AND EC.SAVRESPONSE = 'SUCCESS';


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Perfect, IMPORTLOG was the table I was looking for !