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
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share