Hello,
is there a way I can extract the count of the assets assigned to a user?
One of our users is trying to trace the people who have more than one asset assigned to them, but we don't seem to reach the result.
From the table alm_asset I can set a condition on Assigned to is not empty but I would need to exclude those users who have only 1 asset.
The field Quantity on the asset table is not being filled, so I don't think it has anything to do with the Assigned to.
Do you think we need to build a db view in order to join these information? Is it even possible to join them?
Thank you so much,
Donatella
