What do you do when an user leaves the company?

kellyobrien
Tera Contributor

I am working on a plan to get notifications when a user leaves the company. We have multiple areas (CI owners/assigned to, CI class owners, assignment group mangers, queue owners, queue managers, Asset group owners/assigned to... I think you get the point) where we run into issues when someone leaves the company and has many different pieces assigned to them. We have groups that are still owned and managed by users that left the company more than 6 months ago.

So, my question is... What do you do when a user leaves to ensure that all of the points they are included in are reassigned?  

5 REPLIES 5

Maks
Tera Guru

If you have an import set-up that loads users into ServiceNow, then you can enable/disable the Active flag from SQL:

case when person_leaving_date >= convert(date,getdate()) then 0 else 1 end as 'Active'