Hi @Sarah Bouil ,
You can achieve this by using Flow Designer.
I am sharing the step by step process as below:
In the filter navigator, search 'Flow Designer' open it.
Click on 'new' and select 'flow'
Provide a Flow name and description, click on build flow.
In the Trigger, select as below:
It will run daily at 6 to check for users
In the action, select as below: Last login relative before 6 months ago and active is true for user record.
Now, In Flow Logic > For each
Now, we are going through each record in sys_user_grmember for each user found in above record.
Looping through each record and in next step we will delete/remove them.
removing the group and it will eventually remove inherited roles.
Finally, we are going to send the notification to the user who has been removed.
Create an event in the [sysevent_register] table with name 'inactivity.alert'
Now, setup a notification which will trigger by the above event and in who will receive, select parm1 as that will have the email of the recipient.
Result for reference of the above setup:
Mark this as Helpful / Accept the Solution if this helps
