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}}

Scheduled Requests

Details

Table ID: h_sm_scheduled_requests

Contains details of Service Manager scheduled requests that can be used to automatically raise the right Request with the right context

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Asset Ids
h_asset_ids
The list of asset ids to be linked to the request.
Type VARCHAR
Size 512
Nullable true
Catalog Id
h_fk_catalog_id
Id of the catalog linked to the service.
Type INTEGER
Nullable true
Created By
h_created_by
The user who created the record.
Type VARCHAR
Size 100
Nullable true
Indexed true
Date Created
h_created_date
The creation date of the record.
Type DATETIME
Nullable true
Date Last Updated
h_last_updated_date
The last updated Date/Time of the scheduled request.
Type DATETIME
Nullable true
Description
h_description
Description of the request.
Type LONGTEXT
Nullable true
ID
h_id
Id of a scheduled request.
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Job Id
h_job_id
The id for the scheduled job
Type INTEGER
Nullable true
Last Updated By
h_last_updated_by
The user who last updated the scheduled request.
Type VARCHAR
Size 100
Nullable true
Indexed true
Name
h_name
Name of the scheduled request.
Type VARCHAR
Size 175
Nullable false
Indexed true
Priority Id
h_fk_priority_id
The id of the priority of the request.
Type INTEGER
Nullable true
Request Type
h_request_type
The Request Type i.e. Incident / Service Request / Change Request
Type VARCHAR
Size 64
Nullable false
Service Id
h_fk_service_id
Description of the request.
Type INTEGER
Nullable true
Site Id
h_fk_site_id
The id of the site this request is affecting.
Type INTEGER
Nullable true
Summary
h_summary
Summary of the request.
Type VARCHAR
Size 275
Nullable true
Team Id
h_fk_team_id
The Id of the team to assign the request to.
Type VARCHAR
Size 160
Nullable true
User Id
h_fk_user_id
The Id of the user who owns the request.
Type VARCHAR
Size 100
Nullable true
In This Document