Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
8 replies
Subscribers
9 subscribers
Views
4638 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We need to get list of all groups for each user in the system. We have >
Mahesh Sanga
over 9 years ago
We need to get list of all groups for each user in the system.
We have >4000 users and each user is part of >100 groups.
At the end we would like to have this data in an Excel file or somewhere. Any ideas on how to implement this?
OriginalPostID-191746
OriginalPostID-191746
Discussion posts and replies are publicly visible
0
Eduardo Fuentes
Appian Employee
over 9 years ago
forum.appian.com/.../ppian Users and Group Membership
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@maheshv Have you had a chance to take a look at 'Appian Users and Group Membership' Shared Component at
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pavithrac
over 9 years ago
Hi Mahesh,
we can get all the groups of a user by using the following expression,
getgroupnames(getgroupsformemberuser(<username>)) and you can export the values to CDT in two ways:
1) Create a dummy CDT with three columns s.no, user, groups and write these values to that CDT and use Export CDT to Excel smart service
2) Create a process model use the expression and store the values in PVS and create a report and use Export to Excel smart service
Hope this helps...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mahesh Sanga
over 9 years ago
Thanks Eduardo, The application is much helpful.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mahesh Sanga
over 9 years ago
Sikhi, I Just downloaded it and could able to export the list of groups. Thanks. :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
Great, no problem Mahesh. :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 9 years ago
There is also a plugin available to download to Excel.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 9 years ago
Please go through this link:
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel