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 

[Rahul RJ]

@karan15  Can you share the view that you have created

for reference you check link

Regards,

RJ

[karan15]

this is the view thanks 

[IAmAbhigyaan12]

@karan15 : You can just keep where clause on alm_asset table where asset assigned to user id. Remove the where condition from sys_user.

[ricker]

@karan15,

Why not run your report on the alm_asset table?

[karan15]

thanks , but will it show user name and assets he owns next to him ? (in this case I want asset IDs of Mobile phones assigned to him/her)