Background Script

[kusumgautam]

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

[Dr Atul G- LNG]

HI @kusumgautam 

(function() {
// Check if the current user's location is empty
var userLocation = gs.getUser().getLocation();

if (!userLocation) {
gs.info('User location is empty');
// Perform actions here if the location is empty
} else {
gs.info('User location is available');
// Perform other actions if the location is available
}
})();

or

[cpawan]

var gr = new GlideRecord('sys_user');
gr.addEncodedQuery('locationISEMPTY()');

gr.query();
while (gr.next())

{
gs.print(gr.user_name);

}

[Danish Bhairag2]

Hi @kusumgautam ,

To create a background script in ServiceNow that retrieves a list of users with empty locations, you can use GlideRecord queries. Here's a simple example:

```javascript

// Create a new GlideRecord for the 'sys_user' table (User table)

var userGR = new GlideRecord('sys_user');

// Add a query to find users with empty 'location' field

userGR.addQuery('location', ''); // Assuming 'location' is the field you want to check

// Execute the query

userGR.query();

// Iterate through the results

while (userGR.next()) {

    // Output user details or perform any desired actions

    gs.info('User without location: ' + userGR.getValue('name'));

}

```

Make sure to replace `'location'` with the actual field name you want to check for emptiness. You can customize the output or actions inside the loop based on your specific requirements.

Remember to test your script in a safe environment before running it in production to ensure it behaves as expected and doesn't unintentionally modify records.

Thanks,

Danish

[Ankur Bawiskar]

@kusumgautam 

you can easily do this by applying filter condition and export it as excel and you need not use any script

If my response helped please mark it correct and close the thread so that it benefits future readers.