tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/22493-list-of-all-the-groups-and-users-in-the-cmsCascade CMS: Discussion 2016-11-02T13:40:58Ztag:help-archives.hannonhill.com,2010-02-09:Comment/401892692016-06-24T17:21:01Z2016-06-24T17:21:01Zlist of all the groups and users in the CMS<div><p>Hi Ronnie,</p>
<p>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 <a href="http://www.upstate.edu/cascade-admin/projects/web-services/courses/introductory-course/introductory-lesson-7.php">
www.upstate.edu/cascade-admin/projects/web-services/courses/introdu...</a></p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/401892692016-07-01T14:37:24Z2016-07-01T14:37:24Zlist of all the groups and users in the CMS<div><p>Hi Ronnie,</p>
<p>Another option would be to query the database directly. We never
recommend making <em>changes</em> to the raw database data, but
since this is just a read operation, it's not a problem:</p>
<p>Get a list of Users:<br></p>
<pre>
<code>select userName from cxml_user;</code>
</pre>
Get a list of Groups:<br>
<pre>
<code>select name from cxml_group;</code>
</pre>
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.
<p>Thanks</p></div>Tim