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

Comments

Please log in to comment

Answers

0
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
Answered 02/04/2015 by: Hobbsy
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity