User account expired

[tmschiller]

We have users in a DEV environment testing for an EIC migration. We have a number of user accounts that cannot log into the system because their accounts are expired. Before EIC, we could run a CustomQuery job to update the ACCOUNTEXPIRED field in the USERS table, but it doesn't seem we are allowed to do that anymore. I've tried updating the user manually via CSV, but even though it says the user was updated, I can still see in the database the account is still expired. How can we now set this flag so these users can log in? 

[prasannta]

Hi @tmschiller 

You can try invoking the updateUser API from postman to update the accountExpired attribute. 

Thanks

[tmschiller]

Are you kidding me? I have to use another application to set a value in Saviynt?

[pruthvi_t]

@tmschiller ,

You can make use of enhanced query execution job, which does same thing that a custom query job would do but the querying approach is different.

Please refer to below link and search for 'Enhanced query Execution job' and find more details on how to build a query to update a value and few samples for it too.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

Thanks,

[tmschiller]

I already looked into that, but you you can't use the "'Enhanced query Execution job" to change records on the Users table.

[tmschiller]

Any other options/solutions?

[prasannta]

Hi @tmschiller 

Alternate apart from using API to set AccountExpired attribute would be to add a dynamic field on the user create/update form. See below configuration to configure updating the accountexpired attribute from UI.

Thanks