SQL query to get accounts which are reconcile through import job

[VJReddy]

Hi Team,

We are using below query to get the metrics of Accounts imported in Saviynt. But we have requirement that to list out the complete report which are part of that Job reconciliation.

select JOBID,PARENTJOBID,LOGDATAASXML from importlog where JOBID in ('12345')

But it doesn't give the complete list of accounts. Kindly help us the way to find list of those metrics.

Account threshold (accountThresholdValue) exceeded. Current threshold limit 4000 and missing accounts during import 3036. No action was taken on missing accounts due to the threshold breach.

Existing accounts: 9909

Accounts Existing Updated : 6873

Accounts Inactivated: 1923

Thanks,

VJ

[rushikeshvartak]

You will not able to list all accounts which are missing. You need to take data from accounts table based on latest job id