Add users from group to table

Question

Hi, 
 How to add users from groups in frontend to DB table? 
 Thanks, 
 Anandita

Chris · Answer

We do this with a nightly scheduled process for group association auditing. The process collects all groups, minus those groups added to a constant which are skipped (example, groups set to include all users in the system). We use the People Functions plugin's getallgroups() function, but you likely can use an OOTB function such as a!groupsByType(2,a!pagingInfo(1,-1)). You would then run a sub process over each of the groups (note you will be restricted to 1000 groups unless looping is applied), which retrieves members using a!groupMembers. Save the details to a CDT, utilize the Write to DataStore node to persist the details. 
 Note you will want to consider performance here if you have a high group list or high member counts. For that reason (and the 1000 max sub process call MNI) we do this with fn!executeStoredProcedure which runs over 1,530 groups in less than a minute.