Can I create a custom report in KACE using specific computer names and see the description, Asset Location, Assigned User and last user to login to the machine?
We have roughly 260 computer names and I would like to run a custom SQL report that will show the following information:
Computer Name
Computer Description
Asset Location
Assigned User
Last User Login
Answers (1)
or from the wizard
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, ASSET_LOCATION.NAME AS LOCATION, USER_FULLNAME FROM MACHINE LEFT JOIN ASSET ON ASSET.MAPPED_ID = MACHINE.ID AND ASSET.ASSET_TYPE_ID=5 LEFT JOIN ASSET ASSET_LOCATION ON ASSET_LOCATION.ID = ASSET.LOCATION_ID ORDER BY SYSTEM_NAME
This may not be a straightforward as you need though as the location field is actually an attribute of an Asset and as such is not updated in any automated way, so it may be worth considering if you have location labels setup, based on subnets, to pull in that data as well to the report
Computer name, computer description under Device Identity Information
Last User Login under User Information
Asset Location and Asser user under assets. - olgonzo 4 years ago