Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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


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

📅 Partner Webinar & Events Opportunities: July 2022

Hi community 👋, Here is another monthly roundup of the partner-organized events in July 2022. If there is any event missing please let me know in the comments below 🙏 If you're looking for Atla...

29 views 0 2
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