Use case: Attribute sync - Active Directory ‘manager’ (account) attribute when supervisor (user) attribute value changes on HR source.
We collect the HR identity data from a DB source.
We have set-up an attribute sync on the ‘supervisor’ user attribute with a target account attribute mapped to the custom account attribute 'managerx' (STRING).
This is collected from AD = ‘manager’ so would be the manager's DN.
Upon a supervisor change, a request is generated with the ‘ID’ value of the manager as the change request item – hence does not ever verify.
Have added an SQL node in the workflow to lookup the DN of the manager to pass to AFX before the 'Calculate items to work on' and 'AFX Fulfillment Handler' nodes, hoping to use the AFXCUSTOM_xxx notation.
|SQL Select Node|
sup.CUS_ATTR_USER_CAS_1 as AFXCUSTOM_ACCOUNT_MANAGERX,
usr.CUS_ATTR_USER_CAS_1 as AFXCUSTOM_Usr_Dn
FROM T_MASTER_ENTERPRISE_USERS usr
JOIN T_AV_USER_ACCOUNT_MAPPINGS map
JOIN t_av_accounts acc
ON map.account_id=acc.id join T_MASTER_ENTERPRISE_USERS sup
AFX Mapping for the capability – Update account:
It is not updating as expected (taking the value for AFXCUSTOM_xxx).
or ever verifying (this is expected since the ID is in the change request item).
Has anyone successfully (easily) set this up?
Thanking you in advance