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’