Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Update account attribute to user attribute in EIC

Lakhitha
New Contributor II
New Contributor II

Hi Team,

We have requirement to show AD account last login attribute in User manager cert employment verification stage. Since we cannot display account attribute in employment verification stage, we are thinking to update account last login value to one of the user attribute and we can include that attribute in the Cert.

In EIC, we cannot use custom query job to update the user attribute and enhanced query doesn't allow us to update user table.

Can you please let us know is there any other way to update the values from account attribute to user attribute?

 

Thanks & Regards,

Lakhitha

7 REPLIES 7

rushikeshvartak
All-Star
All-Star

You can add same in certification

rushikeshvartak_0-1713243232107.png

 


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

NM
Regular Contributor III
Regular Contributor III

Hi @rushikeshvartak, Account last login date is one of their user custom property name right?

Hi Rushikesh,

We are not using Access Approval stage as we are not using this campaign for access reviewing, it's just a contractor user manager certificate and it has employment verification stage.

Thanks & Regards,

Lakhitha

In case you want to manage the data on user CP,Create SAV for SAV REST Connection and query accounts table to update on user table.

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

Lakhitha
New Contributor II
New Contributor II

Hi Manu/Rushikesh,

Thanks for your response, I'll try that approach.

Thanks & Regards,

Lakhitha

Refer a sample below :

<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[
select u.username as username,a.customproperty19 as UsageLocation from accounts a
JOIN endpoints ep on a.endpointkey=ep.endpointkey
JOIN user_accounts ua on a.accountkey=ua.accountkey
JOIN users u on u.userkey=ua.userkey
where ep.endpointname in ('ABC','DEF') and a.status IN ('1','ACTIVE','MANUALLY PROVISIONED')
and u.statuskey in (1) and u.customproperty22 is null
]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<generateEmail>false</generateEmail>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>true</checkRules>
<buildUserMap>false</buildUserMap>
<generateSystemUsername>false</generateSystemUsername>
<userOperationsAllowed>UPDATE</userOperationsAllowed>
<userReconcillationField>username</userReconcillationField>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="" dateformat="date">
<mapfield saviyntproperty="username" sourceproperty="username" type="character"></mapfield>
<mapfield saviyntproperty="customproperty22" sourceproperty="UsageLocation" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>

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

In this case use Saviynt 4 Saviynt REST Connector to update users CP


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