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  you can achieve this by creating a database view in ServiceNow.  Added a link of Similar questions for reference

Regards,

RJ

[karan15]

thanks , but am finding it bit tough to ascertain what "Where" clause shd be 

[Sumanth16]

Hi, 

Can you refer below post:

https://www.servicenow.com/community/platform-analytics-forum/database-view-joining-and-filtering-da...

Thanks & Regards,

Sumanth Meda.

[karan15]

i have created following database view but it seems its not working 😞 can someone help