/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


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?

03/04/2020 238 views

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

1 Comment   [ + ] Show comment

Comments

  • You can get that report using the report wizard, just select device as your topic and you will find the:

    Computer name, computer description under Device Identity Information
    Last User Login under User Information
    Asset Location and Asser user under assets.

All Answers

0

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

Answered 03/05/2020 by: Hobbsy
Red Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ