Automation for assets

[Antonia]

Hello, I need an automation for the assets: If the “Device Name” field contains “iPhone”, “iPhone” should be entered in the “Tag” field. I have already created an automation with AI, but I am stuck with the AQL, I have no idea what to write in there.

My current automation looks like this:

When: Object created

If: Object matches AQL?!?!

Then: Edit Assets field attributes

And I also don't know whether the last step is correct, because I can't select my “tag attribute” at all.

[Jeroen Poismans · Accepted solution]

Hi!

Do I understand it correctly that you don't know or understand AQL or that you just can't find this specific case.

Have you tried looking here for syntax help?
https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/

For this case i think this should work:

"Device Name" LIKE "iPhone"

However, you are doing a text search here. A more robust, future proof and scalable way to set this up would be to create an extra ObjectType with all your "Brands" or "Types" and then link your iPhone asset to a "Type" iPhone.

Your AQl would then be something like:

"Device Type" IN ("iPhone")

or

"Brand" IN ("Apple")

Jeroen