Report of Users in Appian

We had a similar issue, but did not find anything in Shared Components. So we ended up building a process.that
- Runs every quarter end
- Fetches all groups in Appian (excluding some system groups)
- For each group, fetches list of all users
- Stores this group-user mapping in the database
- Generate a CSV file, and creates a task to review the group-user mapping

Explore following three plugins, and these might help you.

1) Group Management Plugin (v1.0.0) [com.appiancorp.ps.plugins.groupmanagement]
forum.appian.com/.../summary

2) GroupFunctions (v3.1.0) [groupfunctions]

3) forum.appian.com/.../summary

Thank you! It does sound like this would take care of our need.

Do you store any user data in the database? It'd be much easier to generate a report from this data than from Appian user information.

The thread at forum.appian.com/.../e-253372 might also have some ideas for you to use.

I had a similar issue. We had a database that had some minor discrepancies, so I had to pull all users from the system and database and compare the two.

Go to your All Users group in the /designer interface. Click on the properties tab. The first item in the list of properties will be the Group Id, which will be a number like "12" or something.

Just create an expression rule and use getdistinctusers(*whatever that number is*) and you'll spit out an array of all your users' ids. You can then pass that into looping functions with user() to get what data you need out of each record, or other functions to format the list better. It's literally one line of code I just make and test in expression editor, then throw away without saving every time I need all the users.

You can also loop to run each record through isusermemberofGroup() functions or run getdistinctusers() on every group id you have to get your group memberships.

For the example above all you would have to write is this:

getdistinctusers(12)

They make it sound so heinously complicated in the help section, but that's seriously all you need to do.

Lisa, I believe the following shared component will do exactly what you need:

forum.appian.com/.../summary