Hi I want to write an automation which lets me know how many users in my JIRA who has access but has 0 tickets assigned to them and trigger an email to specific users with this report saying out of 103 users in JIRA software 10 users with the user details have no tickets assigned to them.
First thing, it appears you have duplicated this question with another post: https://community.atlassian.com/t5/Jira-Software-questions/How-to-get-the-users-list-by-automation/qaq-p/2318264 Please consider closing out one of them.
Next, what problem are you trying to solve by doing this? Knowing that may help to community to offer other suggestions. And, often people on teams collaborate. So it is likely many users do not have assigned issues at any given time. For example, consider teams using Pair Programming or Mob Programming, where only a single person would be assigned, regardless of the number of collaborators. Checking issue assignment may be measuring something that has nothing to do with the problem you are trying to solve.
Finally, you are asking about detecting the absence of information, which is more difficult in Jira. That cannot be done with out-of-the-box features of automation rules, JQL, etc. because most functions regarding assignment are indeed based on issue assignment. One complicated work-around could be an automation rule calling the REST API to get all users and repeated checking for issues counts; this would be a bad idea, as the rule would likely run up against service limits for rule execution. Looking for a marketplace addon might be a better idea.
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.