A Data Extract is a file that contains the customer's service desk related data for on-premise reporting. This article lists a number of tables containing the list of entities. You can use these details to create new reports using your reporting tool.
...
| Name | Description | System Data Type | Extract Data Type |
|---|---|---|---|
| item_id | Identifier of the ticket-specific details from APP_ITEM | BIGINT | Long Integer (4) |
| case_id | Case ID | BIGINT | Long Integer (4) |
| ticket_id | An ID identifying a ticket | BIGINT | Long Integer (4) |
| ticket_status | Status of the ticket (New/Queued/Closed) | NVARCHAR(50) | Memo (-) |
| ticket_reason_code | Reason code for any action that is taken on the ticket which resulted in the state change. | NVARCHAR(50) | Memo (-) |
| modifieddatetext | Last Modified Ticket Date in formatted value (DD/MM/YYYY) | - - | Date/Time (8) |
| createddatetext | Ticket Created Date | - - | Date/Time (8) |
| modified_date | Last Modified Ticket Date | INT | Long Integer (4) |
| ticket_priority | Ticket Priority | NVARCHAR (50) | Memo (-) |
| ticket_description | Ticket Description | NVARCHAR (256) | Memo (-) |
| created_by_group_name | Group ID of the creator group of the ticket | NVARCHAR (50) | Memo (-) |
| createdbyname | First name of the ticket creator | --- | Text |
| createdbyname | Last name of the ticket creator | --- | Text |
| createdbyname | Name of the ticket creator | --- | Memo (-) |
| assigned_to_group_name | Name of group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assignedtoindividual | First name of the individual to whom ticket is assigned. | NVARCHAR | Text |
| assignedtoindividual | Last name of the individual to whom ticket is assigned. | ||
| assignedtoindividual | Name of individual to whom ticket is assigned. | - - | Memo (-) |
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) |
| modifiedbyname | First name of the person who modified the ticket. | NVARCHAR | |
| modifiedbyname | Last name of the person who modified the ticket. | NVARCHAR | |
| modifiedbyname | Last ticket modified. | - - | Memo (-) |
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) |
| requester | First name of the ticket requester. | NVARCHAR | |
| requester | Last name of the ticket requester. | NVARCHAR | |
| requesterrequester | Requester's name. | BIGINT | Memo (-) |
| person1_job_title | Requester's job title. | NVARCHAR (126) | Memo (-) |
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) |
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) |
| person1_hierarchical_path | Requester's organization hierarchical path | NVARCHAR (4000) | Memo (-) |
| person2_e_mail | Email id of the ticket requested for. | NVARCHAR | Text |
| requester2 | First name of the ticket requested for. | NVARCHAR | Text |
| requester2 | Last name of the ticket requested for. | NVARCHAR | Text |
| requester2 | Name of the requested for. | NVARCHAR | Text |
| person2_job_title | Job title of the ticket requested for. | NVARCHAR | Text |
| person2_phone1 | Phone number of the ticket requested for. | NVARCHAR | Text |
| person2_org_name | Requested for organization name. | NVARCHAR (50) | Memo (-) |
| person2_hierarchical_path | Requested for organization hierarchical path. | NVARCHAR (4000) | Memo (-) |
| ccti_id | ccti_id identifies the categorization of the ticket. | BIGINT | Long Integer (4) |
| ccti_class | CCTI Class | NVARCHAR (50) | Memo (-) |
| ccti_category | CCTI Category | NVARCHAR (50) | Memo (-) |
| ccti_type | The CCTI item type. | NVARCHAR (50) | Memo (-) |
| ccti_item | CCTI item | NVARCHAR (50) | Memo (-) |
| person1_alt_phone | Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) |
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) |
| ticket_solution_id | Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) |
| person2_alt_phone | Phone number of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (50) | Memo (-) |
| person2_alt_email | Email address of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (126) | Memo (-) |
| resolution | Ticket resolution. | NVARCHAR (4000) | Memo (-) |
| cause | Ticket cause. | NVARCHAR (50) | Memo (-) |
| severity | Severity specifies the ticket severity. | NVARCHAR (50) | Memo (-) |
| ticket_phase | The current lifecycle phase/stage of the service desk ticket. | NVARCHAR (50) | Memo (-) |
| ticket_source | Ticket source. | NVARCHAR (50) | Memo (-) |
| ticket_impact | Ticket impact. | NVARCHAR (50) | Text (255) |
| ticket_urgency | Ticket urgency. | NVARCHAR (50) | Text (255) |
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INTEGER |
...
Entity: DTX_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 |
|---|---|---|---|
| ci_id | The associated configuration item to the ticket. | BIGINT | Long Integer (4) |
| item_id | Item ID | BIGINT | Long Integer (4) |
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
Entity: DTX_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) |
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...