list of all the groups and users in the CMS

Ronnie Passaro's Avatar

Ronnie Passaro

24 Jun, 2016 03:15 PM

What is the best way to pull a list of all the groups and users in the CMS? I was thinking of using web services.

  1. 1 Posted by Wing Ming Chan on 24 Jun, 2016 05:21 PM

    Wing Ming Chan's Avatar

    Hi Ronnie,

    It depends on how many users and groups you have on your instance. Cascade limits the number of search results to 250. That means at most you'll get 250 users, for example. Of course my library can return more than that, but it requires a bit of tweaking. See


  2. Support Staff 2 Posted by Tim on 01 Jul, 2016 02:37 PM

    Tim's Avatar

    Hi Ronnie,

    Another option would be to query the database directly. We never recommend making changes to the raw database data, but since this is just a read operation, it's not a problem:

    Get a list of Users:

    select userName from cxml_user;
    Get a list of Groups:
    select name from cxml_group;
    If this is something you are planning to run often or to use as part of some other script, I'd recommend going the Web Services route that Wing mentioned above.


  3. Tim closed this discussion on 29 Jul, 2016 08:33 PM.

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

Keyboard shortcuts


? 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


26 Aug, 2016 01:19 PM
25 Aug, 2016 03:02 PM
25 Aug, 2016 12:50 PM
24 Aug, 2016 08:43 PM
24 Aug, 2016 07:20 PM
21 Aug, 2016 01:20 PM