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:
Please log in to answer
Posted by:
dugullett
10 years ago
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 10 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 10 years ago
-
That is exactly what I needed. How would it get the IP information to show? - mmeyer@vu.com 10 years ago
-
Add IP to the SELECT statement. - dugullett 10 years ago
-
Thank you - mmeyer@vu.com 10 years ago
