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?

[No NaME]

Change your filter as required

[The SN Nerd · Accepted solution]

Please mark as correct if this has solved your problem.

I believe I have provided the correct response, just change the default "Greater than or equal to 1" to "Greater than or equal to 2".

Thanks 🙂

[rocily]

Thank you, Paul. This is great. 

With users who have more than one asset assigned to them. I would like to get the details of the assets assigned to them as well for eg.  " Serial number/asset tag" etc. 

I am unsure of how to do this.

Is there a way to link the CMDB tables and the user tables?

Any help is appreciated.

Thanks

[The SN Nerd]

When it comes to joining different tables together, you'll need to create a Database View, which can be a little tricky.