i am trying to add user to 'user group' via saviynt 4 saviynt.
i can create entitlement from user group via sav4sav.
<?xml version="1.0" encoding="UTF-8"?>
<dataMapping>
<before-import/>
<sql-query description="This is the Source DB Query">
<![CDATA[
select
'IAC' AS securitysystem,
'IAC' AS endpoint,
'1' as status,
'CP0' AS dataowner1,
'UserGroup' as entitlementtype,
ug.user_groupname as entitlementvalue,
ug.USER_GROUPDESCRIPTION as description
from user_groups ug,
usergroup_users uu,
users u
where
ug.USERGROUPKEY = uu.USER_GROUPKEY
AND uu.userkey = u.userkey
AND ug.USER_GROUPNAME like '%iacc%'
]]></sql-query>
<mapper description="This is the mapping field for Saviynt Field name" createentitlementtype="true" deleteentitlementowner="false" systems="'IACCOUNTING_DB_RELAY'">
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystem" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"/>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlement_value" sourceproperty="entitlementvalue" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entowner1" sourceproperty="dataowner1" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlement_glossary" sourceproperty="description" type="character"/>
<mapfield saviyntproperty="entitlementvalues.description" sourceproperty="description" type="character"/>
<mapfield saviyntproperty="entitlementvalues.status" sourceproperty="status" type="number"/>
</mapper>
<after-import description="EMAIL,BATCH,SQL"/>
</dataMapping>
btw i can't add user to user of 'user group' via sav4sav.
is it possible? or should I use an actionable report for this?
<?xml version="1.0" encoding="UTF-8"?>
<dataMapping>
<before-import/>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="userkey">
<![CDATA[
SELECT ev.ENTITLEMENT_VALUE as 'Entitlement Name',
E.Endpointname AS 'Endpointname',
E.displayname,
et.entitlementname,
u.userkey as userkey,
'46' as 'Usergroupkey'
FROM
Entitlement_values ev,
ENDPOINTS E,
entitlement_types et,
users u,
'cp006133' as 'updateuser'
entitlement_owners eo
WHERE
e.endpointkey = et.endpointkey
and et.entitlementtypekey = ev.entitlementtypekey
and eo.entitlement_valuekey = ev.entitlement_valuekey
and eo.userkey = u.userkey
and e.endpointname in ('IAC')
and et.entitlementname = 'UserGroup'
AND ev.entitlement_value = 'iAc_Approver'
]]></sql-query>
<mapper description="Ent owner import" dateformat="date">
<mapfield saviyntproperty="usergroup_users.user_groupkey" sourceproperty="Usergroupkey" type="character"/>
<mapfield saviyntproperty="usergroup_users.userkey" sourceproperty="userkey" type="character"/>
<mapfield saviyntproperty="usergroup_users.updateuser" sourceproperty="updateuser" type="character"/>
</mapper>
<after-import description="EMAIL,BATCH,SQL"/>
</dataMapping>
Rushikesh Vartak
