In this page

What is Insight?

(supported since Better Excel Exporter for Jira Cloud 0.7.0)

Insight is the leading asset management app for Jira, that allows implementing CMDB, CRM, HR, ITSM or ITIL functionality on the Jira platform.

Insight integration features

  • You can export the Insight-managed custom field type Insight Objects to Excel.
  • You can configure the export format to include object names (e.g. "My awesome server"), object keys (e.g. "My awesome server [SRVR-123]"), object attributes (e.g. "My awesome server [SRVR-123] (Manufacturer=Cray Research, Vector Processors=4, Type=Supercomputer)") and any combination of these.

(Need more features? Tell us in a support ticket!)

Insight integration vs. the Insight built-in Excel exports

You may want to ask: if Insight has a built-in Excel export feature, why would you use another app for the same?

While the Insight built-in Excel exports may be sufficient for basic use cases, the Better Excel Exporter integration is more powerful in, at least, these:

If at least one of these is important for you, give the app a try.

Tutorial video

Watch this short introductory video to see how fast you can export your Insight data to Excel! (Although the video below was captured in the app's Server version, the Cloud version is very similar.)

Insight Excel export samples

Jira issues with Insight objects

This straightforward Excel export (created using the default issue-navigator.xlsx template) contains two Insight custom fields: one of them is a single-select, while the other one is a multi-select type. Both use the "object name [object key]" format which is customizable.

jira-insight-export.xlsx

Jira issues with Insight objects and attributes

This Excel example is configured to export the complete attribute set for each Insight object. The attributes are exported to an Excel spreadsheet as comma-separated name-value pairs in brackets (the format is completely customizable).

jira-insight-export-objects-with-attributes.xlsx

Jira issues per Insight objects pivot chart

You can also create custom Excel reports from Insight data, just like from built-in custom field values. The insight-report.xlsx template calculates issue count per object, project distribution per object and status distribution per object. Looking for more? Create your own Insight Excel report from Jira using this template as a starting point.

jira-insight-report.xlsx

Configuration

Configuring the Insight custom fields

The Insight in Jira Service Management and Better PDF Exporter integration relies on the Jira REST API. After configuring the API access once (based on the guide below), Better Excel Exporter will automatically recognize the Insight-managed objects and export them accordingly.

Configuring REST API access for Insight in Jira Service Management

As this integration relies on the Jira REST API, you need to set your Jira email address and Jira API token for the REST API calls in the templates:

  1. First create a Jira API token. Copy the API token to the clipboard, you'll need it later!
  2. Click the cog icon "⚙" in the top right → Apps → Excel Templates (under Better Excel Exporter).
  3. Open the field-helper-tool.groovy script for editing, and find this section:
    /* Insight in Jira Service Management authentication. */
    def insightUserEmail = '' // Jira Cloud user email address
    def insightApiToken = '' // Jira Cloud API token
    
  4. At insightUserEmail add your Jira email address between the apostrophes (don't remove the apostrophes!).
  5. At insightApiToken paste the Jira API token from the clipboard between the apostrophes (don't remove the apostrophes!).
  6. Save the changes. (Don't worry about storing tokens here: this file is visible only for Jira administrators, who would have super-user permissions anyway.)

Configuring the export format for the Insight custom fields

The default behavior is that object names and object keys will be exported (e.g. "My awesome server [SRVR-123]"). You can include object name, object key and attributes by setting these configuration variables in the top part of the field-helper-tool.groovy script:

// field-helper-tool.groovy

/* Insight configuration. */
def insightObjectsWithNames = true
def insightObjectsWithKeys = true
def insightObjectsWithAttributes = false

If you want full control over the export format, please see this easy-to-read method in field-helper-tool.groovy:

private def insightObjectToString(def object)

Learn more about Insight