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...