Software 101 – Database Part 2

Looking up a software user

You can look up a software user by their email or by their first and last name.

1. Open up SQLQuery

2. Highlight and press ‘Execute’ on one of the below stored procedures depending if you have the user name or email.

If you have the first and last name run the below stored procedure (all three lines must be highlighted to execute command):

Select *
from [User]
where LastName = ‘LastName’ and FirstName = ‘FirstName’

If you have the email address run the below stored procedure with the email in single quotes like in the example below:

exec [Support].[User_Info_ByEmail] ’email address’

3. The results will yield information such as their UserID, CompanyID, Software Language, when they were created as a user, last time they logged in, etc.  Spend some time reviewing the different columns of information that populates.

Copy link