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 www.upstate.edu/cascade-admin/projects/web-services/courses/introdu...

    Wing

  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.

    Thanks

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

Comments are closed, but you can start a new discussion.

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