Chapter 6 – Group management – in the FIM 2010 R2 book
In this chapter we will look at:
- Different group scope and types in AD and FIM
- How to manage groups using the Outlook add-in
- How to synchronize groups between HR, AD, and FIM
Identity Management and Information Security from Kent Nordström's point of view!
In this chapter we will look at:
Is there is way we can recover the deletion of group in FIM 2010.
In the Troubleshooting chapter I will try to make room for recovering objects that have been deleted from FIM Service DB
Hi Kent, Im working on MIM 2016 project for first time and sofar with help of your FIMhandbook I manage to get user provision /deprovision from SQL table into FIM PORTAL -> AD & Exchange
Now I need to import/sync groups and membership in combination of SQL tables into FIMPORTAL then into AD .
In SQL I have 2 table consist of group information , tables are structured as follows:
Table : Groups
[groupID] [varchar](21) NOT NULL,
[groupDescription] [varchar](254) NULL,
[groupManager] [varchar](254) NULL,
[type] [varchar](254) NULL,
[groupType] [varchar](254) NULL,
Table : Groups_Members
[employeeID] [varchar](254) NOT NULL,
[groupID] [varchar](21) NOT NULL
can you pls advice how to achieve this kind of scenario .
Thanks
Sorry about the late reply. Notifications had stopped working from my blog so i missed it.
What You need is simply to use the Groups_Members table as MultiValue table in your SQL MA. The Table/View requires three columns. In your case it would be [groupID],[attributeName],[attributeValue]. Your groupID goes into [groupID] “member” is the attribute name and employeeID is the value. BUT! in order to get this complete You also need your users in the same MA in order to get Reference values flowing. The best way is to have like [ObjectID], [ObjectType] columns to hold the ID and Type of each object. Download and look at the HR SQL example http://konab.com/wp-content/uploads/SampleSQLData.zip to see what i mean.