show the list of email address of all the user

[Anjali yadav1]

var grUser=new GlideRecord('sys_user');

grUser.query();

while(grUser.next())

{

gs.print(grUser.email);

}

i run it in background script of PDI but on running i got not authorized as output pls help me to corrected error

[Bhavya11]

Hi @Anjali yadav1 

you script is correct only.

not authorised - its due the session issue so please re-login or reload the page and execute the script it will work

to make more accurate add few query in your script like below

var grUser=new GlideRecord('sys_user');
grUser.addActiveQuery();
grUser.query();

while(grUser.next())
{
gs.print(grUser.email);
}

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks,

BK

[Harish Bainsla]

Hi @Anjali yadav1  check below code

var grUser = new GlideRecord('sys_user');

grUser.query();

while (grUser.next()) {

gs.print(grUser.email);

}

[Kieran Anson]

Additionally, use getValue rather than passing grUser.email which is GlideElement. You'll run into pass-by-reference issues if you use this logic to push glide record values to an array or other data type.

Avoiding Pass-By-Reference Using getValue() & setValue() - ServiceNow Developer Pro-Tips (snprotips....

var grUser = new GlideRecord('sys_user');
grUser.query();

while (grUser.next()) {
    gs.print(grUser.getValue('email'));
    }

[Amit Pandey]

Hi @Anjali yadav1 

Your script is correct! I ran the same in BS and got the results. See screenshot-

Regards,

Amit