Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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 3

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)