I would like to add a field and populate it with the names of all the groups the user is a member of. The goal is to have a VL field on Contacts that I can use as a filter on a Cross-Reference field.
A calculation is preferable but a SQL data feed is also an option. Better yet instructions on how to extend the Contact Synch tool recently released by RSA would be appreciated.
We are using data feed to populate/update value list field on employee contacts.
For our setup we populate a table with contacts information, DF then updates contacts records from that intermediate table. Prior to that Archer update we have a process that queries Archer user tables to pull the assigned groups for each user.
Louis could share more information on the query you use to get the assigned group data? That sounds like what I'm looking for. Especially if I drop it into a data feed.
Essentially it uses User ID an User Name from tblUser, User ID and Group ID from viewUserGroupList, and User ID and Group ID and Group Name from viewGroupList.
viewUserGroupList has one row per User ID and Group ID combination
viewGroupList has one row for each Group ID, Group Name
SELECT U.[user_id], U.[user_username] AS 'RACFID', Z.[group_name] FROM (SELECT [user_id], [user_username] FROM [Archer].[dbo].[tblUser] WHERE [acct_status_id] = 1) U, (SELECT UG.[user_id], G.[group_name] FROM [Archer].[dbo].[viewUserGroupList] UG JOIN [Archer].[dbo].[viewGroupList] G ON UG.[group_id] = G.[group_id]) Z WHERE U.[user_id] = Z.[user_id] ORDER BY 2