Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Assets (Insight) refers to resources, elements, or entities that are managed within the context of a project or organization. When managing any kind of assets in Jira or Jira ITSM, it is crucial to be able to structure and analyze this data. Any assets your company has and manages can influence how you enhance your business strategy. That’s why the Assets data is so essential to export to your SQL database.

Info

Assets fields can be found in a separate tab.

Assets.gif
Info

The following fields are available for export ⬇️

Fields Names and IDs

Object Schema

Name (INSIGHT_OBJECT_SCHEMA_NAME)

Update (INSIGHT_OBJECT_SCHEMA_UPDATED)

Description (INSIGHT_OBJECT_SCHEMA_DESCRIPTION)

Object Schema Key (INSIGHT_OBJECT_SCHEMA_OBJECT_SCHEMA_KEY)

Create (INSIGHT_OBJECT_SCHEMA_CREATED)

Object

Name (INSIGHT_OBJECT_NAME)

Object Key (INSIGHT_OBJECT_OBJECT_KEY)

Created (INSIGHT_OBJECT_CREATED)

Description (INSIGHT_OBJECT_DESCRIPTION)

Object Name & Key (INSIGHT_OBJECT_OBJECT_NAME_KEY)

Update (INSIGHT_OBJECT_UPDATED)

With Avatar (INSIGHT_OBJECT_WITH_AVATAR)

Object Type Id (INSIGHT_OBJECT_OBJECT_TYPE_ID)

Label (INSIGHT_OBJECT_LABEL)

Object Type Name (INSIGHT_OBJECT_OBJECT_TYPE_NAME)

Object Type

Name (INSIGHT_OBJECT_TYPE_NAME)

Parent Object Type Id (INSIGHT_OBJECT_TYPE_PARENT_OBJECT_TYPE_ID)

Description (INSIGHT_OBJECT_TYPE_DESCRIPTION)

Inherited (INSIGHT_OBJECT_TYPE_INHERITED)

Object Schema Id (INSIGHT_OBJECT_TYPE_OBJECT_SCHEMA_ID)

Object Schema Name (INSIGHT_OBJECT_TYPE_OBJECT_SCHEMA_NAME)

Object Type Attribute

Name (INSIGHT_ATTRIBUTE_NAME)

Object Type Name (INSIGHT_ATTRIBUTE_OBJECT_TYPE_NAME)

Additional Value (INSIGHT_ATTRIBUTE_ADDITIONAL_VALUE)

Description (INSIGHT_ATTRIBUTE_DESCRIPTION)

Removable (INSIGHT_ATTRIBUTE_REMOVABLE)

Label (INSIGHT_ATTRIBUTE_LABEL)

Created (INSIGHT_ATTRIBUTE_CREATED)

Object Type Id (INSIGHT_ATTRIBUTE_OBJECT_TYPE_ID)

Updated (INSIGHT_ATTRIBUTE_UPDATED)

Status Type

Name (INSIGHT_STATUS_TYPE_NAME)

Description (INSIGHT_STATUS_TYPE_DESCRIPTION)

Object Schema Id (INSIGHT_STATUS_TYPE_OBJECT_SCHEMA_ID)

Object Schema Name (INSIGHT_STATUS_TYPE_OBJECT_SCHEMA_NAME)

Role

Name (INSIGHT_ROLE_NAME)

Object Type Id (INSIGHT_ROLE_OBJECT_TYPE_ID)

Description (INSIGHT_ROLE_DESCRIPTION)

Object Type Name (INSIGHT_ROLE_OBJECT_TYPE_NAME)

Object Schema Id (INSIGHT_ROLE_OBJECT_SCHEMA_ID)

Object Schema Name (INSIGHT_ROLE_OBJECT_SCHEMA_NAME)

Insight Attribute Value

Object ID (INSIGHT_ATTRIBUTE_VALUE_OBJ_ID)

Integer Value (INSIGHT_ATTRIBUTE_VALUE_INTEGER)

Additional Value (INSIGHT_ATTRIBUTE_VALUE_ADDITIONAL)

Object Type Attribute ID (INSIGHT_ATTRIBUTE_VALUE_OBJ_TYPE_ATTR_ID)

Double Value (INSIGHT_ATTRIBUTE_VALUE_DOUBLE)

Referenced Object Id (INSIGHT_ATTRIBUTE_VALUE_REF_OBJECT_ID)

Object Type Attribute Name (INSIGHT_ATTRIBUTE_VALUE_OBJ_TYPE_ATTR_NAME)

Date Value (INSIGHT_ATTRIBUTE_VALUE_DATE)

Object Attribute Id (INSIGHT_ATTRIBUTE_VALUE_OBJ_ATTR_ID)

Text Value (INSIGHT_ATTRIBUTE_VALUE_TEXT)

Boolean Value (INSIGHT_ATTRIBUTE_VALUE_BOOLEAN)