/build/static/layout/Breadcrumb_cap_w.png

[Help] Dell KACE Report Age and Model of machine

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
  • 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. - gkiedrowski 7 years ago

Answers (1)

Posted by: chucksteel 8 years ago
Red Belt
5
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

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