Skip to main content

Check a user account is linked to one employee

Data export to check that each user account is linked to one employee.

Written by Harry Ledger

To ensure the employee is linked to a single user account, follow the below steps:

  1. In the Admin Tool, click Import/Export Data.

  2. Click Create an export definition then click Select the data to export.

  3. Change the database to SelectHR then log in.

  4. Copy the below SQL code:

    SELECT Person.Details.[Person Number], Person.Details.[First Name], Person.Details.Surname, Person.Details.[E-Mail], Person.Details.[Private E-Mail], Person.Details.WorkspaceId, Users1.[User Number], Users1.[User Name] FROM Person.Details INNER JOIN Security.Users Users1 ON Person.Details.[Person Number] = Users1.[Person Number] WHERE Person.Details.[First Name] = 'CHANGEME' AND Person.Details.Surname = 'CHANGEME'
  5. Click Options, then select Paste SQL from clipboard.

  6. Change the First Name and Surname criteria to match the First and Surname of the employee.

  7. Click Data.

📌 Note: It is important that there is only one account per person. If there is duplicates, it can cause issues logging in via Access Evo.

Did this answer your question?