Hi All,
I'm using a post execute script in Scheduled Data import, to delete the records in the target table. The DL's are synced from AD to ServiceNow via LDAP sync everyday. As part of delta sync I've to delete the DL's in the ServiceNow custom table if any DL's are deleted in AD.
To achieve this, I was querying the import set table with importsetrun number to get the all DL's samaccount names of current/recent load and push to an array. And then, query the target table where the samaccount name not in the defined array. Since the table has around 90K + records, it is taking lot of time to compare and delete the records. Can anyone suggest if there is any other way to compare the data and delete.
Regards,
Navyashree B R
