Using Assets object data in my JSM report

Questions & Answers
,
1

Hi

We use Assets and JSM in our Atlassian. We use JSM request for laptop requests and use Assets for the actual asset itself. I am trying to create a report to reflect the ticket from the JSM with the object data from Assets. Ths is what I have done, but it is not working too well.
Btw we use eazybi cloud v6.+

  1. I have a laptop asset object called “Laptop AssetID” customfield_12407. That includes the following attributes: “Name, Model (Text), Total RAM (MB), Battery Health Status, Battery Cycle Count and 5 other attribute(s)”
  2. Added custom code to advanced settings from Assets object “Laptop AssetID (customfield_12407)”
#Used for Donations in ITSD
[jira.customfield_12407]
insight_object_attributes = [
  {name = "Computer Name", data_type = "text"},
  {name = "Serial Number", data_type = "text"},
  {name = "Model", data_type = "text"},
  {name = "Total RAM (MB)", data_type = "integer"}
]
  1. Did then did a Jira import
  2. Went to report, under Measures, added User defined measure “Get Total RAM (MB)”
[Laptop AssetID].CurrentHierarchyMember.Get('Total RAM (MB)')
  1. Do not see any data under column “Get Total RAM (MB)”

image
image2215×533 118 KB

image
image797×656 65 KB

2

Resolved:

Instead of using this as a custom measure:

[Laptop AssetID].CurrentHierarchyMember.Get('Total RAM (MB)')

Use this instead:

/* find member in the Laptop AssetID dimension 
that matches Laptop name in issue property */
StrToMember(
  "[Laptop AssetID].[" ||
  [Measures].[Issue Laptop AssetID]
  || "]"
--read property Total RAM for member in "Laptop AssetID" dimension
).Get('Serial Number')
1 Like