I think the report you want is already built-in. Check out this report: https://www.lansweeper.com/forum/yaf_postst15153_Assets--Asset-to-user-relations--Built-in.aspx
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.