Accounts not changing suspend after job run

[Raghu]

Hi Team,

We configured DB Account import xml, target system dont have data , once job run saviynt it should change suspend from import based on accountnotinfileaction =suspend and "inactivateAccountsNotInFile": false in accounts

xml:

<dataMapping>
<before-import ></before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name">
<![CDATA[
SELECT DISTINCT
'XXX' AS systemname,
'XXx' AS EndpointName,
pfu.UserName AS EmailId,
pfu.DeviceType as 'DeviceType',
pfu.DeviceEmail as 'DeviceEmail',
temp.AveksaEmployeetype as 'EmpType',
'1' AS Status,
pfu.PhoneNumber AS Mobilenumber
FROM XXX pfu
JOIN XXX temp ON pfu.UserName = temp.email
WHERE pfu.MFAStatus = 'ACTIVE'
AND pfu.DeviceType = 'EMAIL'
AND temp.AveksaEmployeetype = 'Employee'
AND pfu.UserCreationTime >= DATEADD(day, -2, GETDATE())
]]></sql-query>
<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="suspend" ifusernotexists="noaction" dateformat="date" systems="'XXX' ">
<mapfield type="character" sourceproperty="systemname" saviyntproperty="securitysystems.systemname" ></mapfield>
<mapfield type="character" sourceproperty="EndpointName" saviyntproperty="endpoints.endpointname" ></mapfield>
<mapfield type="character" sourceproperty="DeviceEmail" saviyntproperty="accounts.customproperty1" ></mapfield>
<mapfield type="character" sourceproperty="Mobilenumber" saviyntproperty="accounts.customproperty2" ></mapfield>
<mapfield type="character" sourceproperty="EmpType" saviyntproperty="accounts.customproperty3" ></mapfield>
<mapfield type="character" sourceproperty="DeviceType" saviyntproperty="accounts.customproperty4" ></mapfield>
<mapfield sourceproperty="EmailId" saviyntproperty="accounts.name" type="character"></mapfield>
<mapfield sourceproperty="Status" saviyntproperty="accounts.status" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL" ></after-import>
</dataMapping>

Help me on this..!

Note : i tried with capital also 'Suspend' but no luck.

[SumathiSomala]

@Raghu did you refer this?

https://forums.saviynt.com/t5/identity-governance/accountsimport-for-database-connector/m-p/58847

[NM]

Hi @Raghu , status field mapping should be number instead of character

And change form from '1' to this 1 as status

[Raghu]

@SumathiSomala  @NM 

Yes referd,  but no luck even changing the type number and number value status.

@NM  already we using type character it working other applications.

[NM]

@Raghu , do you see those users still coming in from target??

[rushikeshvartak]

<dataMapping>
<before-import ></before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name">
<![CDATA[
SELECT DISTINCT
'XXX' AS systemname,
'XXx' AS EndpointName,
pfu.UserName AS EmailId,
pfu.DeviceType as 'DeviceType',
pfu.DeviceEmail as 'DeviceEmail',
temp.AveksaEmployeetype as 'EmpType',
1 AS Status,
pfu.PhoneNumber AS Mobilenumber
FROM XXX pfu
JOIN XXX temp ON pfu.UserName = temp.email
WHERE pfu.MFAStatus = 'ACTIVE'
AND pfu.DeviceType = 'EMAIL'
AND temp.AveksaEmployeetype = 'Employee'
AND pfu.UserCreationTime >= DATEADD(day, -2, GETDATE())
]]></sql-query>
    <mapper description="Database Accounts and Account to Entitlement Import" accountnotinfileaction="suspend" deleteaccountentitlement="true" dateformat="date" systems="'Rushi_DB'">

<mapfield type="character" sourceproperty="systemname" saviyntproperty="securitysystems.systemname" ></mapfield>
<mapfield type="character" sourceproperty="EndpointName" saviyntproperty="endpoints.endpointname" ></mapfield>
<mapfield type="character" sourceproperty="DeviceEmail" saviyntproperty="accounts.customproperty1" ></mapfield>
<mapfield type="character" sourceproperty="Mobilenumber" saviyntproperty="accounts.customproperty2" ></mapfield>
<mapfield type="character" sourceproperty="EmpType" saviyntproperty="accounts.customproperty3" ></mapfield>
<mapfield type="character" sourceproperty="DeviceType" saviyntproperty="accounts.customproperty4" ></mapfield>
<mapfield sourceproperty="EmailId" saviyntproperty="accounts.name" type="character"></mapfield>
<mapfield sourceproperty="Status" saviyntproperty="accounts.status" type="number"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL" ></after-import>
</dataMapping>