Select inactive users with last login of 20 days and 35 days

[Adeshola]

I have a requirement to select inactive whose last login was 25 days ago and 35 days ago. I have used the script below to meet try this requirement but it returns for someone whose last login is 20 days ago and when I changed the days to either 25 or 35 days it returns no value: 

var gr = new GlideRecord('sys_user');

gr.addEncodedQuery('last_login!=NULL^active=true^locked_out=false^last_loginONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()');

gr.query();

while(gr.next()) {

    gs.print('Inactive User: ' + gr.name);

}

when I use the relative option such as 

last_login!=NULL^active=true^locked_out=true^last_loginRELATIVEGT@dayofweek@ago@25 it returns nothing.

Thank you

Sola

[Uncle Rob · Accepted solution]

Have you manually checked to see if there are records that satisfy that condition?

[Juhi Poddar · Accepted solution]

Hello @Adeshola 

Here is the updated script:

var gr = new GlideRecord('sys_user');
gr.addEncodedQuery('last_login!=NULL^active=true^last_loginRELATIVELT@dayofweek@ago@251^locked_out=false^user_nameNOT LIKEadmin');//for 30 days just replace 25 to 30
gr.query();

while(gr.next()) {
    gs.print('Inactive User: ' + gr.name);
}

This works smoothly in my PDI. Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

Thank You
Juhi Poddar