Background Script

[kusumgautam]

How to write background script that will give you list of user whose location is empty.

[Harish Bainsla]

Hi write this code

var userQuery = new GlideRecord('sys_user');

userQuery.addNullQuery('location');

userQuery.query();

while (userQuery.next()) {

    gs.print('User Name: ' + userQuery.getValue('name') + ', Sys ID: ' + userQuery.getValue('sys_id'));

}

[Community Alums]

Hi,

You can refer this below script 

var userGr = new GlideRecord('sys_user');

userGr.addEncodedQuery('locationISEMPTY');

userGr.query();

while(userGr.next()){

    gs.print('Name = ' + userGr.name);

}

Thanks 

Sarthak

[AniketC85155510 · Accepted solution]

Hello @kusumgautam 

Please find the below background script to get the list of users whose location is empty.

var userGr = new GlideRecord('sys_user');
userGr.addQuery('location', '');
userGr.query();
var totalCount = 0;
while (userGr.next()) {
    gs.print('User with empty location: ' + userGr.getValue('name'));
    totalCount ++;
}

    gs.print('Total Count of users with empty location: ' + totalCount);

Please mark my answer helpful and correct if I have answered your question.

Thanks & Regards,
Aniket.

[Community Alums]

@kusumgautam 

You can use below script:

var usr = new GlideRecord("sys_user");

usr.addEncodedQuery("active=true^locationISEMPTY");

usr.query();

while(usr.next()){

gs.info("Users with empty locations: " + usr.name);

}

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Kavita Bhojane

[kusumgautam]

I got The solution than you for the help.