getting list of active users

[ServiceNow Use6]

Hi,

How to get the list of active users from user table? I did it, bit something is wrong. Kindly help.

Regards

Suman P.

[Mark Roethof · Accepted solution]

Hi there,

The "Lookup value field" is incorrect. You've set this to "active", and therefore only seeing "true" instead of Fullname, email or something.

The reference qualifier might be done a little bit simpler (haven't tested, though give it a try!):
active=true

Instead of also the javascript part.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[ServiceNow Use6]

Hi Mark,

One more question please, I am getting the list like this, but i want a proper userID, how to get rid of the SYSID in the list.

Regards

Suman P.

[Mark Roethof]

Those other records, those are UserID's? So it is working? I would lookup which record that sys_id concerns, and check if it concerns a data issue.

This does not look like an issue with your Lookup Select Box.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list