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.

0 Comments   [ + ] Show Comments


Please log in to comment



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.

Answered 01/02/2013 by: dugullett
Red Belt

Please log in to comment

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.

Answered 01/02/2013 by: mwill_27
Blue Belt

Please log in to comment
This content is currently hidden from public view.

Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja