How to create ticket when asset expires

[John Scheffer]

Hi,

We have some licenses in our asset database with an expiration date (ID 98).
I would like to receive a Jira service desk ticket 14 days before the expiration date
How can I turn this into an automation rule?

[Curt Holley]

Hi @John Scheffer 
Welcome to the community!

Create a rule with the scheduled trigger, set it for as often as you desire/require (daily perhaps).
Then do a lookupObjects action using AQL to find the Objects that will expire within the next 14 days.

Do an advanced branch on smart value {{lookupObjects}} and then do the Create issue action on the branch. This will create an issue for each object returned from the lookup.

This will get the basics going, but it gets more complicated if you want to update the object as well via automation, where an AQL branch is required, but that makes it harder to grab the object attributes for the issue.

I recommend, start simple and see how that goes.

[John Scheffer]

Hi Curt,

Thanks for your response. I will try it and let you know