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

raycallan · ‎10-30-2019

Hi o.mcclain,

Can you confirm that you have the 'Greater than or Equal to 2' selected. Can you send on a screenshot of your related list conditions similar to what I have above.

Regards

Ray

o_mcclain · ‎10-30-2019

Hey Ray, thanks for getting back to me. The report indeed lists users with multiple assets; however, I was hoping to see those assets and group by the Assigned to field. 😞 I wasn't clear, my apologies.

Karthick15 · ‎07-22-2020

Hi @raycallan @o.mcclain ,

Hope you are doing well!!.

i tried the same steps mentioned above but i am not getting user who have both assets.

raycallan · ‎07-22-2020

Hi Karthick, You look to have everything correct. I would troubleshoot by removing filters to see if you get any results. Start by removIng both the category filters and if that doesn’t work set the conditions greater and equal to 1 etc. I can’t see from the screenshot but is your base table the user table and you are using the assigned to field on the asset table Regards Ray

Karthick15 · ‎07-23-2020

Hi Ray,

Thanks for responding, i tried the same but i either get users who have laptop or chrombook but nor users who have both.

Do i need a JavaScript to retrieve users with such assets ?