Support Suite

This article addresses an issue where users are accidentally deleted through the Active Directory Sync feature of EIOBoard, then added back again, but all their status history and other information is missing.  This can happen when a user who was originally added through the AD Sync tool is unchecked from the AD Sync template and a manual or automatic sync runs.  By design, this will disable the user since they were added from AD Sync originally, but no longer appear on the template.  The same thing happens when a user is disabled in AD, then the AD Sync tool runs. 

When this happens on accident, customers usually add the user back to the AD Sync template again and run a manual sync.  While this does add the user back, any of the user’s status history, notes, future statuses, etc. are not tied to the new user account. 

There are two solutions to this problem.  The first solution can be done by any user with EB Admin rights, but is generally only acceptable for a small number of users.  If you go into the Administrator, you can view disabled users.  This will show you the user(s) that were deleted from AD Sync (along with any other users that have been deleted manually through the administrator).  To solve this issue, simply disable the enabled user account, and then you will be able to enable the disabled user account that was deleted through the AD Sync tool. 

The second solution is more acceptable for a large number of deleted users, but requires knowledge of SQL, and may require assistance from Savance.  You will need to run the SQL commands below. 

First, run these commands in SQL against your EIOBoard database to remove any users that were added on or after the day the AD Sync ran:
UPDATE Contacts SET CurrentValue = 0 WHERE ContactSys IN (SELECT ContactSys FROM Users WHERE DateCreated > ‘DateOfADSync’)
UPDATE Users SET CurrentValue = 0 WHERE DateCreated > ‘DateOfADSync’)

Just change “DateOfADSync” to the date you ran the AD Sync which removed your users.  Make sure to keep the single quotes and it should look something like: ‘2011-01-15’

Next, run these commands in SQL against your EIOBoard database to add back any users that were removed on or after the day the AD Sync ran:
UPDATE Contacts SET CurrentValue = 1 WHERE ContactSys IN (SELECT ContactSys FROM Users WHERE DateDeleted > ‘DateOfADSync’)
UPDATE Users SET CurrentValue = 1 WHERE DateDeleted > ‘DateOfADSync’)

Again, just change “DateOfADSync” to the date you ran the AD Sync which removed your users.  Make sure to keep the single quotes and it should look something like: ‘2011-01-15’

In a future release, (version 7.1) any user that was deleted through AD Sync will be enabled again once their name is checked on the template and either a manual or automatic sync runs.