Automated Change of Account Status RRS feed

  • Question

  • I am trying to manage the number of users using our licenses. Many users have never logged in (as evidenced by the manage users page under server settings). Is there some way that I can automate changing their Account Status to inactive to cut down on licenses or do I have to go through all of them and select Deactivate users.

    You can select multiple users at a time but I'm considering scale.


    PS: Please correct my assumption that "User State" is referring to them having a license if I am incorrect.

    Friday, June 27, 2014 4:26 PM

All replies

  • There are several ways to deactivate users, one you already mentioned would be manual,

    Are you using AD Sync ? if yes AD Sync automatically activates/deactivates user, so one way would be to have the AD Sync manage users and removal / addition to the AD group would activate / deactivate the users automatically

    Read more on AD Sync here -

    Another option would be to develop a custom solution to activate / deactivate user, which would use the PSI(Project Server Interface) to make the required changes

    To your last point, yes only an active user count a license   

    Thanks | epmXperts |

    Friday, June 27, 2014 5:26 PM
  • I'd probably just put them in a group that is either denied login rights - or remove them from all groups.  They may still show up in the license count screen, but in theory, you should be ok not having licenses for them.

    Note the best way to figure out who has permissions to log in is to run a SQL query on the Publish db determining which users are in which security groups.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky

    Saturday, June 28, 2014 2:53 AM
  • Hello kleinhansjy

    The solutions above are good to use. In addition to the above, I redefine Team Member to have not permissions and create a new group called PPM Members with the permission as original found in Team Members.

    The reason for this, Team Member is always assigned by default when creating accounts.  I want to deliberately add them or use AD sync to add them.

    Then I write a sql script to find all users that have not logged.  At this point you have either a list to use to set them inactive, or you can find out why they have not logged in and give them a hand.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Saturday, June 28, 2014 3:42 AM