Report of Users in Appian

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.

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.