AssetsSLAInstances
The instance of a Service Level Agreement (SLA).
Table-Specific Information
SELECT
The connector will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the connector.
SELECT * FROM assetsSLAInstances WHERE id = 12 SELECT * FROM assetsSLAInstances WHERE id > 15 SELECT * FROM assetsSLAInstances WHERE stateofslalookUpName LIKE '%test' SELECT * FROM assetsSLAInstances WHERE id IN (12, 23, 123) SELECT * FROM assetsSLAInstances WHERE stateofslalookUpName IS NOT NULL
Columns
| Name | Type | Description |
| AssetsId | Long | The unique identifier of the asset. |
| ActiveDate | Date | The date when the instance became active. |
| ExpireDate | Date | The date when the instance is scheduled to expire. |
| Id [KEY] | Long | The unique identifier of the SLAInstance. |
| NameOfSLAId | Long | Id of nameOfSLA. The SLA from which the instance was created. |
| NameOfSLAlookUpName | String | LookUpName of nameOfSLA. The SLA from which the instance was created. |
| RemainingFromCSR | Int | The number of remaining CSR incidents. |
| RemainingFromChat | Int | The number of remaining chat incidents. |
| RemainingFromEmail | Int | The number of remaining email incidents. |
| RemainingFromWeb | Int | The number of remaining web self-service incidents. |
| RemainingTotal | Int | The total number of remaining incidents. |
| SLASet | Int | The SLA set from which the instance was created. |
| StateOfSLAId | Long | Id of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled. |
| StateOfSLAlookUpName | String | LookUpName of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled. |