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
  • 544 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 and Adobe Champion
    MoniqueEvansCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    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...