k1000 reporting
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
any help will be much appreciated
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
SMal.tmcc
8 years ago
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;
Comments:
-
Use Toad for mySQL, It will show you the Field names - SMal.tmcc 8 years ago
-
how do you use toad? - kace1000-2015 8 years ago
-
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 - SMal.tmcc 8 years ago