A fIlter or report that shows active users who have NO assignments or work items | Community
Skip to main content
A
AshleyCa1
Level 2
February 15, 2018
New

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

  • February 15, 2018
  • 3 replies
  • 541 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

    A
    AshleyCa1Author
    Level 2
    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.

    MoniqueEvans
    Community Advisor
    MoniqueEvansCommunity Advisor
    Community Advisor
    September 26, 2018

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

    S
    SvenNiemetz
    Level 2
    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)

    Terms & ConditionsAccessibility statement

    Loading footer...