and more in a single search tool across platforms. Read the announcement here. |
02/27/2024 07:05 AM
When we have a user leave we are removing the owner and when we import via a userimport from database job.
When we do that owner is set to NULL, but Manager remains populated with the owner data.
Although when I upload a user setting the owner to NULL, the manager is removed. when I do the upload I'm not checking any rules and it still works.
What do I need to set to get Manager removed when Owner is NULL on a userimport?
02/27/2024 07:20 AM
Hi @MichaelWoodruff , it should work with user imports as well. We have also mapped owner field with manager form source and it has been working. No specific config for this.
But for some reason it is not working in the environment which you need to go through the logs to find out but for now if need a workaround, you can use inline preprocessor :
"UPDATE NEWUSERDATA SET manager= null where owner is null"
Thanks,
Amit
If this answers your query, Please ACCEPT SOLUTION and give KUDOS.
02/27/2024 08:13 PM
Please share database xml
02/27/2024 08:27 PM
I removed most of the columns we import but here's the jist of it...
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[
SELECT idadb.wupeople_manager_wupeople_entity_id as IDADBmanager,
FROM ida_registry.dbo.idv_saviynt_composite_data_load AS idadb where idadb.wupeople_entity_id is not null ]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>true</zeroDayProvisioning>
<zeroDayLimit>150000 </zeroDayLimit>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>true</checkRules>
<generateEmail>false</generateEmail>
<buildUserMap>false</buildUserMap>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_ENDUSER" dateformat="date" incrementalcolumn="calc_last_change_date">
<mapfield saviyntproperty="owner" sourceproperty="IDADBmanager" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
02/27/2024 08:32 PM
Share result of query where owner is blank
02/28/2024 08:22 PM
Need output for
SELECT idadb.wupeople_manager_wupeople_entity_id as IDADBmanager,
FROM ida_registry.dbo.idv_saviynt_composite_data_load AS idadb where idadb.wupeople_entity_id is not null
02/28/2024 06:33 AM
I run this query in data analyzer I get the below results.
select username, owner, manager from users where username in (
1353700735,
1353674245,
1353725167,
1353733982,
1353703935
)
02/29/2024 06:43 AM
Ah...this is the select directly in our database.
02/29/2024 10:14 PM - edited 02/29/2024 10:14 PM
SELECT case when idadb.wupeople_manager_wupeople_entity_id= 'NULL' then '' else dadb.wupeople_manager_wupeople_entity_id end as IDADBmanager,
FROM ida_registry.dbo.idv_saviynt_composite_data_load AS idadb where idadb.wupeople_entity_id is not null