• 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 asset and configuration management

Data for asset and configuration management is available only to customers in the Opsgenie and Insight early access program (EAP). Learn more about the Opsgenie and Insight EAP if you’re already part of the Atlassian Analytics EAP.

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:

Columns with an asterisk (*) are only available when you include all data for your products in a Data Lake connection. Learn more about how to set the scope of data for Atlassian Data Lake connections.

Asset object

The asset_object table describes individual objects defined under the object types and object schemas. It uses the following columns:

created_at (datetime)

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

key* (string)

The key associated with the object

label* (string)

The name of the object

object_id (string)

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

object_ref* (string)

The identifier of the object type

object_schema_id (string)

The unique identifier of the object schema. It links to a record in the asset_object_schema table.

type_id (string)

The unique identifier of the object type that the object belongs to. It links to a record in the asset_type table.

updated_at (datetime)

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

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


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:

attribute_value_object_id (string)

The object_id that’s stored in the value of an attribute. It links to a record in the asset_object table.

attribute_value_string* (string)

The string value of the attribute

The value is NULL if the attribute type is OBJECT.

object_id (string)

The unique identifier of the object. It links to a record in the asset_object table.

type_attribute_id (string)

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

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


Asset object issue mapping

The asset_object_issue_mapping table maps objects to Jira issues. It uses the following columns:

field_id (string)

The unique 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.

object_id (string)

The unique identifier of the object

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


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:

created_at (datetime)

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

description* (string)

The description of the object schema

key* (string)

The key associated with the object schema

name* (string)

The name of the object schema

object_schema_id (string)

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

object_schema_ref* (string)

The identifier of the object schema used at the instance level

updated_at (datetime)

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

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


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:

created_at (datetime)

The time (UTC time zone) when the object type was created

description* (string)

The description of the object type in the schema

does_pass_attributes_to_child_objects* (boolean)

Indicates whether the object type passes its attributes to child objects

The value is true if does; otherwise, it is false.

is_abstract* (boolean)

Indicates whether the object is abstract or not

The value is true if the object is abstract; otherwise, it is false.

name* (string)

The name of the object type in the schema

parent_type_id (string)

The unique identifier of the parent object type. It links to another record in this table.

type_id (string)

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

type_ref* (string)

The identifier of the object type

updated_at (datetime)

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

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


Asset type attribute metadata

The asset_type_attribute_metadata table provides the metadata for object attributes. It uses the following columns:

created_at (datetime)

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

description* (string)

The description of the attribute

name* (string)

The name of the attribute

type* (string)

The type of the attribute

type_attribute_id (string)

The unique identifier of the object attribute. It links to a record in the asset_object_attribute table.

type_attribute_ref* (string)

The identifier of the attribute

updated_at (datetime)

The time (UTC time zone) when the attribute was last updated

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


Asset type attribute type mapping

The asset_type_attribute_type_mapping table maps object types to object type attributes. It uses the following columns:

type_attribute_id (string)

The unique identifier of the object attribute. Use this as the primary key for this mapping.

type_id (string)

The unique identifier of the object type

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.


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:

object_schema_id (string)

The unique identifier of the object schema. It links to a record in the asset_object_schema table.

type_id (string)

The unique identifier of the object type

workspace_id (string)

The unique identifier of the asset and configuration management workspace. It links to a record in the workspace table.

Additional Help