Bulk Custom Property Import for Existing Accounts

[sab2]

Hi Everyone,

We have a use case where we need to set customproperty16 to be the specific application name for every account in Saviynt. We are just trying to decide what is the best approaching to do this for existing accounts in the Saviynt system? As there are many accounts and many different applications.

We cannot add it into the AD json because of the endpoint filer, there are multiple different application names. 

Our thoughts are, we can do an export of all accounts and add CP16 and then re-import.

Or we can do sav4sav to set the CP16 for the existing accounts. 

Our last thought was trying to run a custom query to set the CP16.

Does anyone have suggestion on the best approach? Or other options? 

Thank you!

[AmitM]

Hi @sab2 ,

If it is one time activity my preference would be to use custom query.

If it is on-going thing , first preference sav4sav and second custom query and run custom query only where this CP null.

Thanks,

Amit

If helped, please ACCEPT SOLUTION.

[rushikeshvartak · Accepted solution]

use below enhanced query 

SELECT a.accountkey   AS accounts__primarykey,
       e.endpointname AS accounts__customproperty16
FROM   accounts a,
       endpoints e
WHERE  a.endpointkey = e.endpointkey
       AND a.status NOT IN ( 'SUSPENDED FROM IMPORT SERVICE' )
       AND a.customproperty16 != e.endpointname