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.
Note: You can access these tables only if you access to your read-only database connecting from connectingthrough VPN.
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 as Views in the read-only database.
...
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 |
...