How to see all end points reconciliation reports

[Community_User]

Originally posted on February 17 2020 at 16:12 UTC

Hi All, can anyone please suggest which report in Saviynt is good to see reconciliation from all endpoints in one report. This endpoint is from Saviynt ECM console -> Admin -> Identity Repository -> Connections -> Connection List. I actually want to see recon history like when it was worked fine and when it was failure and if possible failure reason. Could you please tell me where I can find this report in Saviynt.

[Community_User]

Originally posted on February 17 2020 at 16:27 UTC

Hi,

You can create an analytic that lists all data import jobs with proper status.

ecmimportjob is a table that could be of interest, with the importlog table that provides complete logdata (in XML format)

[Community_User]

Originally posted on February 17 2020 at 17:14 UTC

Hi Fabrice,

Thanks for your response. I was looking the db schema but didn't see ecmimportjob table. Could you please give few more info on this table and query used. if possible could you please attach some sample report.

[Community_User]

Originally posted on February 17 2020 at 17:21 UTC

This table is indeed not documented in the DB schema.

To find the list of all tables in MySql, you can create a new analytics with the following query:

show tables;

Then to see details about a given table (ex: ecmimportjob), create another analytics (or reuse the same) with the following query:

DESCRIBE ecmimportjob;

Here is the code of one of our reports:

SELECT job.JOBNAME, job.EXTERNALCONNECTION, job.SYSTEMNAME, job.JOBID, job.JOBSTARTDATE, job.JOBENDDATE, job.SAVRESPONSE, CASE  WHEN (log.LOGDATAASXML like '%Records_Missing_UserName%' ) THEN 'RECORDS MISSING USERNAME' WHEN (job.SAVRESPONSE like '%error%' ) THEN 'ERROR' WHEN (job.SAVRESPONSE like '%failure%' ) THEN 'ERROR' ELSE 'NO ERROR' END 'Response',  job.IPADDRESS, job.COMENTS, log.LOGDATAASXML from ecmimportjob job left join importlog log on job.jobid = log.jobid WHERE job.jobname  not like '%analytics%' and  job.jobname not like '%CampaignReassignJob%' order by 5 DESC,1, 2

I can `t share sample report as it is prod data.

[Community_User · Accepted solution]

Originally posted on February 18 2020 at 04:02 UTC

Thanks a lot Fabrice!