Hi,
Do you recommend deleting Inactive users from FNMS? What are the pros and cons of deleting them from FNMS?
Thank you in advance for your suggestions!
Regards
Vinod Jadhav
Jan 19, 2021 01:47 PM
Hi,
I like to remove what's not needed, keeping only the data necessary to deliver the value. This ususally fits my customer's data reduction and data economy approach. It also keeps my databases small, reconcile fast and in case of an error/issue makes it easier to identify the root cause.
Best regards,
Markward
Jan 20, 2021 05:39 AM
Thank you Markward for your inputs!
Can we write business adapter to delete Inactive users from the FNMS? Deleting users in batches of 1000 is going to take lot of time plus this is going to be periodic activity.
Thank you,
Vinod
Jan 20, 2021 06:51 AM
Hi Vinod,
Yes , absolutely, an automated Business Import should take care of this. A few things to consider:
Here is an example:
USE FNMSCompliance
SELECT ComplianceUserID
INTO #ComplianceUser
FROM ComplianceUser
WHERE UserStatusID = 2 -- Inactive
EXEC ComplianceUserRemoveBatch
Best regards,
Markward
Jan 20, 2021 08:18 AM
Thank you Markward for your inputs!
Jan 20, 2021 09:18 AM