08/17/2016 703 views
I'm trying to create a report that among other things show if the PC in inventory has been scrapped. Our Asset Information has what I think is a custom field for "Scrapped?". I'm not sure how to get that field to show in my report. This is what I have so far.
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%'
AND MACHINE.CHASSIS_TYPE != 'server'
GROUP BY MACHINE.NAME
ORDER BY "Ship Date", MACHINE.NAME