Reporting on User Assets

[vcaracci75]

I am trying to create a report form the sys_user table that shows the users name Department, and what assets are assigned to them. I was able to pull first name, last name, and department. The assets are in a related list though. How do I add that to the report? (see below)

[Cody Smith _ Cl · Accepted solution]

Assets are stored on the `alm_asset` table and not the user table.

In the report use the "Related Lists Conditions" "Asset --> Assigned to" and the user you are looking for.