/build/static/layout/Breadcrumb_cap_w.png

Warranty Expiration Report: how to add the type of OS on the report

Hello, I am working on a process to find out what machines are about to expire but I would like to know what OS has installed. We want to see what OS the machine as we are currently phasing out 32 bit machines to reinstall 64 bit and we are looking at the process to get those machines first.

Any help would be awesome.  Thanks


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: dugullett 11 years ago
Red Belt
0

Do you have a current report you are working off of? 


Comments:
  • I was working of the Dell Warranty Expiration 60 day report. This is one of the default reports that are on the system, I was just hoping to tweak it to add the field. - mmeyer@vu.com 11 years ago
    • ADD M.OS_NAME to the SELECT statement.

      SELECT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, M.OS_NAME, DA.SERVICE_TAG, DA.SHIP_DATE, M.USER_LOGGED AS LAST_LOGGED_IN_USER,
      DW.SERVICE_LEVEL_CODE, DW.SERVICE_LEVEL_DESCRIPTION, DW.SERVICE_PROVIDER,
      DW.END_DATE AS EXPIRATION_DATE
      FROM DELL_WARRANTY DW
      JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG)
      JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG)
      WHERE M.CS_MANUFACTURER LIKE '%dell%'
      AND M.BIOS_SERIAL_NUMBER!=''
      AND DA.DISABLED != 1
      AND DW.END_DATE > NOW()
      AND DW.END_DATE <= DATE_ADD(NOW(),INTERVAL 60 DAY)
      AND DW.END_DATE = (SELECT MAX(END_DATE) FROM DELL_WARRANTY DW2 WHERE DW2.SERVICE_TAG=DW.SERVICE_TAG AND DW2.SERVICE_LEVEL_CODE=DW.SERVICE_LEVEL_CODE); - dugullett 11 years ago
  • That is exactly what I needed. How would it get the IP information to show? - mmeyer@vu.com 11 years ago
    • Add IP to the SELECT statement. - dugullett 11 years ago
  • Thank you - mmeyer@vu.com 11 years ago

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