# suiteanalytics


03/28/2022, 10:00 PM
I 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?

KevinJ of Kansas

03/28/2022, 11:04 PM
can 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?


03/28/2022, 11:31 PM
It is going to be ran one a month. They want me to create a search and give a VP access to run it.


03/28/2022, 11:36 PM
It'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
You can adjust the pivot table to just show EE Center roles too, though some people likely have both.
I'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.


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

KevinJ of Kansas

03/29/2022, 1:40 AM
You can always do a summary saved search for this.
But 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.


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