One of the JIRA users has left the company and transition was not smooth. As a result, there are still components (across multiple projects) which have the user either as default assignee or component lead. I want to determine which are these components so that I can reassign. Is this possible via JQL?
This is not possible using JQL. JQL can only return issues, not components in it's result set. Here is a postgresql query which should help you get what you need:
select pname, cname, component.lead from component join project on (component.project = project.id) where lead = 'username';
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG