Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Can i add User to 'User group' from 'specific entitlement onwer' using Saviynt4Saviynt?

MJ
New Contributor III
New Contributor III

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>

 

 

 

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

 

Use Saviynt REST Connector. DB Connector for Saviynt is deprecated 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

MJ
New Contributor III
New Contributor III

i used DB connector at this time.

thanks!

Manu269
All-Star
All-Star

Actionable analytics can also help

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.