There is a field in Kace called ship date in Devices > choose a device > Hardware. I need to pull that into a report and don't see how. 
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
For Dell devices the warranty information are listed in the DELL_WARRANTY table.

Example SQL Script.

select distinct UCASE(m.NAME) as NAME, m.USER_FULLNAME, m.OS_NAME,    
       concat(m.CS_MANUFACTURER, ' ', m.CS_MODEL) as TYPE, w.SERVICE_TAG, 
DATE_FORMAT(w.START_DATE, '%d.%m.%Y') as SHIPPING
  from MACHINE as m, DELL_WARRANTY as w
 where m.BIOS_SERIAL_NUMBER = w.SERVICE_TAG
order by w.END_DATE
Answered 12/02/2015 by: aragorn.2003
Red Belt

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