How to trigger event from business rule to remove deactivated users

[BanuMahalakshmi]

Hi,

I have requirement to create business rule - remove deactivated users from  assigned_to field(list type) from the table cmdb_Ci.

I want to trigger event passing CI(configuration item name) and deactivated user value and the event should remove disabled user from the field assigned_to.  please advise me the script. 

Thanks.

[Max Nowak]

Assuming the trigger is when a user in the sys_user table is set to inactive?

Create a Business Rule on the sys_user table which triggers on AFTER, where the "Active" field changes to "False":

Configure the "Script" field in the Advanced tab with a simple query:

[BanuMahalakshmi]

Thanks for reply, My Assigned_to field type is list..it contains many users.  my client asked to - trigger event passing CI name, disabled user name. this event should remove deactivated user from assigned_to field

[Ankur Bawiskar]

@BanuMahalakshmi 

please avoid creating duplicate questions.

script to trigger Event to remove disable user