Home → How Do I... →

list of all the groups and users in the CMS

• Edit

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

   

   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 01 Jul, 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 29 Jul, 2016 08:33 PM.