KACE Product Support Question
Need Kace Report Showing Warranty By Computers In A Label
I need a Kace report that will show the warranty information on computers in a certain label. I also want the latest warranty as these seem to generate multiple warranty's on our end. Usually three to for per machine. We have a certain department that wants to list all of the computers in the department and when the warranty is expiring. Thanks for your help.
Answer Chosen by the Author
DA.SHIP_DATE AS "Ship Date",
MAX(DW.END_DATE) AS "Warranty End Date",
DW.SERVICE_LEVEL_DESCRIPTION as "Service Level"
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
JOIN MACHINE_LABEL_JT on MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID
JOIN LABEL on LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
and LABEL.NAME = "Library Services"
GROUP BY MACHINE.NAME
ORDER BY `Warranty End Date`, MACHINE.NAME