K1000 Inventory: Devices, is there a way to add Warranty End date?
I want the information that comes out of the device list, but I also need warranty information included, not sure if this can be added to this specific report?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
Hobbsy
9 years ago
You can get the warranty end date in the DELL_WARRANTY table at DELL_WARRANTY.END_DATE field, in the warranty table is also shown the service Tag DELL_WARRANTY.SERVICE_TAG so this data should be easy enough to extract using a simple SQL report
Something like
SELECT DELL_WARRANTY.SERVICE_TAG, DELL_WARRANTY.ENTITLEMENT_TYPE, DELL_WARRANTY.START_DATE, DELL_WARRANTY.END_DATE FROM DELL_WARRANTY left join MACHINE on MACHINE.BIOS_SERIAL_NUMBER = DELL_WARRANTY.SERVICE_TAG left join (select @limitct :=0) T on 1=1 ORDER BY SERVICE_TAG
