/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


I need a report in KACE

12/21/2016 901 views
Does anyone have some SQL code for a report in that shows: 
Every user that I have in Kace, 
The Assets that the user has, 
Asset ID associated with the Asset, 
Make, Model and PC Type
Department
End User,
Location,
BIOS SN.

I know its a lot to ask but I am just learning SQL and don't know much about it at all.

If it's too much I would at least like the End User, Asset ID, Make and Model.
I will figure out the rest when I can.

Please help!

Thank you in advance for your help.

Edit:

Here is a picture of the columns that I would like in the report..


4 Comments   [ + ] Show comments

Comments

  • Are you asking for assets assigned to users, via the user/owner field in the asset type or just the user data shown within inventory?
  • I'm not sure if I'm explaining it right but here goes: I need the Assets assigned to users. I'd also like it to have the Asset ID that I have assigned for each device a user has;
  • This is all new to me so I added a picture in the original post. I'm starting more SQL training today and hopefully it brings me some clarity and understanding.
  • Have you tried using the Reporting Wizard tool in Kace? The report you need will be very simple to make if you use it.

All Answers

0
This should get you started:
SELECT `USER`.USER_NAME,
       ASSET.ID   AS 'Asset ID',
       MACHINE.ID AS 'Device ID',
       MACHINE.CS_MANUFACTURER,
       MACHINE.CS_MODEL,
       MACHINE.CHASSIS_TYPE,
       MACHINE.BIOS_SERIAL_NUMBER
FROM `USER`
     JOIN ASSET ON ASSET.OWNER_ID = `USER`.ID
     LEFT JOIN MACHINE ON MACHINE.ID = ASSET.MAPPED_ID
ORDER BY `USER`.USER_NAME ASC
Answered 02/01/2017 by: JasonEgg
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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