Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a time report showing ALSO users with 0 time logued

I do not minf if it is not made from the regular Tempo repoting tool, vould be using AIO or JQL.

I need to be able to report on all users that are responsible of an open ticket (any).  Including if they do not log time.  So report would also display Users with 0 hr reported.


Any idea on how to achieve that?





3 answers

1 accepted

0 votes
Answer accepted
Elifcan Cakmak Community Leader Jan 26, 2021


You can use "timespent is EMPTY" jql for searching all issues that have no work log on them. From there you can diverse the search and filter the users. For example if you want all completed issues with no work log on them, use "timespent is EMPTY AND resolution is not EMPTY" 

After that you can export your search and filter the excel with assignee column.

Hope that helps.


Thanks for the tips, I was able to work around my issue using your help!

Like Elifcan Cakmak likes this

Hello @Yann de Champlain

you can achieve this easily with our Worklogs - Time Tracking and Reports app for Jira if you are open to other apps. Let me briefly explain how to prepare such a report:

1. Select a project you are interested in (or a JQL filter if you want more specific criteria - such as whether the ticket is open/in progress)
2. Select the users you are interested in
3. Select the date range if the preselected one is not satisfying

The report that is generated will show users that have logged the time and those that didn't.


Screenshot from 2021-01-26 10-01-06.png

Best regards,

Thanks. It seems very good however I cannot have the plugin added to our environnement.

Hi @Yann de Champlain

I would like to encourage you to submit a feature request for this in our idea portal.


Seems like it was alreaud there in some ways. I found a check box to include zeros from AIO.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

116 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you