Users
End users (contacts) managed in HaloServiceDesk who raise and track support tickets.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| ClientId | Integer |
Clients.Id | |
| SiteId | Decimal | ||
| SiteIdInt | Integer |
Sites.Id | |
| Name | String | ||
| DateCreated | Datetime | ||
| LastLoginDate | Datetime | ||
| LastUpdate | Datetime | ||
| ClientName | String | ||
| Colour | String | ||
| CustomFields | String | ||
| Email2 | String | ||
| FirstName | String | ||
| IsExternal | Boolean | ||
| IsImportantContact | Boolean | ||
| IsInactive | Boolean | ||
| IsMainContact | Boolean | ||
| Notes | String | ||
| PhoneNumber | String | ||
| SiteName | String | ||
| Surname | String | ||
| WebAccessLevel | Integer | ||
| Use | String | ||
| Initials | String | ||
| Email3 | String | ||
| PhoneNumberPreferred | String | ||
| SitePhoneNumber | String | ||
| OnPremiseActiveDirectoryDn | String | ||
| SiteTimezone | String | ||
| AzureOid | String | ||
| PriorityId | Integer | ||
| LinkedAgentId | Integer |
Agents.Id | |
| ClientAccountManagerId | Integer |
Agents.Id | |
| ConnectWiseId | Integer | ||
| AutotaskId | Integer | ||
| OverridePdfTemplateQuoteId | Integer | ||
| TelPref | Integer | ||
| UserKey | Integer | ||
| TableType | Integer | ||
| Question1 | Integer | ||
| Question2 | Integer | ||
| Question3 | Integer | ||
| Question4 | Integer | ||
| Question5 | Integer | ||
| IsEmailSuppressed | Boolean | ||
| IsServiceAccount | Boolean | ||
| IsImportantContact2 | Boolean | ||
| IsProspect | Boolean |