JIRA Filtering: Can I report zeroes or project members without assignments?

Question

So I'm trying to create a query that will show me who doesn't have anything assigned to them but the JQL is eluding me. Another acceptable answer would be a filter that displays EVERYONE in the project and their number of assignments including zeroes?

Specifically, I'm trying to get this into a gadget.

unknown · Answer

Can you try the "workload pie chart"? It will kinda help you.

j_belousek · Answer

Currently, I am handling this process through Excel: Column 1 = Roster, Column 2 = JQL query results of assignees within the project. Which is a process that needs to be maintained and creates room for error.

Thanks for the link and the SQL suggestion!

Nicolas Bourdages · Answer

Well, a JQL query will always return you issues, not people.

That sounds like a job for Excel 
.

OR

for a SQL query straight from the database. Which you would set in a datatable custom field, using the database custom field plugin

Not sure what gadget could display that on your dashboard though, but you'd be a good way along. Hope you're using Server and not Cloud!

Good luck!