Is there a way to find out when and who deleted a Username in GoldMine?

Version 1
Created by Katie.Sullivan on Apr 28, 2015 3:33 PM. Last modified by Katie.Sullivan on Jun 5, 2017 1:21 PM.

    Details

    Is there a way to find out when and who deleted a Username in GoldMine?

    Resolution

     

    [INFO]

    - Only Master users have the ability to delete Users/Usernames in GoldMine through the User Interface via Tools > User's Settings. 
    - When a User/Username is deleted, it does display this action in the Process Monitor (see below)


    - GoldMine does keep Process Monitor logs for each user.
    - These logs are never deleted or purged unless done so manually through the user interface (Tools > Logs > GoldMine Logs) or through the SQL back end.
    - As long as the deletion process is still contained in the logs on the syslog table, a query can be run within GoldMine to locate the time and user that processed the deletion of a user/username. 


    [RESOLUTION]

    1. Login to GoldMine as a Master user
    2. Tools > SQL Query
    3. Paste the following in the main window: select * from dbo.syslog where ref like '%deleting user%'
    4. Click the Query button on the right
    • Pid = Process ID
    • OnDate = Date of Entry/Process (m/d/yy)
    • OnTime = Time of Entry/Process (hh:mm)
    • Resultcode = Successful or Error (ERR/SUCC)
    • Userid = User who processed Action
    • Ref = Reference in the Process Monitor