question User Deactivate from user table after 90 days in Developer forum

User Deactivate from user table after 90 days

Hari Babu — Wed, 27 Mar 2019 08:56:33 GMT

Hi Team ,

when user is not using service now Account after 90 Days , the account will be deactivate from service now and also trigger the notification .

so,i was stuck in Scheduled jobs user is deactivate form user table but notification is not trigger .please look in below script .

1.Written Notification

2.Event Registry

var user = new GlideRecord('sys_user');

user.addEncodedQuery("active=true^last_login<=javascript:gs.beginningOfLast90Days()");

//user.addEncodedQuery("active!=false^name=user, test");
user.query();
while(user.next())
{
gs.eventQueue("logout_user_90days",user,user.email);

user.active = 'false';
user.locked_out = 'true';
user.update();

}

Re: User Deactivate from user table after 90 days

vintotz — Wed, 27 Mar 2019 09:03:16 GMT

in your email notification , at Who will receive section verify if Event parm 1 contains recipient is checked

Re: User Deactivate from user table after 90 days

Hari Babu — Wed, 27 Mar 2019 09:15:22 GMT

I have checked that check box before .

Re: User Deactivate from user table after 90 days

reginabautista — Wed, 27 Mar 2019 09:22:08 GMT

Try changing the parameter to below gs.eventQueue("logout_user_90days",user,user.sys_id);

Re: User Deactivate from user table after 90 days

Viraj Hudlikar — Wed, 27 Mar 2019 09:33:43 GMT

Hi Hari,

It might be happening that user is deactivated first and as event is in queue so its getting triggered late and at that time it will be having Active= false account, so email is not triggered and as per OOB feature recipients are excluded if active feature is disabled.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks & Regards,
Viraj Hudlikar.

Re: User Deactivate from user table after 90 days

Hari Babu — Wed, 27 Mar 2019 09:35:14 GMT

Hi ,

I copied and paste you line and run scheduled job user is deactivated from user table but mail is not trigger.

Re: User Deactivate from user table after 90 days

reginabautista — Wed, 27 Mar 2019 09:44:23 GMT

There's three things you need to check: 1. Does the user has email address? 2. Is the event tied to the notification? 3. Are there other conditions set I nthe notification?

Re: User Deactivate from user table after 90 days

vintotz — Wed, 27 Mar 2019 09:49:37 GMT

Hi Babu, it seems that @vhudlikar answers below is correct. inactive/lockout users will not be able to received email notification.

you may refer to this link https://community.servicenow.com/community?id=community_question&sys_id=30bb0ba1db9cdbc01dcaf3231f96192b

https://hi.service-now.com/kb_view.do?sysparm_article=KB0528661

Re: User Deactivate from user table after 90 days

Hari Babu — Wed, 27 Mar 2019 09:52:09 GMT

Yes He has email address ,and i tied with Notification

3. Are there other conditions set In the notification?== No

See here i don't select any user . but those who are do not using more than 90 days they can only deactivate from user table .

1. is Event Registry

2.is Email Notification

Re: User Deactivate from user table after 90 days

asifnoor — Wed, 27 Mar 2019 09:56:05 GMT

Hi Haribabu,

If the user is inactive or locked out, they will NOT receive notifications.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0528661

So you can trigger an notification first and then deactive a user. You can do this by first triggeing a event which will fire the notification. In the notification fire another event. Write a script action which will listen to this event and then lock the user in this script action.

Mark the comment as a correct answer and helpful if it answers your question.

Re: User Deactivate from user table after 90 days

asifnoor — Wed, 27 Mar 2019 12:08:14 GMT

Hi Haribabu,

Did you get the notification triggered for inactive user?

Re: User Deactivate from user table after 90 days

Hari Babu — Wed, 27 Mar 2019 13:50:37 GMT

No Not yet .

Can you help on that .

Re: User Deactivate from user table after 90 days

asifnoor — Wed, 27 Mar 2019 13:57:48 GMT

I have asked since you have marked this question already as accepted answer.

Check my earlier comment where i have given the suggestion and why the notification might not be coming.

Mark the comment as helpful and correct answer if it answers your question.