Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Possibility to reduce Output from a Jira Insight Report to one or more Attributes

Maik Bakowski June 7, 2018

Hello Communitiy,

 

is it possible, to reduce the Output from a Report in Jira Insight to one or more Attributes? For Example, i want to create a Catalog Report for the User XXYYZZ, which should display all Devices for which the User is Owner.

 

Devices like Server or other Hardware have Attributes like Name, Created, Status, Type, Serial Number, MAC Address, Distributor and more. The Output from the Report shows me all Devices with all Attributes, for Example....... (IQL Filter for this Report was ... Owner = "XXYYZZ")

Object Type Computer

  • Computer
    • Key: Unique Key from Insight
    • Name: Model
    • Created: Date
    • Updated: Date
    • Date of Purchase: Date
    • Warranty Expiration Date: Date
    • FQDN: DNS Name of the Device
    • Status: Status
    • Owner: XXYYZZ
    • Location: Location from the Device
    • Manufacturer: Manufacturer
    • Distributor: Distributor
    • Type: Type
    • Serial Number: Serial Number
    • MAC Address: MAC Address
    • Purchase Price: Price
    • Leasing:
    • Reference
      • Software: Software

 

My Question is, is it possible to reduce the Output for this Report to certain attributes like Name or Location? So that the Output is like......

Object Type Computer

  • Computer
    • Key: Unique Key from Insight
    • Name: Model
    • Owner: XXYYZZ
    • Location: Location

 

Perhaps with something like IQL Filter ... Owner = "XXYYZZ", select Key, Name, Location....?

 

Regards

Maik

1 answer

0 votes
PJ Wysota
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 7, 2018

I am afraid that with standard Insight Catalog report it is only possible, as it is fully predefined, to work with IQL - defining a scope in IQL like:

Leasing is EMPTY AND Distributor = XYZ

But this would limit the object filter, not attributes.

For the reports you mention it would require some custom config in eazy BI (as it can import Insight data) - however - data source for Insight are much heavier than for JIRA itself (number of attributes and references).

Another option might be two dimensional Insight report - for specific single attributes.

Maik Bakowski June 8, 2018

Hello,

thanks for your Answer. That means, with the Standard Reports and the per default stored Configurations it is not possible to reduce the Output from Attributes?

 

So i must install additional AddOns or additional Software?

 

Two Dimensional Reports are not so effective, because if i want to send a Report to one of our employees, which should contain all assigned Hardware, Software, Mobile Devices, Licenses and so on it will be complicated because all of this are different Object types and i can not select multiple Object Types in a Two Dimensional Report.

So i must create a Two Dimensional report for Hardware, one for Software, one for Mobile Devices and so on.

 

But thanks to your Suggestion.  :)

 

Regards

Maik

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events