/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


[Help] Dell KACE Report Age and Model of machine

11/07/2016 1864 views
Hi all,

I'm having a difficult time using the Wizard to generate what seems like a straightforward report. I need to create a report that:

1. Shows the age of our PCs and Laptops
2. Shows the model of each PC/laptop. 

We're an all Dell shop so this report should be pretty easy to create but the Wizard feels a bit cumbersome/convoluted to use.
1 Comment   [ + ] Show comment

Comments

  • To display the model just select "System model" underneath "Manufacturer and BIOS Info" in the reporting wizard generator. For the age of the machine you can report when the computer or laptop was added to Kace. I don't know if that is exactly what you are looking for but you just select "Created" underneath Device Identity Information.

All Answers

4
This shows the ship date and not the age but it should work otherwise.
SELECT DISTINCT(MACHINE.NAME), 
MACHINE.OS_NAME, 
MACHINE.CS_MODEL, 
DA.SHIP_DATE AS "Ship Date"
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
ORDER BY "Ship Date", MACHINE.NAME

Answered 11/08/2016 by: chucksteel
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