KACE Custom Report: Assets Per User
I am trying to create a report for assets per user. This would include manually created assets, like monitors and phones, not just the machines in computer inventory. I have tried several reports that should report this data, but can never get it to group by the user that has been assigned to it. When I try and write my own SQL Report, it just returns machines that are assigned to every user.
Answers (2)
Can you include the reports you are currently trying to use? It will give us something to work off of since the asset table will be unique to your Kbox.
The reporting built in the K1000 appliance will allow you to report based on a certain Asset. From there, you will be able to see what user is assianged to what Asset by using the reporting Wizard. To produce a User report that shows all the Assets assigned, you will need to use a Join function in a customized mySQL report. From there, you can join the different asset tables created based on user.ID.
