Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Schema for asset and configuration management
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.
The diagram above shows the relationships between the schema for asset and configuration management, the schema for the Jira family of products, and the schema for Jira Service Management. Columns in bold are the primary keys of the table that they’re in.
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.
Tables for asset and configuration management data
Assets object
The asset_object table describes individual objects defined under the object types and object schemas.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the object was created.
SQL name | created_at |
|---|---|
Data type | Datetime |
Key*
The key associated with the object.
SQL name | key |
|---|---|
Data type | String |
Label*
The name of the object.
SQL name | label |
|---|---|
Data type | String |
Object ID
The unique identifier of the object. Use this as the primary key for object data.
SQL name | object_id |
|---|---|
Data type | String |
Object reference*
The identifier of the object type.
SQL name | object_ref |
|---|---|
Data type | String |
Object schema ID
The unique identifier of the object schema.
SQL name | object_schema_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object_schema table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type ID
The unique identifier of the object type that the object belongs to.
SQL name | type_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_type table. |
Updated at
The date and time (UTC time zone) when the object was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets 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.
The table uses the following columns:
Attribute value object ID
The object_id that’s stored in the value of an attribute.
SQL name | attribute_value_object_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object table. |
Attribute value string*
The string value of the attribute.
The value is NULL if the attribute type is OBJECT.
SQL name | attribute_value_string |
|---|---|
Data type | String |
Object ID
The unique identifier of the object.
SQL name | object_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type attribute ID
The unique identifier of the object attribute.
SQL name | type_attribute_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_type_attribute_metadata table. |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets object issue mapping
The asset_object_issue_mapping table maps objects to Jira issues.
The table uses the following columns:
Field ID
The unique identifier of the field in which the object is stored.
SQL name | field_id |
|---|---|
Data type | String |
Issue ID
The unique identifier of the Jira issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table in the schema for Jira family of products. |
Object ID
The unique identifier of the object.
SQL name | object_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets 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.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the schema was created.
SQL name | created_at |
|---|---|
Data type | Datetime |
Description*
The description of the object schema.
SQL name | description |
|---|---|
Data type | String |
Key*
The key associated with the object schema.
SQL name | key |
|---|---|
Data type | String |
Name*
The name of the object schema.
SQL name | name |
|---|---|
Data type | String |
Object schema ID
The unique identifier of object schema. Use this as the primary key for object schema data.
SQL name | object_schema_id |
|---|---|
Data type | String |
Object schema reference*
The identifier of the object schema used at the instance level.
SQL name | object_schema_ref |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the object schema was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets type
The asset_type table describes the names, descriptions, unique identifiers, and creation metadata for all object types defined within asset and configuration management.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the object type was created.
SQL name | created_at |
|---|---|
Data type | Datetime |
Description*
The description of the object type in the schema.
SQL name | description |
|---|---|
Data type | String |
Does pass attributes to child objects*
Indicates whether the object type passes its attributes to child objects.
The value is true if does; otherwise, it is false.
SQL name | does_pass_attributes_to_child_objects |
|---|---|
Data type | Boolean |
Is abstract*
Indicates whether the object is abstract or not.
The value is true if the object is abstract; otherwise, it is false.
SQL name | is_abstract |
|---|---|
Data type | Boolean |
Name*
The name of the object type in the schema.
SQL name | name |
|---|---|
Data type | String |
Parent type ID
The unique identifier of the parent object type.
SQL name | parent_type_id |
|---|---|
Data type | String |
Foreign key | Links to another record in this table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type ID
The unique identifier of the object type. Use this as the primary key for object type data.
SQL name | type_id |
|---|---|
Data type | String |
Type reference*
The identifier of the object type.
SQL name | type_ref |
|---|---|
Data type | String |
Updated at
The date and time (UTC time zone) when the object type was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets type attribute metadata
The asset_type_attribute_metadata table provides the metadata for object attributes.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the attribute was created.
SQL name | created_at |
|---|---|
Data type | Datetime |
Description*
The description of the attribute.
SQL name | description |
|---|---|
Data type | String |
Name*
The name of the attribute.
SQL name | name |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type of the attribute.
SQL name | type |
|---|---|
Data type | String |
Type attribute ID
The unique identifier of the object attribute.
SQL name | type_attribute_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object_attribute table. |
Type attribute reference*
The identifier of the attribute.
SQL name | type_attribute_ref |
|---|---|
Data type | String |
Updated at
The date and time (UTC time zone) when the attribute was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets type attribute type mapping
The asset_type_attribute_type_mapping table maps object types to object type attributes.
The table uses the following columns:
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type attribute ID
The unique identifier of the object attribute. Use this as the primary key for this mapping.
SQL name | type_attribute_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_type_attribute_metadata table. |
Type ID
The unique identifier of the object type.
SQL name | type_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_type table. |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Assets type schema mapping
The asset_type_schema_mapping table provides links between object types and the object schemas to which they belong.
The table uses the following columns:
Object schema ID
The unique identifier of the object schema.
SQL name | object_schema_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_object_schema table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type ID
The unique identifier of the object type.
SQL name | type_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the asset_type table. |
Workspace ID
The unique identifier of the asset and configuration management workspace.
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Was this helpful?
Still need help?
The Atlassian Community is here for you.