/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Kace Report to show assigned assets and associated assets under each user

02/23/2017 2635 views

Is there any way to generate a report in Kace with the users info, then the assigned assets and associated assets underneath with the values from their asset types.

For example, under my user in Kace I have a primary machine under assigned computer assets and a mobile phone under associated assets.
Can I generate a report like the following:


Curtis Lewis    PrimaryEmail    Manager   Location
ServiceTag      Vendor             Model
MobileNo         Make                Model


I can generate a report showing the first 2 lines, but the mobile number just shows up in the same row as the computer asset.

Thanks,

Curtis
    

0 Comments   [ + ] Show comments

Comments


All Answers

0
This will repeat the user's name, rather than having a nice table for each user, but it works:
SELECT U.FULL_NAME,
       A.ID AS ASSET_ID,
       A.NAME,
       A.ASSET_DATA_ID,
       A.MODIFIED,
       A.CREATED,
       A.LOCATION_ID,
       M.*
FROM USER U
     JOIN ASSET A ON U.ID = A.OWNER_ID
     LEFT JOIN MACHINE M ON M.BIOS_SERIAL_NUMBER = A.MAPPED_ID
ORDER BY U.FULL_NAME ASC
Answered 02/28/2017 by: JasonEgg
Red Belt

  • Thanks for looking at this JasonEgg, appriciate it.

    However when I setup a SQL report using the above and attempt to run it, it throws an error:

    Error Running Report
    Internal error (3). Please contact KACE Support.

    I'm guessing I may be doing something wrong or perhaps referencing a table / field that doesn't exsit?

    Curtis
    • How big is your asset table? If it's huge then maybe that's where the error is coming from? I have 5,200 rows in the asset table and the query took about 20 seconds when I ran it through the web UI.
    • FYI I would suggest using a program like Toad or MySQL workbench to test queries.
 
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