Upgrading to SOTI Assist 2.0

Starting with SOTI Assist 2.0, user IDs are generated as globally unique identifiers (GUID). Previously, SOTI Assist used incremental numbering. Existing user IDs are automatically converted to the new format upon upgrade. You can see mappings between the new and old format for existing user IDs in the UserInfo database table.

If you rely on User IDs to integrate SOTI Assist with third-party tools, you may need to update those integrations manually. Read Changes in SOTI Assist 2.0 that may affect customers using Assist APIs on SOTI Central for more information.

Database Tables

The following database tables were changed in SOTI Assist 2.0.

Database Table Name Old Column New Column
dbo.Activity CreationUserId CreationUserPublicId
dbo.Activity UpdateUserId UpdateUserPublicId
dbo.ActivityEmailAddress RecipientId RecipientPublicId
dbo.ApiClient CreationUserId CreationUserPublicId
dbo.IncidentTicket AssigneeId AssigneePublicId
dbo.IncidentTicket CreationUserId CreationUserPublicId
dbo.IncidentTicket ReporterId ReporterPublicId
dbo.IncidentTicket ResolutionUserId ResolutionUserPublicId
dbo.Settings UserInfoId UserInfoPublicId
dbo.UserInfo UserInfoId UserInfoPublicId
dbo.Watcher UserInfoId UserInfoPublicId

API Calls

The following API calls were changed in SOTI Assist 2.0.

Method Route URL Query String Request Body Response Body
GET sotiassist/account/assigneeList ⬤
POST sotiassist/email/validateRecipients ⬤ ⬤
POST sotiassist/privacy/anonymizeUser/{userPublicId} ⬤
GET sotiassist/reporter ⬤ ⬤
POST sotiassist/reporter ⬤
GET sotiassist/reporter/{publicId} ⬤ ⬤
PUT sotiassist/reporter/{publicId} ⬤ ⬤ ⬤
GET sotiassist/search/devices/{deviceId}/tickets ⬤ ⬤
GET sotiassist/search/tickets ⬤ ⬤
GET sotiassist/ticket ⬤ ⬤
POST sotiassist/ticket ⬤ ⬤
GET sotiassist/ticket/{id} ⬤
GET sotiassist/ticket/{id}/activities ⬤ ⬤
POST sotiassist/ticket/{id}/activities ⬤ ⬤
GET sotiassist/ticket/{id}/activities/{activityId} ⬤
PUT sotiassist/ticket/{id}/activities/{activityId} ⬤ ⬤
POST sotiassist/ticket/{id}/activities/attachments/upload ⬤
POST sotiassist/ticket/{id}/activities/email/send ⬤ ⬤
POST sotiassist/ticket/{id}/activities/snapshot/save ⬤
PUT sotiassist/ticket/{id}/assigneePublicId ⬤ ⬤ ⬤
PUT sotiassist/ticket/{id}/description ⬤
PUT sotiassist/ticket/{id}/priority ⬤
PUT sotiassist/ticket/{id}/reportedMethod ⬤
PUT sotiassist/ticket/{id}/reporterPublicId ⬤ ⬤ ⬤
PUT sotiassist/ticket/{id}/status ⬤
PUT sotiassist/ticket/{id}/title ⬤
DELETE sotiassist/ticket/{ticketId}/watchers ⬤
GET sotiassist/ticket/{ticketId}/watchers ⬤
POST sotiassist/ticket/{ticketId}/watchers ⬤ ⬤
GET sotiassist/ticket/search ⬤ ⬤
GET sotiassist/ticket/statistics/assignees/to/tickets ⬤ ⬤
GET sotiassist/userinfo ⬤
GET sotiassist/userinfo/{userInfoPublicId} ⬤ ⬤
GET sotiassist/userinfo/{userInfoPublicId}/refresh ⬤
GET sotiassist/userinfo/anonymous ⬤
POST sotiassist/userinfo/cache/refresh ⬤
GET sotiassist/userinfo/current ⬤
GET sotiassist/userinfo/groups/mobicontrol ⬤
GET sotiassist/userinfo/search ⬤ ⬤