/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


k1000 reporting

11/03/2015 886 views
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


All 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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