Is It Possible to Schedule a Daily Update/Checkup to Assets to Change a Status Based on the Date?

[Luke McDonnell]

Hi There,

I am relatively new to setting up automation in Jira and I am currently testing how well the Assets section of Jira works and what it is capable of doing.

I have created some automation that links and updates Assets based on Requests/Issues which is great but I am wondering if it can do the following or similar.

I have created Two attributes for my Laptops:

Warranty Expiry Date - Default - Date

and

Warranty Status - Status - 3 Months Until Warranty End/In Warranty/Warranty Expired

My goal is to have an Asset change its status automatically based on the current date so I can filter my assets by what needs to be upgrade/retired.

Is this possible or is there already a much more simple feature outside of Automation that exists?

Thank you for any help!

[Christopher Yen · Accepted solution]

Hi @Luke McDonnell 

Welcome to the community! What your proposing is definitely possible using a scheduled global automation paired with an AQL search and then using the action of "Edit object attributes" I'll post a screenshot of one of my rules below that checks if a workstation is 3 years old then it marks it as eligible for upgrade. 

 

One limitation I've observed is that if the amount of records is too large it doesn't update all of them, it seems to cap out around 20 from what I've seen which is why I try to capture a range and have the job run once an hour before business hours so if it doesn't catch it in the first round it will hopefully catch it in the subsequent rounds. A dashboard query would be more reliable but I believe it will need to be built in Analytics which not everyone has access to

[Luke McDonnell]

Hi Christopher,

Thank you for this!

I ended up coming up with similar but yet to try with a larger amount of records so thank you for the range suggestion as I will definitely make use of that if I come across the same issue.

Thanks again.

[Fanny Vachet]

Hi @Christopher Yen ,

That's great! Thanks for the rule. I'm now trying to get some details from each asset that match the AQL test in the branch and use it in creating tickets.

Is it possible?

Thanks

Fanny