query to count number of users

Shalika · ‎05-23-2022

Query to find the number of users in sys_user table

Ankur Bawiskar · ‎05-23-2022

Hi,

something like this

var rec = new GlideRecord('sys_user');
rec.query();
var totalUsers = rec.getRowCount();

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Jaspal Singh · ‎05-23-2022

Script by Ankur should help but why do you need this? Can't it be checked in User table directly?

Musab Rasheed · ‎05-23-2022

Seems to be a duplicate question, have provided solution here, did you get chance to see this.?

https://community.servicenow.com/community?id=community_question&sys_id=6f27e4c7db27c110770be6be13961988

Please hit like and mark my response as correct if that helps
Regards,
Musab