Schedule Job for Inactive Users

[Pooja Khatri]

Hello All ,

I have a requirement where I need to write a schedule job which will fetch up all the records which are deactivated in the last 7 days , means active = false . 

[Voona Rohila · Accepted solution]

Hi @Pooja Khatri 

Try this.

var grSysUser = new GlideRecord('sys_user');
grSysUser.addEncodedQuery("active=false^sys_updated_onRELATIVEGT@dayofweek@ago@7");
grSysUser.query();
while (grSysUser.next()) {
//do something.
}

You can use Updated On field or Last Login field accordingly.

[Saurav11]

Hello,

The normal script would be as below:-

var gr=new GlideRecord('sys_user');
gr.addEncodedQuery('active=false^sys_updated_onRELATIVEGT@dayofweek@ago@7');
gr,query();
while(gr.next);
{
var arr=gr.user_name;
}

Now this is actually tricky because the last updated date does not guarantee the date on which it was made inactive. Do you have the audit enabled on User table if yes then it would be easier to get the exact time when the field was made inactive.

Or you can create a metric definition on sys_user table for active field whenever the field is made inactive the record would be captured in metric_definition and then you can get the list from metric_definition.

Please mark my answer as correct based on Impact.

[Saurav11]

Hello,

If my answer helped you can you also mark it as correct.

Thanks.