These are the generic steps to exclude a specific driver from Geotab access through the Eleos platform. This process will remove the user based on the matching ManPowerProfile ID.
Locating and Changing the SQL File
1. Start by locating the “ELEOS.usp_ValidateUser” stored procedure within the database
2. In the ELEOS.usp_ValidateUser code locate the [UseGeotab] variable where it is being assigned. The right of the assignment operator should contain a CASE statement that evaluates @False when the user's ManPowerProfile ID matches a specified string and evaluates @True otherwise.
3. To exclude a new user from Geotab, extend the CASE statement using an additional OR operator and assign the ManPowerProfile ID to the specific string matching the driver’s ID. For demonstration purposes we add ASR_MPP_4 and ASR_MPP_5 to the list of excluded users.
Re-Including Geotab Users
If circumstances have changed and there are users that need to be included again, re-including them is a simple as removing all or some of the previously discussed CASE statement.
For example, suppose that users with the ManPowerProfile ID ASR_MPP_5, ASR_MPP_4, and ASR_MPP_3 need to now be included when they were previously excluded. Simply remove those three lines from the CASE statement in the screenshot above. Now only the first two users remain, as shown in the screenshot below.
Note: Be sure to include the end parentheses after the final line.
If every single user needs to be re-included, instead replace the entire case statement with @True, as shown in the screenshot below.
