Admin user password was lost. A need arises for the backend query that can reset the user in the database so that we can login once again as the admin user in LiveTime.

Version 1

    Details

    Admin user password was lost. A need arises for the backend query that can reset the user in the database so that we can login once again as the admin user in LiveTime.


    Resolution

    update CLIENT set PASSWORD = 'ISMvKXpXpadDiUoOSoAfww==' where USER_NAME = 'admin';

    The above query should be provided to the Database Admin on the customer side for LiveTime.  This can be run against the LiveTime database in order to set the Admin user password back to "admin".