Improvements to Active Directory data processing
It is now possible to extract:
- List of group(s) members
- List of groups the user(s) belongs to
We do recommend using a filter during design to reduce the pressure on the server
When no user name/password are provided the current user is used
Run the following SQL against the repository to enable Active Directory Connection
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('312','Active Directories')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('313','Active Directory')
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-6 as OBJECT_ID,
PARENT_ID,
'Active Directory' as NAME,
312 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_ID=16