We always wondered about this too. We assumed, as an external community, that it represented Guest User sessions, but the more we thought about it, the more that didn't make sense. Then we thought it represented invited but not registered users (we call them pseudo-users until they are approved) but that doesn't make much sense either.
So, inquiring minds want to know. What's the deal Jive? Sounds like 10 pounds of sugar in an 8 pound bag.
Here's my guess:
Registered users are all users ever registered
Total users are registered users minus any that have since left the company
So registered will always go up; while total users will go up and then fluctuate downward to account for departures
CMR Help says:
- Total Users
- All system users who have not been disabled.
- Registered users
- Users who have logged in at least once.
Doesn't sound like you have done it but creating users by API or creating users in Admin Console and then they ignore your site can make these look weird.
Jive support told me this in a past case:
For CMR. there are two steps that occur in the analytics DB to get the total user count. We first check the jivedw_user table which has all the updates for the user and exclude disabled users, non visible users, and non external users:
SELECT COUNT(*) FROM jivedw_user WHERE userenabled=1
AND user_id NOT IN (SELECT user_id FROM jivedw_non_visible_user UNION SELECTuser_id FROM jivedw_external_user);
Then as part of the ETL process, it places that into a summary table for CMR to get the data. CMR simply runs this query:
SELECT SUM(state) FROM jivedw_user_summary;
Hi Caitlin - in general this should not happen. However, since we are synchronizing 2 data sources nightly - errors can occur.
Please file a support case and the support team will help get to the bottom of this.