Combing sys_user and alm_asset table for reporting on users with multiple assets

[karan15]

Need help in combining sys_user and alm_asset table for reporting 

I have managed to create report on sys_user table which shows which user has multiple assets (mobile phones) under their name coz as per our company policy only one mobile phone can be issued per employee (check screen shot)

But now I want to combine these two tables so that I can show asset tag of these multiple mobile phones against user name OR if there is any other way to asset details like asset tag against user name and with condition that this user owns more than 1 asset

Thanks in advance 

[ricker]

@karan15,

As long as you have that data on the table.  You can easily do it in a list view too.  Adjust your columns and group by assigned_to.

 

[karan15]

issue that am not able to run the report it keep showing its loading columns etc like this in screen shot and no results