KACE Product Support Question
KACE SQL reporting question
03/22/2017 1325 views
I have a report that gives me a single line entry for my expiring dell warranties. What I am trying to accomplish is to also show custom asset info on each line "Location", "Department", and "Property Name" to be able to send each department head info on what machines they need to replace. I have this SQL script below was obtained through another post and am not sure how to add the "Location", "Department", and "Property Name" to the report. I also ran a report to show me what the Table/Field, Field Name, and Field Type are. Any help is appreciated I am not fluent enough in SQL to begin to write the code.
|Table/Field||Field Name||as Field Type|
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
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
ORDER BY "Ship Date", MACHINE.NAME