nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Copy attributes from an Asset

Samuel Boerhoop

In excel I am made a button, what copies different cells at the same time

Sub Copy_Active_Row_ICD()

With ActiveCell
.EntireRow.Copy Sheets("ICD").Range("A2")
End With

Sheets("ICD").Range("A2:L2").Delete
Sheets("ICD").Range("C2:F2").Delete
Sheets("ICD").Range("F2:DH2").Delete
Sheets("ICD").Range("A2:E2").ClearFormats
Sheets("ICD").Range("A1:E2").Copy

End Sub

Leftover are the following cells from Excel: CI Name, IP Address, MAC Address, ST Contractcode and Portnumber

But now we are going to use Jira Assets, we are not able to use this anymore!

Would it be possible to produce something similar, with the use of AQL: selecting an asset: with different selected attributes. or with another idea?

The assets module - isn't what the client is using, so that's why the copy methode > paste in the CMDB from the client.

Accepted answers

mr john_8cmnbt

You could achieve something similar in Jira Assets using AQL queries to select assets with specific attributes and then export the results. While it won’t be a direct copy-paste like Excel, you can filter the exact fields you need and export them to CSV for your CMDB. Another approach is to use Automation for Jira to pull asset data and populate custom fields or another table automatically.

Evgenii

Hi, @Samuel Boerhoop

If the goal is to copy a few values from one Assets object into another place, the usual approach in Jira Service Management is automation.
Assets supports automation smart values for object attributes, so you can reference fields like {{object.Name}} or {{object.IP Address}} inside a rule, and automation also includes an action to update an object's attribute values.

If this data should be copied into Jira issue fields, use a rule that triggers when the issue is created or when the Assets field changes, then edit the issue and map each destination field from the selected object’s attributes. If the data should be copied from one Assets object to another Assets object, use an Assets automation rule and the Update object action to write the target attributes from smart values. For referenced objects, syntax like {{object.ReferenceAttribute.Name}} is supported.

Assets does not have a VBA-style button that copies arbitrary columns in one step, so you'll need to map each attribute explicitly in the rule, which is safer and easier to maintain when attributes like CI Name, IP Address, MAC Address, Contract code, or Port number need to stay in sync.

Here are some Atlassian documents, how it can be done for Assets via Automation rules:
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-insight/
https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/

All comments

Jira Assets is not Excel, these are different applicaitons.

Assets module in JSM is like a database, not a spreadsheet.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management