Home → How Do I... →

list of all the groups and users in the CMS

• Edit

Ronnie Passaro

Jun 24, 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 Jun 24, 2016 @ 05:21 PM

   

   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

   • Edit

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

   

   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

   • Edit

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