We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Need to trigger Update Account and Deprovision Access from Analytics

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on November 30 2020 at 13:13 UTC

Hi,


I have configured two separate query to trigger Update Account Task and Deprovision Access for Users in Analytics.


Is there any way where I can create a single query to trigger Update Account and Deprovision Access using a single Analytics?


Thanks,

Rituparna Das

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
7 REPLIES 7

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 09:16 UTC

Hi Rituparna,


Can you share your use case? Do you want to take the Update Account and Deprovision access action on the same records or you just want them to be part of the same query?

Please provide more details.



Regards,

Saparja

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 09:19 UTC

HI Saparja,


I want to trigger from one single analytics query Update Account and Deprovision Access for the results the query returns.


Thanks and Regards,

Rituparna Das

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 09:26 UTC

Hi Rituparna,


You can configure both these actions in the allowed actions. Make sure to keep all the mandatory columns required for both Update Account and Deprovision Access in the analytics query.


However, at a time you will able to take only one action on a particular record.



Regards,

Saparja

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 11:47 UTC

Hi Saparja,


we are using this query , can you please help how can I specify both action together.


select accountDetails.*, 'Update Account' AS Default_Action_For_Analytics ,u.USERNAME, current_timestamp() from users u inner join (select ac.ACCOUNTKEY as acctKey,ua.USERKEY as userKey,ac.NAME ,ac.ENDPOINTKEY, (select ENDPOINTNAME from endpoints where ENDPOINTKEY=ac.ENDPOINTKEY)'endpointname' from user_accounts ua inner join accounts ac on ua.ACCOUNTKEY=ac.ACCOUNTKEY)accountDetails on u.USERKEY=accountDetails.userKey where u.CUSTOMPROPERTY3=0 and (u.CUSTOMPROPERTY16='TRUE' or u.CUSTOMPROPERTY16=1) and accountDetails.endpointname like 'AD_NB_SecuritySystem%' AND DATEDIFF(u.termdate, NOW()) = -8

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 11:48 UTC

HI Saparja,


In Pending Tasks I need Update Account and Remove Access Task for a single user at the same time

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 18 2020 at 11:50 UTC

Hi Rituparna,


As mentioned earlier, at a time you will able to take only one action on a particular record.



Regards,

Saparja

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on December 19 2020 at 02:35 UTC

Hi Rituparna ,

To achieve your use case, you must create 2 similar reports, one for triggering Update Account, the other one for Remove Access as both actions cannot be triggered on a same line result in one Analytic (as Saparja mentionned).

Also as "Remove Access" has a higher risk than "Update Account" task, it is preferable to split these actions in case you would need only Update Account on one line and you want to prevent end users from missclicking.

Regards,

Adrien.

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.