The following custom SQL report will provide the Dell Service Info details found on a Dell computer's Computer Inventory page along with the warranty end date and days remaining. (Note the two highlighted 'KBSYS.' parts - as of version 5.4, these tables are no longer in KBSYS. If you are using version 5.3, leave the query as is. If you are on 5.4+, delete both highlighted parts, including the '.' after KBSYS).
Select
M.NAME As 'Computer Name',
DA.SERVICE_TAG As 'Service Tag',
DA.MACHINE_DESCRIPTION As 'System Type',
Date(DA.SHIP_DATE) As 'Ship Date',
DW.END_DATE As 'Warranty Expiration Date',
IF(DATEDIFF(DW.END_DATE, NOW()) > 0,
Concat(DATEDIFF(DW.END_DATE, NOW()), ' days remaining'),
'Warranty has expired') As 'Warranty days remaining'
From
KBSYS.DELL_ASSET DA Left Join
KBSYS.DELL_WARRANTY DW On (DW.SERVICE_TAG = DA.SERVICE_TAG) Left Join
MACHINE M On
(M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG Or
M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG)
Where
M.CS_MANUFACTURER Like '%dell%' And
M.BIOS_SERIAL_NUMBER != '' And
DA.DISABLED != 1
http://www.itninja.com/question/kace-create-dell-warranty-report
If you need any help or further adjustments, just post a new question.
John - jverbosk 12 years ago