Can an automation or rule create a list?

[Antonia]

The rule should run on the first day of every month and check each asset schema to see which attributes (that we define in advance) are empty, and then generate a list of those empty attributes. Is that possible? I've already tried that with Rovo, but I didn't get very far.

Here's how I imagine the list would look:

Schema: XYZ
Object ID: 12345
Empty attributes:
1. Name
2. Date
3. xyz

Maybe so that you can export them to an Excel spreadsheet?

[Marc -Devoteam-]

Hi @Antonia 

As mentioned by @Aaron Pavez _ServiceRocket_ this will be a pain to maintain and you will probably lead that you run into API call limitations on your instance.

But more important, you will definitely run into automation rule time-out.

A rule times out when running for 5 minutes and has not finished.

This is not a solution to implement via automation.

[Aaron Pavez _ServiceRocket_]

Hi @Antonia 

Doing this with automation will be a pain. Especially since you need to match values and create a list out of it.

You will have better luck with a script and using jira API or export all objects to a spreadsheet and check the missing values there.
Gemini, for example, can help you with that. If you feed it what you are looking for and you feed it the spreadsheet to look for those values, it might be worth checking.

Regards

[Alan Bruce]

I have wondered about this as well. I have been manually exporting and then using conditional formatting in Excel. This would be way better. I am hoping someone is able to provide a solution.