All Collections
Building Reports
Running Active User Reports
Running Active User Reports


Updated over a week ago

Attention: Social Solutions is now Bonterra. Please bear with us as we update our screenshots to match our new name.

It may be in your interest to know what users are active in your system and how many users are accessing your system. There are a couple ways to extract this information.

Accessing at-a-glace Active User Count

  1. Login to ETO

  2. Site Administration

  3. Manage User Accounts

  4. Show all sites

  5. Filter username not equal to “bonterra”.

    Only authentic accounts will be filtered out of Bonterra active user counts.

  6. See bottom of page

  7. This account has 25 users in the entire Enterprise.

List of Active Users - ETO Results

  1. Access the reporting Dashboard

  2. Open a new report from the reporting dashboard.

  3. Choose a universe

  4. Choose the Standard Staff Universe

  5. Build a query

  6. Choose "Name" and "Email" (Add "Login Date" to see most recent Logins)

  7. In the query filters you should use

    • [Is Disabled] = No

    • [Site Name] = Is Not Null (or only include Active / desired sites)

    • [Role] Not Equal to "Developer"

  8. [Email] Different from pattern "%bonterra%" Only authentic accounts will be filtered out of Bonterra active user counts.

  9. Refine the Data / Return Results

    You now have a return of all active accounts in your system. You can include more information in your Results Objects, or include other filters to narrow down results.

  10. If you included "Login Date" Click in to the column and in the upper FX bar, write in =Max([Login Date]). Press Enter to return each users maximum Login Date. 

  11. Right click the email section and click "Insert" >"Count", this will produce a to count at the bottom of the page.

  12. Export the report to Excel.

  13. Save the Report to a Public of Favorite folder as an "Active User Count" report

List of Active Users - Query Wizard

Step 1: Go to Wizards > Query Wizards > Select "Staff" as the Subject Type

Step 2: Select "Staff Information"

Step 3: Choose the Information you'd like to see. To get a list of active users, I've included "Disabled" , "Site Name", and "Email"

Step 4: Returned is a list of users. If users have access to multiple sites, their names will be listed for every site they have access to.

Step 5: You can export the report to Excel and count unique emails; be sure you are checking on who is/isn't disabled in the sites.

Did this answer your question?