• Products
  • Documentation
  • Resources

Atlassian Analytics is in an early access program

Only people who are part of this invite-only early access program have access to Atlassian Analytics.

Schema for Jira Service Management

In addition to the tables for the Jira family of products, Jira Service Management has extra tables added to the Atlassian Data Lake schema.

JSM affected service mapping

The jsm_affected_service_mapping table holds associations between Jira Service Management issues and services. It uses the following columns:

issue_id (string)

The unique identifier of a Jira issue

It links to a record in the jira_issue table.

service_id* (string)

The unique identifier of a service

It links to a record in the service table.

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


JSM change

The jsm_change table captures change-related fields for Jira issues in Jira Service Management that have the change-management work category. It uses the following columns:

change_completion_at (datetime)

The actual date and time that the change ended

change_reason* (string)

A short description or code that indicates why the reporter needs the change

change_risk* (string)

The risk of implementing the change as determined by the change advisory board. It’s usually based on complexity, scope, testing, recovery, timing, etc.

Example values: Low, Medium, Critical

change_start_at (datetime)

The actual date and time that the change started

change_type* (string)

The category of the change

Example values: Emergency, Standard, Normal

impact* (string)

The effect of the change, usually in regards to service-level agreements—for example, Minor / Localized

issue_id (string)

The unique identifier of the issue. Use this as the primary key for Jira Service Management change data.

It links to a record in the jsm_issue table.

planned_end_at (datetime)

When the change request is planned to end

planned_start_at (datetime)

When the change request is planned to start

urgency* (string)

The time available before the business feels the request’s impact

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


JSM incident

The jsm_incident table captures change-related fields for Jira issues in Jira Service Management that have the incident-management work category. It uses the following columns:

impact* (string)

The effect of the incident, usually in regards to service level agreements—for example, Significant / Large

issue_id (string)

The unique identifier of the issue. Use this as the primary key for Jira Service Management incident data.

It links to a record in the jsm_issue table.

severity* (string)

A measurement of the impact an incident has on the business—for example, Sev-1

source* (string)

The asset or system where the incident originated—for example, Monitoring systems

urgency* (string)

The time available before the business feels the incident’s impact—for example, Critical

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


JSM incident responder

The jsm_incident_responder table lists the responders to an incident, as defined in Jira Service Management. It uses the following columns:

issue_id (string)

The unique identifier of the Jira issue representing the incident

It links to a record in the jira_issue table.

responder_account_id* (string)

The unique identifier of the incident responder

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


JSM issue

The jsm_issue table captures fields related to Jira Service Management for Jira issues (requests) in Jira Service Management. It uses the following columns:

issue_id (string)

The unique identifier of the issue. Use this as the primary key for request type data.

It links to a record in the jira_issue table.

request_type* (string)

The request type of the issue

satisfaction_rating* (number)

The rating given as part of a Jira Service Management issue satisfaction survey

satisfaction_submitted_at (datetime)

The time (UTC time zone) when the customer satisfaction (CSAT) survey was submitted

work_category* (string)

The work category of the request

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


JSM SLA

The jsm_sla table lists the issue service-level agreements (SLAs) defined in Jira Service Management. It uses the following columns:

breached* (string)

Indicates whether or not the SLA was breached

For ongoing cycles, this value may change over time, along with remaining_time_msecs.

Possible values: true, false, null

cycle_type* (string)

Indicates whether or not the current SLA cycle is ongoing or completed

Possible values: Ongoing, Completed

elapsed_time_msecs* (number)

Represents the time (in milliseconds) that has passed since the SLA cycle started

goal_duration_msecs* (number)

Only available for cycles where cycle_type is Completed

Represents time (in milliseconds) taken to complete the current cycle

issue_id (string)

The unique identifier of a Jira issue

It links to a record in the jira_issue table.

paused* (string)

Only available for cycles where cycle_type is Completed

Indicates whether or not the SLA cycle is paused

remaining_time_msecs* (number)

Represents the time (in milliseconds) remaining before the expected SLA limit is breached

Remaining times are calculated and updated every 30 minutes. Therefore, the provided value may not represent the actual current remaining time.

sla_id* (string)

The unique identifier of an SLA setting

sla_name* (string)

The name of the SLA that the SLA cycle belongs to

started_at* (datetime)

The time (UTC time zone) when the SLA cycle started

stopped_at* (datetime)

Only available for cycles where cycle_type is Completed

The time (UTC time zone) when the SLA cycle transitioned from Ongoing to Completed

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table


Service

The service table lists your Atlassian services defined in Jira Service Management. It uses the following columns:

created_at (datetime)

The time (UTC time zone) when the service was created

description* (string)

The description of the service

name* (string)

The name of the service

service_id (string)

The unique identifier of the service. Use this as the primary key for service data.

tier* (string)

The tier indicating service criticality

type* (string)

The type of service

updated_at (datetime)

The time (UTC time zone) when the object schema was last updated

workspace_id (string)

An Atlassian identifier that maps data to a site in the workspace_info table

Additional Help