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. |
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) |