Schema for asset and configuration management

This is available only to customers in the Opsgenie and Insight EAP. Learn more about the EAP if you’re interested in joining or want more details.

Asset and configuration management is a feature in Jira Service Management used to track assets and services. With this feature, teams can track their assets, configuration items, and resources to understand and visualize the critical relationships between applications, services, their underlying infrastructure, and other key dependencies. Learn more about asset and configuration management.

If you include asset and configuration management data to an Atlassian Data Lake connection, you can query that data from the following tables:

Asset object schema

The asset_object_schema table describes the names, descriptions, unique identifiers, and creation metadata for all object schemas defined within asset and configuration management.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Example data	Description
`created_at`	Datetime	`2021-05-08 06:41:40.707000000`	Time when the schema was created (UTC time zone)
`description`	String	`Schema storing all service objects`	Description of the object schema
`jira_workspace_id`	String		Unique identifier of the Jira site
`key`	String	`SVC`	Key associated with the object schema
`name`	String	`Services`	Name of the object schema
`object_schema_id`	String		Unique object schema identifier Use this as the primary key for object shema data.
`object_schema_ref`	String		The identifier of the object schema used as the instance level
`updated_at`	Datetime	`2021-12-10 06:41:40.707000000`	Time when the object schema was last updated (UTC time zone)
`workspace_id`	String		Unique identifier of the asset and configuration management workspace

Asset type

The asset_type table describes the names, descriptions, unique identifiers, and creation metadata for all object types defined within asset and configuration management.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Example data	Description
`created_at`	Datetime	`2021-12-08 06:41:40.707000000`	Time when the object type was created (UTC time zone)
`description`	String	Macbooks for employees	Description of the object type in the schema
`is_abstract`	Boolean	true	`true` if the object is abstract; otherwise, `false`
`jira_workspace_id`	String		Unique identifier of the Jira site
`name`	String	Macbooks	Name of the object type in the schema
`object_schema_id`	String		Unique identifier of the object schema
`parent_type_id`	String		Unique identifier of the parent object type
`type_id`	String		Unique identifier of the object type Use this as the primary key for object type data.
`type_ref`	String		Identifier of the object type
`updated_at`	Datetime		Last time the object type was updated (UTC time zone)
`workspace_id`	String		Unique identifier of the asset and configuration management workspace

Asset type schema mapping

The asset_type_schema_mapping table provides links between object types and the object schemas to which they belong.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Description
`object_schema_id`	String	Unique identifier of the object schema
`type_id`	String	Unique identifier of the object type
`workspace_id`	String	Unique identifier of the asset and configuration management workspace

Asset object

The asset_object table describes individual objects defined under the object types and object schemas.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Example data	Description
`created_at`	Datetime	`2019-05-08 06:41:40.707000000`	Time when the object was created (UTC time zone)
`jira_workspace_id`	String		Unique identifier of the Jira site
`key`	String	`BT-10`	Key associated with the object
`label`	String	`Macbook 1`	Name of the object
`object_id`	String		Unique identifier of the object. Use this as the primary key for object data.
`object_ref`	String	`123`	Identifier of the object type
`object_schema_id`	String		Unique identifier of the object schema
`type_id`	String		Unique identifier of the object type that the object belongs to
`updated_at`	Datetime	`2021-08-12 06:41:40.707000000`	Time when the object was last updated (UTC time zone)
`workspace_id`	String		Unique identifier of the asset and configuration management workspace

Asset object connected issue

The asset_object_issue_mapping table maps objects to Jira issues.

It uses the following columns:

Column	Data type	Example data	Description

Column

Data type

Example data

Description

field_id

String

Identifier of the field in which the object is stored

issue_id

String

The unique identifier of the Jira issue

Use this as the primary key for issue data.

workspace_id

String

Unique identifier of the Jira site

Asset type attribute metadata

The asset_type_attribute_metadata table provides the metadata for object attributes.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Example data	Description
created_at	Datetime	`2019-05-08 06:41:40.707000000`	Time when the attribute was created (UTC time zone)
description	String	`Version of MacBook`	Description of the attribute
jira_workspace_id	String		Unique identifier of the Jira site
name	String	`Version`	Name of the attribute
type	String	`Default` / `User` / `Group` / `Status` / `Object`	Type of the attribute
type_attribute_id	String		Unique identifier of the object attribute
type_attribute_ref	String	`5`	Identifier of the attribute
updated_at	Datetime	`2021-08-12 06:41:40.707000000`	Time when the attribute was last updated (UTC time zone)
workspace_id	String		Unique identifier of the asset and configuration management workspace

Asset object attribute

The asset_object_attribute table describes the attributes of each object and stores the value of those attributes. When the attribute is a string (for example, an address), it is stored in attribute_value_string. When the attribute is another object, the object_id of that object is stored in attribute_value_object_id.

It uses the following columns:

Column	Data type	Example data	Description

Column	Data type	Example data	Description
`attribute_value_object_id`	String		The `object_id` that’s stored in the value of an attribute. The attribute type should also show this.
`attribute_value_string`	String	Red	The string value of the attribute The value is `null` if the attribute type is `Object`.
`jira_workspace_id`	String		Uunique identifier of the Jira site
`object_id`	String		Unique identifier of the object
`type_attribute_id`	String		Unique identifier of the object attribute. Use this as the primary key for object attribute data.
`updated_at`	Datetime	`2021-08-12 06:41:40.707000000`	Time when object was last updated (UTC time zone)
`workspace_id`	String		Unique identifier of the asset and configuration management workspace

Asset type attribute type mapping

The asset_type_attribute_type_mapping table maps object types to object type attributes.

It uses the following columns:

Column	Data type	Example data	Description

Column

Data type

Example data

Description

type_attribute_id

String

Unique identifier of the object attribute

Use this as the primary key for this mapping.

type_id

String

Unique identifier of the object type

workspace_id

String

Unique identifier of the asset and configuration management workspace