/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


K1000 Inventory: Devices, is there a way to add Warranty End date?

02/03/2015 2324 views
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


All 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ