Performance Analytics Report on "Assets assigned to Inactive Users"

[Ashish Purwar]

I want to create a report Report on "Assets assigned to Inactive Users" showing the percentage of maximum contributor location wise, but maximum percentage calculation should be based on total volume of assets in that specific location. So, if any location has large number of assets lets say 1000 and contributor is high may be 80 compared to other locations (8%), but if we take the percentage that may be less as compared to location which has 10 contributor and location has 100 total assets (10%)

Please assist.

[Ashish Purwar]

Any alternative approach rather than performance analytics would also be helpful. 

[Tanushree Maiti]

Please refer this links, see if it helps you:

https://www.servicenow.com/community/sam-forum/creating-inactive-users-report-who-are-consuming-soft....

https://www.servicenow.com/community/expert-services-forum/inactive-users-and-assets-assigned-to-the...

[Ashish Purwar]

Hi, This is not the giving the expected outcome. It displays the simple report of just assets assigned to inactive users. I need a percentage based on the parameter i mentioned. 

[lauri457]

You could do this in a few ways but here is with a formula indicator

1. Create an indicator source for alm_asset
2. Create two automated indicators, one with no condition called Total assets and one with condition assigned to is empty called Total unassigned assets. 
3. There should be an OOB location breakdown, create a breakdown mapping to alm_asset.location using that breakdown
4. Create a formula indicator '% of unassigned assets' or similar and use formula

[[Total unassigned assets]] / [[Total assets]] * 100​

• Your indicator is ready to use (granted you collect the data first)