Full Extracts
The following entities are available for your reference:
Entity: CI_CI_RELATIONSHIP
CI_CI_RELATIONSHIP refers to the relationship between one or more CI in your instance. The following details regarding the CI relationships are available in the extract.
Name | Description | System Data Type | Extract Data Type |
parent_ci_id
| The parent configuration item to which another CI is related. | BIGINT
| Long Integer (4)
|
ci_id
| The configuration item which holds a relationship with the parent CI. | BIGINT | Long Integer (4)
|
domain_type
| The relationship domain for the configuration items indicating physical or logical connections between CIs
| NVARCHAR(50)
| Text (255)
|
rel_description
| The description gives an overview of the context and usage of the relationship type. | NVARCHAR(126)
| Text (255)
|
Entity: CI_CONTACT_RELATIONSHIP
CI_CONTACT_RELATIONSHIP refers to the CI to the Contacts relationship in your instance. Details n the following fields in the relationship are available in the extract.
Name
| Description
| System Data Type
| Extract Data Type |
ci_id
| The configuration item (CI) with which the contact is related.
| BIGINT
| Long Integer (4)
|
contact_id
| The contact person that is associated with the configuration item (CI). | BIGINT
| Long Integer (4)
|
contact_name | Name of the contact that is associated with the Configuration Item.
| - -
| Text (255)
|
group_id
| The support group that is associated with the configuration item (CI).
| BIGINT
| Long Integer (4)
|
group_name
| Group Name that is associated with CI. | NVARCHAR(50)
| Text (255) |
ci_contact_rel_type
| The configuration item and contact relationship descriptor | BIGINT
| Text (255)
|
Entity: TICKET_CI_RELATIONSHIP
TICKET_CI_RELATIONSHIP refers to the Ticket to the CI relationship in your instance. The following details about the Ticket CI relationship are available in the extract.
Name | Description | System Data Type | Extract Data Type |
item_id
| Item ID | BIGINT | Long Integer (4) |
ci_id
| The associated configuration item to the ticket | BIGINT | Long Integer (4) |
Entity: TICKET_TICKET_RELATIONSHIP
TICKET_TICKET_RELATIONSHIP refers to the Ticket to the Ticket relationship in your instance. The following information about Ticket to ticket relationship is available in the extract.
Name | Description | System Data Type | Extract Data Type |
parent_item_id | Parent Ticket ID | BIGINT | Long Integer (4) |
item_id | Item ID
| BIGINT | Long Integer (4) |
© 2019 Serviceaide 1-650-206-8988 http://www.serviceaide.com info@serviceaide.com