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.
- 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 Query3. 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
Comments