Generate list of users (total and active)

May's Avatar

May

14 Oct, 2013 01:27 PM

How can I generate a list of total and active users in Cascade? I have an administrator access.

  1. Support Staff 1 Posted by Tim on 14 Oct, 2013 02:17 PM

    Tim's Avatar

    Hi,

    You can see all of the active Users in the system by navigating to the Administration -> Dashboard. To view all Users in the system, you would need to switch to the Global Site (from the Site drop down menu), then click Administration -> Users, Groups, & Roles.

    If you are really just looking to generate very simple lists of active Users and total Users at any given time, your best bet would be to execute the following SQL queries against the database:

    To get active Users (those currently logged into the system):

    select username from cxml_login;
    
    This is the same as navigating to the Administration Dashboard as mentioned above.

    To get a list of all Users in the system (who are not disabled):

    select username from cxml_user where isEnabled=1;
    

    Let me know if you need more help!

  2. 2 Posted by May on 14 Oct, 2013 02:26 PM

    May's Avatar

    Thanks.

  3. Tim closed this discussion on 14 Oct, 2013 02:28 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac