Requests
ServiceDeskPlus ITSM requests including incidents and service requests
Columns
| Name | Type | References | |
| Id [KEY] | Long | ||
| ApprovalStatusId | Long | ||
| CategoryId | Long | ||
| CreatedByDepartmentId | Long | ||
| DepartmentId | Long | ||
| RequesterDepartmentId | Long | ||
| TechnicianDepartmentId | Long | ||
| GroupId | Long | ||
| LevelId | Long | ||
| MaintenanceId | Long | ||
| ModeId | Long | ||
| PriorityId | Long | ||
| LinkedToRequestId | Long |
Requests.Id | |
| CreatedBySiteId | Long | ||
| GroupSiteId | Long | ||
| RequesterSiteId | Long | ||
| SiteId | Long | ||
| TechnicianSiteId | Long | ||
| SlaId | Long | ||
| StatusId | Long | ||
| TemplateId | Long | ||
| CreatedById | Long | ||
| RequesterId | Long | ||
| TechnicianId | Long | ||
| WorkflowId | Long | ||
| Description | String | ||
| Subject | String | ||
| StatusName | String | ||
| CategoryName | String | ||
| PriorityName | String | ||
| CreatedTime | Datetime | ||
| AssignedTime | Datetime | ||
| DueByTime | Datetime | ||
| FirstResponseDueByTime | Datetime | ||
| RespondedTime | Datetime | ||
| LastUpdatedTime | Datetime | ||
| CompletedTime | Datetime | ||
| ResolvedTime | Datetime | ||
| DeletedTime | Datetime | ||
| AssignedTimeDisplay | String | ||
| CancelFlagCommentsComment | String | ||
| CancelFlagCommentsId | Long | ||
| ClosureCode | String | ||
| ClosureComments | String | ||
| ClosureRequesterAckComments | String | ||
| CreatedByDepartmentName | String | ||
| CreatedByEmail | String | ||
| CreatedByEmployeeId | Long | ||
| CreatedByFirstName | String | ||
| CreatedByJobTitle | String | ||
| CreatedByLastName | String | ||
| CreatedByMobile | String | ||
| CreatedByName | String | ||
| CreatedByPhone | String | ||
| CreatedByPhotoUrl | String | ||
| CreatedBySmsMail | String | ||
| CreatedBySmsMailId | String | ||
| CreatedByUserScope | String | ||
| CreatedTimeDisplay | String | ||
| DepartmentName | String | ||
| DisplayId | String | ||
| DisplayKeyDisplayValue | String | ||
| DisplayKeyValue | String | ||
| DueByTimeDisplay | String | ||
| FirstResponseDueByDisplay | String | ||
| GroupName | String | ||
| GroupSite | String | ||
| GroupSiteName | String | ||
| LevelName | String | ||
| MaintenanceName | String | ||
| MessageId | String | ||
| ModeInternalName | String | ||
| ModeName | String | ||
| NotificationStatus | String | ||
| PriorityColor | String | ||
| RequesterCostPerHour | Decimal | ||
| RequesterDepartmentName | String | ||
| RequesterEmail | String | ||
| RequesterEmployeeId | Long | ||
| RequesterFirstName | String | ||
| RequesterJobTitle | String | ||
| RequesterLastName | String | ||
| RequesterMobile | String | ||
| RequesterName | String | ||
| RequesterPhone | String | ||
| RequesterPhotoUrl | String | ||
| RequesterSiteName | String | ||
| RequesterSmsMail | String | ||
| RequesterSmsMailId | String | ||
| RequesterUserScope | String | ||
| SiteName | String | ||
| SlaName | String | ||
| StatusColor | String | ||
| StatusInternalName | String | ||
| TechnicianCostPerHour | Decimal | ||
| TechnicianDepartmentName | String | ||
| TechnicianEmail | String | ||
| TechnicianEmployeeId | Long | ||
| TechnicianFirstName | String | ||
| TechnicianJobTitle | String | ||
| TechnicianLastName | String | ||
| TechnicianMobile | String | ||
| TechnicianName | String | ||
| TechnicianPhone | String | ||
| TechnicianPhotoUrl | String | ||
| TechnicianSmsMailId | String | ||
| TechnicianUserScope | String | ||
| TemplateImage | String | ||
| TemplateName | String | ||
| TemplateSortIndex | String | ||
| HasTemplateUserGroup | Boolean | ||
| IsTemplateVisibleToRequester | Boolean | ||
| HasTemplateTasks | Boolean | ||
| TemplateCreatedTime | Datetime | ||
| TemplateCreatedTimeDisplay | String | ||
| TemplateComments | String | ||
| IsTemplateDefault | Boolean | ||
| HasTemplateChecklists | Boolean | ||
| TemplateCreatedById | Long | ||
| TemplateCreatedByName | String | ||
| TemplateCreatedByEmail | String | ||
| TemplateLastUpdatedTime | Datetime | ||
| TimeElapsed | Long | ||
| WorkflowName | String | ||
| EmailBccList | String | ||
| EmailCcList | String | ||
| EmailIdsToNotifyList | String | ||
| EmailToList | String | ||
| DeletedAssets | String | ||
| EntityInstanceProperties | String | ||
| HasAttachments | Boolean | ||
| HasChangeInitiatedRequest | Boolean | ||
| HasClosureRequesterAckResolution | Boolean | ||
| HasDraft | Boolean | ||
| HasLinkedRequests | Boolean | ||
| HasNotes | Boolean | ||
| HasProblem | Boolean | ||
| HasProject | Boolean | ||
| HasRequestInitiatedChange | Boolean | ||
| IsCancellationRequested | Boolean | ||
| IsCategoryDeleted | Boolean | ||
| IsCompletedByDenial | Boolean | ||
| IsCreatedByTechnician | Boolean | ||
| IsCreatedByVipUser | Boolean | ||
| IsEscalated | Boolean | ||
| IsFcr | Boolean | ||
| IsFirstResponseOverdue | Boolean | ||
| IsGroupDeleted | Boolean | ||
| IsGroupSiteDefault | Boolean | ||
| IsGroupSiteDeleted | Boolean | ||
| IsOverdue | Boolean | ||
| IsRead | Boolean | ||
| IsReopened | Boolean | ||
| IsRequesterSiteDefault | Boolean | ||
| IsRequesterSiteDeleted | Boolean | ||
| IsRequesterTechnician | Boolean | ||
| IsRequesterVip | Boolean | ||
| IsServiceRequest | Boolean | ||
| IsSiteDefault | Boolean | ||
| IsSiteDeleted | Boolean | ||
| IsStatusInProgress | Boolean | ||
| IsTemplateInactive | Boolean | ||
| IsTrashed | Boolean | ||
| RequestTemplateTaskIds | String | ||
| Tags | String | ||
| IsTechnician | Boolean | ||
| IsTechnicianVipUser | Boolean | ||
| IsTemplateService | Boolean | ||
| UdfFields | String | ||
| Resolution | String | ||
| Resources | String | ||
| UnrepliedCount | Long | ||
| WorkflowInstanceDetails | String | ||
| Attachments | String | ||
| Assets | String | ||
| RequestTemplateChecklistIds | String | ||
| TemplateTaskConfiguration | String | ||
| TemplateLayouts | String | ||
| TemplateFields | String | ||
| TemplateChecklists | String | ||
| TemplateSupportGroups | String | ||
| TemplateReferenceTemplates | String | ||
| TemplateUserGroups | String |