Anyone know how to report on users with multiple assets?

Kim Sullivan · ‎02-07-2018

I know I can do a list view and then Group by user, but I don't then know how to filter out all the users with only (1) asset. Help.

raycallan · ‎06-07-2019

Hi Kim,

Just found this thread as I was looking for the similar solution whereby I wanted to find users assigned multiple computers and I have managed to create a report use Related lists

To get it to work your source table isUsers [sys-user] and under related list conditions select Asset -> Assigned to and change the Greater than or Equal to to 2

Hope this helps

Ray

View solution in original post

Community Alums · ‎08-03-2020

This was exactly what I needed, only related list was Computer>Assigned to for my report. THANK YOU, raycallan!

Kim Sullivan · ‎10-30-2019

Don't suppose you know how to get those assets also to show on this report?

o_mcclain · ‎10-30-2019

I have the same question 🙂

Shannon Walsh · ‎01-23-2020

Ditto. I have the same question.

Rohit8 · ‎03-04-2021

Bump. Same requirement here, did anyone find a solution? 😞