Status threshold on the Account enddate basis

[shubhamj596]

Hi Everyone,

We have a usecase where we need to inactive only those accounts which have validthrough < Present date. and then after that we have to check cusomproperty .

If its just on a customproperty, it is doable. 

But any idea how this can be done by adding 2 conditions:

1. Check validthrough if it has already passed the present date

2. Check for the customproperty ie if true then active or else inactive.

Regards,

Shubham

[rushikeshvartak]

Account Status change through is based on only one customproperty unfortunately you can't write logic. 

What type of connector are you using? 

[shubhamj596]

Hi Rushikesh,

I think what we can do it to use customquery to update the account custom property according to the logic and then leaverage status threshold.

We are using SAP Connector.

Regards,

Shubham

[rushikeshvartak]

Yes Custom Query is last option if nothing worked . However saviynt does not suggest to use it considering db deadlock etc

[kishorekumarmb]

Hi Shubham,

    You can as well use SavForSav and use Account import json to pick the respective accounts and do the logic and update the status of the accounts present in that endpoint. And use Triggerchain job to sequence that entire jobs.

Kishore

[shubhamj596]

Hi Kishore,

As it is on the account level, if we perform the account import using Sav4sav, the accounts will then be imported under sav4sav endpoint and with that it would not work out the way we are thinking.

Please correct me if i am wrong.

Regards,

Shubham

[avinashchhetri]

@shubhamj596,

In IGA system you are using the logic as you have described to validate the active vs inactive account. How does the application itself validate the same ? When someone is accessing, does it make use of the exact process you have outlined to grant them access or not ?

Though it is not a prescribed solution but as a workaround, you can use the Sav4Sav Connection and make use of an xml file to process your logic to make the updates. Please check the DB connector documentation link shared beow.

https://saviynt.freshdesk.com/support/solutions/articles/43000617705-database-connector-guide

https://saviynt.freshdesk.com/support/solutions/articles/43000666866-db-import-account-import-xml-fi...

[shubhamj596]

Hi Avinash,

I am not able to access the page, It says 'You are not allowed to access this page! '

Do you have any other link for xml upload using DB by anychance?

Regards,

Shubham

[avinashchhetri]

Hello Shubham,

Older versions required placing the file with Saviynt Support's help but in v2021, you should be able to do it from the UI and using API's. here's the sceenshot from that document.