/build/static/layout/Breadcrumb_cap_w.png

Report showing Dell Service Info found on Inventory page

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

Comments

  • good report.... is it possible for one more column with days left on warranty - binuani 11 years ago
    • I've modified the report to include the warranty expiration date as well as '## Warranty days remaining' or 'Warranty has expired,' depending on the warranty status. Full disclosure - my test machine does not have PCs with warranty end dates, so I was unable to fully test the report. I do have machines with ship dates, so I tested with that field instead. - PHKace 11 years ago
  • You could try the warranty report variations that I provided here:

    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 11 years ago
This post is locked
 
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