How can I find what assets are assigned to a user?
Ok my problem is that I want to take a single user or many users and find all of the assets that have been assigned to them. Say for example they had been assigned a desktop and a laptop. I can go in and find that computer 12 for example had been assigned to John Doe, and I can browse laptops and find that laptop 4 was assigned to John Doe, but how can I just say I want everything assigned to John Doe? Could I go even a step further and find any assets that they have been using based off of log on information?
2 Comments
[ + ] Show comments
-
I know that you can look up the user name in inventory and find any system that shows them as the last logged in user. Not sure if that is anything that you are looking for. - maveric20001 9 years ago
-
Yeah that shows what they have logged onto and kinda takes care of that second part, but I am really looking for a way to pull all of the assets or inventory that is assigned to a person. Thanks for the reply! - Jhogue 9 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
grayematter
9 years ago
If you have access to the Settings -> Users tab, you can get that info. Otherwise, you will have to create a report. You can create a report for each asset type you are looking to include (making sure to be consistent in number/type of fields), then union the resulting SQL.
Comments:
-
Ok cool! That did let me browse what each user had assigned to them. How would I go about creating this report? Is there a location that shows how the asset information is stored in SQL? Like how can I do a select statement from a field in a table that all I know is the asset type? Thanks a bunch for the answer to my previous question! Even without the report that helped immensely! - Jhogue 9 years ago
-
The easiest way to build an asset report is to go through the wizard to get the proper fields and joins, then you can tweak the query in an SQL editor like MySQL Workbench. Once you have that working, you can put the query into the KACE report.
Unfortunately, the KACE reporting mechanism does not allow for prompting. So all criteria are coded into the query and are not enterable/selectable at runtime, i.e. the user you are looking for has to be coded into the query. - grayematter 9 years ago-
Thanks a bunch for your help! - Jhogue 9 years ago
