Change AD Synchronization User Groups

Question

Hello,Which Oracle table holds information pertaining to AD User Integration Configuration page in IFS?My client has different AD User groups (around 30) for their TEST and PROD environments and we would like to update these groups (image below) automatically using a script following a DB clone. Manually deleting and re-creating 30 group mappings is time taking.Alternatively, is there any way to export and re-import the entire Configuration itself? This will make it very easy too.Our last option is to consolidate the 30 groups into 2-3 groups for TEST and re-add them manually following TEST clone. But hoping one of the above two options are available in IFS.TIA!

dhlelk · Accepted Answer

Hi@Srikanth,Which Oracle table holds information pertaining to AD User Integration Configuration page in IFS?My client has different AD User groups (around 30) for their TEST and PROD environments and we would like to update these groups (image below) automatically using a script following a DB clone.I used the framework debug feature to pick up the Activity API being called when populating the "Active Directory User Integration Configuration" window (Solution Manager\Security\Users\).There are several tables holding information pertaining to the above window in IFS. You might have some luck if you view all the database objects LIKE 'ad_%'.Eg: AD_CONFIG_TAB, AD_USER_GROUP_TAB, AD_ATTRIBUTE_DEF_TAB and etc.However, it seems that the AD_GROUP_MAPPING_TAB table holds the information shown on your screenshot.Alternatively, is there any way to export and re-import the entire Configuration itself? This will make it very easy too.Our last option is to consolidate the 30 groups into 2-3 groups for TEST and re-add them manually following TEST clone. But hoping one of the above two options are available in IFS.Let's wait for some expert opinions for the above questionsCheers !Dhananjaya.

Srikanth · Answer

We are going with the workaround to create a full access AD Group for TEST instance but the above information is helpful. Thank you.

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded