We need to get list of all groups for each user in the system. We have >

Mahesh Sanga over 8 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?

Discussion posts and replies are publicly visible

Parents

0 pavithrac over 8 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

Reply

0 pavithrac over 8 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

Children

No Data