[subscription management] extract list of users not using a subscription allocated to them

[JérômeBERNARD]

Hello, 

Reaching out to the community as I can't find a solution internally. I have an over-allocation for AEE and ITSM. I'd like to audit which users have a subscription/license allocated to them but have not used it in quite some time. Is there a way to extract some sort of logs (not using last login)?

Thanks ! 

[AndersBGS]

Hi @JérômeBERNARD ,

 both yes and no from my point of view. Yes because you can look at last login on the user record. If a user hasn’t locked in for XX days, you can remove all roles. No because you doesn’t have anything else to look into. Eg. If a user has ITIL and app engine license, you can’t really track what the user has been utilizing.

[Brian Bouchard]

Someone else may have a better idea, but the best I can think of is that you could analyze Transaction Logs (System Logs => Transactions), but those are typically kept for less than 2 months, so you might need to run something monthly  to get what you're looking for and then save that info to another table, if you are looking for trends over several months.  There's lots of "noise" in those logs that you probably don't care about (including logins) to, so you would likely need to do a fair amount of data cleansing to get to something that's even remotely helpful, but even with that you likely won't get the whole picture.

For instance, a "regular" user can typically view incidents where they care the caller, but not other incidents, so without looking at every incident someone viewed to see if they were the caller or not, you can't really tell if them looking at the incident table requires them to have an ITSM fulfiller license.