Data Extract is the process of viewing data from the CSM data source. 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.
...
Data Extract is enabled by a set of scripts that run against the customer’s Production database. The script executes queries to extract data from the database and this extracted data is exported to an MS Access file. The Data Extract process runs on the server that hosts customers’ Production databasesas Views in the read-only database.
The table below lists the entities that are extracted and exported to the MS Access fileand views are created and made available. The following entities are present in the Data Extracts:
...
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 |
...