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.

H
Written by Harry Ledger
Updated over 3 months ago

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?