Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Service Status History

Details

Table ID: h_itsm_servicestatus_history

Contains a history of the statuses applied to a Service

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Exclude entry
h_exclude
This value tells if the entry has to be excluded (possible values 0,1)
Type INTEGER
Nullable true
Indexed true
Exclude entry
h_exclude_reason
Description as to why this entry has been excluded
Type LONGTEXT
Nullable true
ID
h_id
System generated ID of the record
Type INTEGER
Nullable false
Primary Key true
Service ID
h_service_id
ID of the service this record relates to
Type INTEGER
Nullable false
Indexed true
Status From
h_status_from
The status the service transitioned from
Type VARCHAR
Size 160
Nullable true
Indexed true
Status To
h_status_to
The status the service transitioned to
Type VARCHAR
Size 160
Nullable true
Indexed true
Transition Date
h_transition_date
The time the status changed status
Type DATETIME
Nullable true
Indexed true
User ID
h_transition_by_id
The ID of the user which put the service in the state State From
Type VARCHAR
Size 64
Nullable true
User name
h_transition_by_name
The name of the user which put the service in the state State From
Type VARCHAR
Size 255
Nullable true
In This Document