Skip to main content
New Participant
February 15, 2018
New

A fIlter or report that shows active users who have NO assignments or work items

  • February 15, 2018
  • 3 replies
  • 543 views

It would be nice to have a quick filter or user report that shows which of my active users do not have any assignments. We redistribute our Worker licenses pretty often and I do not have a quick way to see who can be deactivated based on users who no longer have any assignments/work items.

3 replies

New Participant
November 18, 2019

Hi there -

try this:


  • Create a USER report
  • In filters, switch to textmode and past in:
    • assignmentsOpTasksMM:ID_Mod=isblank
    • assignmentsTasksMM:ID_Mod=isblank
    • assignmentsProjectsMM:ID_Mod=isblank
    • isActive=true
    • isActive_Mod=eq
  • Switch back to Normal view
  • add any columns you want, eg I added
    • Name
    • License
    • Has Proof License
    • Access Level: Name
    • Last Login Date


This should give you what you asked: all users who are still active but have no assignments (not to project, task or Issues)

MoniqueEvans
New Participant
September 26, 2018

This would help with knowing which users need to be deactivated.

AshleyCa1Author
New Participant
February 15, 2018

I've tried creating several of my own reports to show this information and I have not found a way to show all active users with no assignments.