Automate removing a user from User Groups

[Claudio_Origin]

Hello, can we automate somehow the removal of a user (say a Terminated user) from a User Group.

If we use an actionable report, which Allowed Action would remove an inactive user from a user group?

Can we use a User Update Rule that we can trigger on termination? What action is available to do this once the condition is met? This SQL will pick up inactive users still joined to User Groups.

select
ug.user_groupname as 'UserGroup_Name',
u.username as 'Inactive_username',
u.firstname, u.lastname, 
u.enddate as 'Termination_Date'
from user_groups ug
   INNER JOIN usergroup_users ugu on ugu.user_groupkey = ug.usergroupkey
   INNER JOIN users u on ugu.userkey = u.userkey
   WHERE
  u.statuskey = 0 ;

[rushikeshvartak]

Use User update Rule 

[Claudio_Origin]

Thank you Rushikesh, but which action will remove the user from the UG? The Deprovision Access? or Transfer Ownership (don't think so).

[rushikeshvartak · Accepted solution]

Transfer will replace & de provision will remove if you have specified query/ api to remove user from group in connection