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

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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

Answered 05/08/2013 by: dugullett
Red Belt

  • 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.
    • 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);
  • That is exactly what I needed. How would it get the IP information to show?
    • Add IP to the SELECT statement.
  • Thank you
Please log in to comment
Answer this question or Comment on this question for clarity