Sage CRM

In CRM I am showing under Current Users some users that aren't logged into CRM. They seem to be ""stuck"" users. Any idea how to clear them out of there?

IIS Reset is the best way. I have a couple of questions though: Is the ""Current Users"" impacting licensing in any way? If the users listed try to login to CRM, what happens?

I will try IIS Reset again. We rebooted the server but that didn't get them out. I am worried it would impact licensing once more users start getting into CRM. Plus, two of the users still showing under current users are not longer with the company and the CRM user has been deleted. They still show in the current users.

You can open CRM in multiple tabs on a single machine and try to login with all the actual users to see if it will be a problem. It sounds like a database thing. You could undelete the users (go into SQL and set user_deleted to NULL on their user records then login as them and then logout. That should solve the problem. (Their might actually be a field on the Users table that says that they are logged in but I don't have access to the database right now to check.)

I just did a *info in MAS and although only 3 users are currently logged into CRM it is show 8 licenses in use. Thus it is also eating up 5 of my EES/MAS licenses. I browsed the USER table in SQL and couldn't find a field that stood out for them being logged in. Also, I logged into CRM as one of the 'stuck' users and logged back out but their session is still showing in Current Users with a login date of 11/15/2011.

Is CRM activated in more than one company? That can cause duplication of ""licenses in use"".

Nope. I had already checked that (I learned that one about a month ago).

Regarding the MAS / EES licenses, I don't know exactly what is going on there and I'm not sure if this will fix things or make them worse so backup your db's before trying the following: 1. Go into MS SQL. 2. Pull up the Activity table and use the filter ""where acty_logout is null"". 3. This should return a list of the records for the current users. 4. Confirm this list - acty_userid matches with a user name via the Users table. If you know sql well you can join the tables to view it in one place. You can go two ways from here: A. Check all those users records and login with those specific accounts and log back out. You might need to undelete them first by setting user_deleted = NULL first. See if that resolves the problem for any / all of them. B. Manually update the acty_logout and acty_LogoutMethod fields with new values. I would do this only if step A doesn't work. NOTE: I can't stress this enough ... I have ZERO idea how this will impact MAS / EES licenses. Maybe this is a good opportunity to talk the client into upgrading to MAS 4.5 with separated Sage CRM ...

Thanks Peter. I will give that a try (after making a good backup). Unfortunately they have a 3rd party enhancement in MAS that is delaying them going to 4.5 (migrated off EES) otherwise we would upgrade them in a minute! I may even setup a test environment to restore they database to and test it in a non-production environment. I will let you know how it goes.

@PeterWolf I finally was brave enough to give this at try. I had to login as the users once and then do step B: as it didn't work by just logging in and logging back out. Thanks for your help.