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 7 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 7 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 7 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)
Please log in to answer
Posted by:
JasonEgg
7 years ago
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
