Problems

ServiceDeskPlus problem management for identifying and resolving underlying causes of incidents

Columns

Name	Type	References
Id [KEY]	Long
CategoryId	Long
CloseDetailsClosureCodeId	Long
GroupId	Long
ImpactId	Long
ItemId	Long
PriorityId	Long
GroupSiteId	Long
ReportedBySiteId	Long
SiteId	Long
TechnicianSiteId	Long
StatusId	Long
SubcategoryId	Long
TemplateId	Long
UrgencyId	Long
CloseDetailsUpdatedById	Long
ImpactDetailsUpdatedById	Long
KnownErrorDetailsUpdatedById	Long
ReportedById	Long
ResolutionDetailsUpdatedById	Long
RootCauseUpdatedById	Long
SymptomsUpdatedById	Long
TechnicianId	Long
WorkaroundDetailsUpdatedById	Long
Description	String
Title	String
StatusName	String
PriorityName	String
CreatedTime	Datetime
ReportedTime	Datetime
UpdatedTime	Datetime
DueByTime	Datetime
ClosedTime	Datetime
CloseDetailsUpdatedOn	Datetime
ImpactDetailsUpdatedOn	Datetime
KnownErrorDetailsUpdatedOn	Datetime
ResolutionDetailsUpdatedOn	Datetime
RootCauseUpdatedOn	Datetime
SymptomsUpdatedOn	Datetime
WorkaroundDetailsUpdatedOn	Datetime
Assets	String
Attachments	String
CategoryName	String
CloseDetailsClosureCodeName	String
CloseDetailsComments	String
CloseDetailsUpdatedByDepartment	String
CloseDetailsUpdatedByEmail	String
CloseDetailsUpdatedByEmployeeId	String
CloseDetailsUpdatedByFirstName	String
IsCloseDetailsUpdatedByTechnician	Boolean
IsCloseDetailsUpdatedByVipUser	Boolean
CloseDetailsUpdatedByJobTitle	String
CloseDetailsUpdatedByLastName	String
CloseDetailsUpdatedByMobile	String
CloseDetailsUpdatedByName	String
CloseDetailsUpdatedByPhone	String
CloseDetailsUpdatedByPhotoUrl	String
IsCloseDetailsUpdatedBySiteDeleted	Boolean
CloseDetailsUpdatedBySiteId	Long
IsCloseDetailsUpdatedBySiteDefault	Boolean
CloseDetailsUpdatedBySiteName	String
CloseDetailsUpdatedBySmsMail	String
CloseDetailsUpdatedBySmsMailId	String
CloseDetailsUpdatedByUserScope	String
CloseDetailsUpdatedOnDisplay	String
ClosedTimeDisplay	String
ConfigurationItems	String
CreatedTimeDisplay	String
DisplayId	String
DisplayIdNumeric	String
DueByTimeDisplay	String
GroupName	String
HasNotes	Boolean
ImpactDetailsDescription	String
ImpactDetailsUpdatedByDepartment	String
ImpactDetailsUpdatedByEmail	String
ImpactDetailsUpdatedByEmployeeId	String
ImpactDetailsUpdatedByFirstName	String
IsImpactDetailsUpdatedByTechnician	Boolean
IsImpactDetailsUpdatedByVipUser	Boolean
ImpactDetailsUpdatedByJobTitle	String
ImpactDetailsUpdatedByLastName	String
ImpactDetailsUpdatedByMobile	String
ImpactDetailsUpdatedByName	String
ImpactDetailsUpdatedByPhone	String
ImpactDetailsUpdatedByPhotoUrl	String
IsImpactDetailsUpdatedBySiteDeleted	Boolean
ImpactDetailsUpdatedBySiteId	Long
IsImpactDetailsUpdatedBySiteDefault	Boolean
ImpactDetailsUpdatedBySiteName	String
ImpactDetailsUpdatedBySmsMail	String
ImpactDetailsUpdatedBySmsMailId	String
ImpactDetailsUpdatedByUserScope	String
ImpactDetailsUpdatedOnDisplay	String
ImpactName	String
IsCategoryDeleted	Boolean
IsGroupDeleted	Boolean
IsKnownError	Boolean
IsReportedBySiteDefault	Boolean
IsReportedBySiteDeleted	Boolean
IsReportedByTechnician	Boolean
IsReportedByVip	Boolean
IsSiteDefault	Boolean
IsSiteDeleted	Boolean
IsStatusInProgress	Boolean
IsTechnician	Boolean
IsTechnicianVip	Boolean
IsTemplateInactive	Boolean
ItemName	String
KnownErrorDetailsComments	String
KnownErrorDetailsUpdatedByDepartment	String
KnownErrorDetailsUpdatedByEmail	String
KnownErrorDetailsUpdatedByEmployeeId	String
KnownErrorDetailsUpdatedByFirstName	String
IsKnownErrorDetailsUpdatedByTechnician	Boolean
IsKnownErrorDetailsUpdatedByVipUser	Boolean
KnownErrorDetailsUpdatedByJobTitle	String
KnownErrorDetailsUpdatedByLastName	String
KnownErrorDetailsUpdatedByMobile	String
KnownErrorDetailsUpdatedByName	String
KnownErrorDetailsUpdatedByPhone	String
KnownErrorDetailsUpdatedByPhotoUrl	String
IsKnownErrorDetailsUpdatedBySiteDeleted	Boolean
KnownErrorDetailsUpdatedBySiteId	Long
IsKnownErrorDetailsUpdatedBySiteDefault	Boolean
KnownErrorDetailsUpdatedBySiteName	String
KnownErrorDetailsUpdatedBySmsMail	String
KnownErrorDetailsUpdatedBySmsMailId	String
KnownErrorDetailsUpdatedByUserScope	String
KnownErrorDetailsUpdatedOnDisplay	String
Lifecycle	String
PriorityColor	String
ProblemTemplateTaskIds	String
ReportedByDepartment	String
ReportedByEmail	String
ReportedByEmployeeId	Long
ReportedByFirstName	String
ReportedByJobTitle	String
ReportedByLastName	String
ReportedByMobile	String
ReportedByName	String
ReportedByPhone	String
ReportedByPhotoUrl	String
ReportedBySiteName	String
ReportedBySmsMail	String
ReportedBySmsMailId	String
ReportedByUserScope	String
ReportedTimeDisplay	String
ResolutionDetailsDescription	String
ResolutionDetailsUpdatedByDepartment	String
ResolutionDetailsUpdatedByEmail	String
ResolutionDetailsUpdatedByEmployeeId	String
ResolutionDetailsUpdatedByFirstName	String
IsResolutionDetailsUpdatedByTechnician	Boolean
IsResolutionDetailsUpdatedByVipUser	Boolean
ResolutionDetailsUpdatedByJobTitle	String
ResolutionDetailsUpdatedByLastName	String
ResolutionDetailsUpdatedByMobile	String
ResolutionDetailsUpdatedByName	String
ResolutionDetailsUpdatedByPhone	String
ResolutionDetailsUpdatedByPhotoUrl	String
IsResolutionDetailsUpdatedBySiteDeleted	Boolean
ResolutionDetailsUpdatedBySiteId	Long
IsResolutionDetailsUpdatedBySiteDefault	Boolean
ResolutionDetailsUpdatedBySiteName	String
ResolutionDetailsUpdatedBySmsMail	String
ResolutionDetailsUpdatedBySmsMailId	String
ResolutionDetailsUpdatedByUserScope	String
ResolutionDetailsUpdatedOnDisplay	String
RootCauseDescription	String
RootCauseUpdatedByDepartment	String
RootCauseUpdatedByEmail	String
RootCauseUpdatedByEmployeeId	String
RootCauseUpdatedByFirstName	String
IsRootCauseUpdatedByTechnician	Boolean
IsRootCauseUpdatedByVipUser	Boolean
RootCauseUpdatedByJobTitle	String
RootCauseUpdatedByLastName	String
RootCauseUpdatedByMobile	String
RootCauseUpdatedByName	String
RootCauseUpdatedByPhone	String
RootCauseUpdatedByPhotoUrl	String
IsRootCauseUpdatedBySiteDeleted	Boolean
RootCauseUpdatedBySiteId	Long
IsRootCauseUpdatedBySiteDefault	Boolean
RootCauseUpdatedBySiteName	String
RootCauseUpdatedBySmsMail	String
RootCauseUpdatedBySmsMailId	String
RootCauseUpdatedByUserScope	String
RootCauseUpdatedOnDisplay	String
Services	String
DoesStatusStopTimer	Boolean
DoesTemplateIncludeAnalysisInForm	Boolean
DoesTemplateIncludeSolutionInForm	Boolean
SiteName	String
StatusColor	String
StatusInternalName	String
SubcategoryName	String
SymptomsDescription	String
SymptomsUpdatedByDepartment	String
SymptomsUpdatedByEmail	String
SymptomsUpdatedByEmployeeId	String
SymptomsUpdatedByFirstName	String
IsSymptomsUpdatedByTechnician	Boolean
IsSymptomsUpdatedByVipUser	Boolean
SymptomsUpdatedByJobTitle	String
SymptomsUpdatedByLastName	String
SymptomsUpdatedByMobile	String
SymptomsUpdatedByName	String
SymptomsUpdatedByPhone	String
SymptomsUpdatedByPhotoUrl	String
IsSymptomsUpdatedBySiteDeleted	Boolean
SymptomsUpdatedBySiteId	Long
IsSymptomsUpdatedBySiteDefault	Boolean
SymptomsUpdatedBySiteName	String
SymptomsUpdatedBySmsMail	String
SymptomsUpdatedBySmsMailId	String
SymptomsUpdatedByUserScope	String
SymptomsUpdatedOnDisplay	String
TechnicianCostPerHour	Decimal
TechnicianDepartment	String
TechnicianEmail	String
TechnicianEmployeeId	Long
TechnicianFirstName	String
TechnicianJobTitle	String
TechnicianLastName	String
TechnicianMobile	String
TechnicianName	String
TechnicianPhone	String
TechnicianPhotoUrl	String
TechnicianSmsMail	String
TechnicianSmsMailId	String
TechnicianUserScope	String
TemplateName	String
UpdatedTimeDisplay	String
UrgencyName	String
WorkaroundDetailsDescription	String
WorkaroundDetailsUpdatedByDepartment	String
WorkaroundDetailsUpdatedByEmail	String
WorkaroundDetailsUpdatedByEmployeeId	String
WorkaroundDetailsUpdatedByFirstName	String
IsWorkaroundDetailsUpdatedByTechnician	Boolean
IsWorkaroundDetailsUpdatedByVipUser	Boolean
WorkaroundDetailsUpdatedByJobTitle	String
WorkaroundDetailsUpdatedByLastName	String
WorkaroundDetailsUpdatedByMobile	String
WorkaroundDetailsUpdatedByName	String
WorkaroundDetailsUpdatedByPhone	String
WorkaroundDetailsUpdatedByPhotoUrl	String
IsWorkaroundDetailsUpdatedBySiteDeleted	Boolean
WorkaroundDetailsUpdatedBySiteId	Long
IsWorkaroundDetailsUpdatedBySiteDefault	Boolean
WorkaroundDetailsUpdatedBySiteName	String
WorkaroundDetailsUpdatedBySmsMail	String
WorkaroundDetailsUpdatedBySmsMailId	String
WorkaroundDetailsUpdatedByUserScope	String
WorkaroundDetailsUpdatedOnDisplay	String
EntityInstanceProperties	String
RelWorkarounds	String
RelResolutions	String
UdfFields	String