How do I get the ship date to show in a report?
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
Answers (1)
Please log in to answer
Posted by:
aragorn.2003
8 years ago
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
Comments:
-
Thank you! - gp4040 8 years ago