Can we create a report that lists users who have more than one asset assigned to them?

[rocily]

I am trying to create a report to look at all users who have more than one asset assigned to them. Currently, I am exporting a list of all active assets to excel and pivoting data to find out who has more two or more assets. Is there a way to do that in service now Reporting?

[The SN Nerd]

Report (new UI)

[Adam Stout]

I believe you would want to set this to greater than or equal to 2 instead of the default of 1.

[rocily]

Thanks for this. Are you aware of anything that can be pulled out from any of the CI tables?

[The SN Nerd]

You might be able to report on CI's where related Asset.Assigned to is not Empty, group by Assigned To