Export Users and User Group Assignments

@rajendrans Did you try any approaches and got struck, as this will make the community help you resume towards solution?

Also, here goes a couple of suggestions which might or might not work for you but I believe these can kick start your thoughts towards building the solution:
1. Building a Task Report that works based on the context of the User and the analytics query may be iterated for each user in the environment.
2. In case if you are trying to get the assignments for a User by involving the User AND his/her membership Groups, then you may build an expression rule that queries analytics. One thing you need to do to facilitate this approach is, build a query analytics rule that queries All Tasks Report with filters as User and his membership Groups. (In case if you are interested, you can check the expression rule at /search?q=OriginalPostID-244965 which was built by me and this gets the tasks based on the task assignees which is nothing but the user and his/her membership groups in each iteration.)

The approaches stated above are based on the understanding of your post and in case if they deviate from actual requirements, it would be good if you can elaborate further as this would help us stay away from over engineering or inflating requirements.

If you are looking to retrieve all users from Appian instance you can apply a similar concept to 'APN All Users' where all users in the instance will be added to the group by a rule and then querying this group should be enough. Or you may also use the application's All Users group if available as suggested by @harrys. But querying the primary data store (whether it's an on-premise or cloud) should be avoided at least in this case (which isn't recommended as well) as we have other ways to do this.

@rajendrans Did you try any approaches and got struck, as this will make the community help you resume towards solution?

Also, here goes a couple of suggestions which might or might not work for you but I believe these can kick start your thoughts towards building the solution:
1. Building a Task Report that works based on the context of the User and the analytics query may be iterated for each user in the environment.
2. In case if you are trying to get the assignments for a User by involving the User AND his/her membership Groups, then you may build an expression rule that queries analytics. One thing you need to do to facilitate this approach is, build a query analytics rule that queries All Tasks Report with filters as User and his membership Groups. (In case if you are interested, you can check the expression rule at /search?q=OriginalPostID-244965 which was built by me and this gets the tasks based on the task assignees which is nothing but the user and his/her membership groups in each iteration.)

The approaches stated above are based on the understanding of your post and in case if they deviate from actual requirements, it would be good if you can elaborate further as this would help us stay away from over engineering or inflating requirements.

If you are looking to retrieve all users from Appian instance you can apply a similar concept to 'APN All Users' where all users in the instance will be added to the group by a rule and then querying this group should be enough. Or you may also use the application's All Users group if available as suggested by @harrys. But querying the primary data store (whether it's an on-premise or cloud) should be avoided at least in this case (which isn't recommended as well) as we have other ways to do this.