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. 

[Evgenii · Accepted solution]

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/

[Samuel Boerhoop]

Certainly will take a look at the automation - Thanks

[mr john · Accepted solution]

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.

[Samuel Boerhoop]

Thanks will take a look into it

[Marc -Devoteam-]

Hi @Samuel Boerhoop 

Jira Assets is not Excel, these are different applicaitons.

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

See also @Evgenii post.

[Samuel Boerhoop]

Sure i know that these are different applications - doesn't mean it wont be possible, whether in one way or another