I am trying to implement a scheduled job to deactivate users (active false) whose logged in time is 60 days before and revoke all the roles and groups.

[Divya44]

I tried below script in Scheduled job to make active false for the users and revoke roles and groups.Its removing roles and groups  but the active field is still true. I want  active field to set to false based on the condition.

Kindly Share your views.

var license = new GlideRecord("sys_user");
license.addQuery("last_login_time<=javascript:gs.beginningOfLast60Days()^active=true^u_user_type!=1");
license.orderByDesc('last_login_time');
license.setLimit(5);
license.query();
license.active ='false';
license.update();
while(license.next()){
gs.log("users list first five id's" +license.user_name);
var gr= new GlideRecord('sys_user_grmember');
gr.addQuery("user",license.sys_id);
gr.query();
if(gr.next()){
gr.deleteMultiple();
}
var gr1= new GlideRecord('sys_user_has_role');
gr1.addQuery("user="+license.sys_id+"^role!=7fcaa702933002009c8579b4f47ffbde^ORrole=NULL");
gr1.query();
if(gr1.next()){
gr1.deleteMultiple();
}
}

Thanks in advance

DM

[Ankur Bawiskar]

Hi,

As mentioned by Mark I would also recommended Flow.

For your job script; update as this

var license = new GlideRecord("sys_user");
license.addQuery("last_login_time<=javascript:gs.beginningOfLast60Days()^active=true^u_user_type!=1");
license.orderByDesc('last_login_time');
license.setLimit(5);
license.query();
while(license.next()){

	license.active = 'false';
	license.update();

	var gr = new GlideRecord('sys_user_grmember');
	gr.addQuery("user",license.sys_id);
	gr.deleteMultiple();	

	var gr1 = new GlideRecord('sys_user_has_role');
	gr1.addQuery("user=" + license.sys_id + "^role!=7fcaa702933002009c8579b4f47ffbde^ORrole=NULL");
	gr1.deleteMultiple();
}

Regards
Ankur