Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

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

Avatar

Level 2

2/15/18

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 Comments

Avatar

Level 2

2/15/18

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.

Avatar

Level 2

11/18/19

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)