/build/static/layout/Breadcrumb_cap_w.png

I need a report in KACE

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
  • 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? - Hobbsy 8 years ago
  • 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; - ahunn 8 years ago
  • 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. - ahunn 8 years ago
  • Have you tried using the Reporting Wizard tool in Kace? The report you need will be very simple to make if you use it. - gkiedrowski 7 years ago

Answers (1)

Posted by: JasonEgg 7 years ago
Red Belt
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

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