I need to provide a list of users consuming NS ful...
# suiteanalyticsm
mescalante
03/28/2022, 10:00 PMI need to provide a list of users consuming NS full licenses and exclude those that have "Employee Center" only.
I have an Active Users search, but I am struggling to come up with a single Saved Search that will give us that list.
• Any Ideas?
k
KevinJ of Kansas
03/28/2022, 11:04 PMcan you just download your user list from the "manage users" page - and then do the rest of it in excel? or is this a recurring need?
m
mescalante
03/28/2022, 11:31 PMIt is going to be ran one a month.
They want me to create a search and give a VP access to run it.
r
RJMNS
03/28/2022, 11:36 PMIt's not all that efficient, but what I do when I have to do it periodically:
1. Go to employee list and set View=All
2. Sort Descending by Login Access column so all Yes'es are on top
3. Dump out into Excel and delete any lines where Login Access=No
4. Go to Setup>Users/Roles>Manage Users & download
a. This is a list of all users+all roles they might have
5. Join together with #3 using Xlookup on email address
6. Remove any N/As since those would be people in the Manage Users list who do not have login access
7. Pivot table to show EE list+roles
RJMNS
03/28/2022, 11:37 PMYou can adjust the pivot table to just show EE Center roles too, though some people likely have both.
RJMNS
03/28/2022, 11:38 PMI've also not always been successful in getting it to match exactly. I'm usually off by one or two. I think it has something to do with service users that are Web Services only or something not counting. It's always been close enough for government work though.
a
AI1
03/28/2022, 11:58 PM@mescalante I made a few simple workflows that help with this. I can now store license type (employee vs full) and last successful login date on the employee record. Then you can do an employee search to show usage per license type or stale users or license count per license type
It works really well and has helped a lot
k
KevinJ of Kansas
03/29/2022, 1:40 AMYou can always do a summary saved search for this.
KevinJ of Kansas
03/29/2022, 1:41 AMBut for once a month - I'm just doing 2 searches, pivoting the data, and then being done with it instead of learning how to do a summary saved search, or spending consulting hours.
g
GeneralKenobi
03/29/2022, 6:45 PM@mescalante I have used in the past from Chidi's page and it may be what you are looking for
GeneralKenobi
03/29/2022, 6:45 PM2 Views