Software 101 – Database Part 2

Find the last person that modified a User in the PI software

In the database we are able to see who modified a user.  

1. To do this run the following query of the user you are looking to see who was modified.

  • select *
    from [User] su
    inner join [User] ss on su.UserId = ss.ModifiedBy
    where ss.[Email] = ’email address’

2.  Scroll to column ‘MiodifiedBy’ and obtain the UserId.

3.  Place that UserId in the query used for looking up user by UserID

  • select *
    from [User]
    where UserId = ‘500590’
Copy link