I would like to add new field to the built in dell warranty expired report. I duplicated the existing report and now I am stuck in adding the correct sql field to include "total memory" installed

any help will be much appreciated
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
SELECT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DA.SHIP_DATE,M.USER_LOGGED AS LAST_LOGGED_IN_USER, DW.SERVICE_LEVEL_CODE, 
DW.SERVICE_LEVEL_DESCRIPTION, DW.END_DATE AS EXPIRATION_DATE, RAM_TOTAL
FROM DELL_WARRANTY DW JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG)
JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG)
LEFT JOIN DELL_WARRANTY DW2 ON DW2.SERVICE_TAG=DW.SERVICE_TAG and DW2.END_DATE > NOW()
WHERE M.CS_MANUFACTURER LIKE '%dell%'
AND M.BIOS_SERIAL_NUMBER!=''
AND DA.DISABLED != 1
AND DW.END_DATE < NOW()
AND DW2.SERVICE_TAG IS NULL;

Answered 11/03/2015 by: SMal.tmcc
Red Belt

  • Use Toad for mySQL, It will show you the Field names
    • how do you use toad?
      • see https://support.software.dell.com/kb/114992 to enable third party access to server and http://software.dell.com/products/toad-for-mysql/ or https://www.toadworld.com/products/toad-for-mysql for toad
Please log in to comment
Answer this question or Comment on this question for clarity

Share