Versions Compared

Key

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

When managing any kind of assets in Jira or Jira ITSM, it is important to be able to structure and analyse this data. Any assets your company has and manages can influence the way you enhance your business strategy, that’s why the Insight data is so important to complete your Jira Tableau reports.

Insight fields are located in a separate tab:

...

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)

Insight

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)