Would like to get a report on Locations with User Count
It will contain the above fields like: Location name, Street, City etc etc along with the number of User. For example: if there are 5 users in Wall Street Location. It will update the Number of Users fields as 5 for Wall Street location in the report
Hi,
you can create a Multilevel Pivot report on sys_user table like this:
As result you will obtain something like this:
Hope this will help you!
Hi,
you could simply use the Group By Location column in the sys_user.list, then add some location fields in the list:
Hope this can help you!
If I have answered your question, please mark my response as correct and/or helpful.
Thank you very much
Cheers
Alberto
My Report will show something like this as below:
oour main focus to get the get the no of users for particular location. The report which you've shared will not show the count separately like 5,2 etc as shown above. If I download the report, I need to do a lot of excel work to get the count. My question is: is it possible to get the count as readily available in ServiceNow where there will be a colomn named as count on the number of users which will show the no of users present?
Hi,
you can create a Multilevel Pivot report on sys_user table like this:
As result you will obtain something like this:
Hope this will help you!
