Restore a deleted user

If you would like to restore a user that has been deleted via the Yellowfin UI, you will need to run several queries against the Yellowfin configuration database.

As always, we recommend that you backup the configuration database before modifying it.

If you are interested in pursuing this, you could run the below three queries. Please note, that the Yellowfin service will need to be restarted in order for these changes to take effect. Also, to run these queries you will need to know the of the user you would like to restore. This can be found by running the following SQL against the Person table.

SELECT * FROM Person
WHERE LastName = 'the name';

The value listed under IpPerson will be used for the following SQL:

UPDATE StaffMemberRole
SET EndDate = '9999-12-31'
WHERE IpEmployee = ;

UPDATE IpRltshp
SET EndDate = '9999-12-31', EndReasonCode = NULL
WHERE IpChild = ;

UPDATE IpClass
SET EndDate = '9999-12-31'
WHERE IpId = ;

Please raise a ticket if you have any other questions surrounding this topic.