Report - Servers with Expiring Warranty
I am needing help with a report. I need a report that will show all servers that have expiring warranty within the next 365 days. It needs to show:
Server Name
Service Tag
Current Support Level
Support End Date
Could anybody help me with this? I tried creating a normal report, but warranty level is not a report option to pick from.
Server Name
Service Tag
Current Support Level
Support End Date
Could anybody help me with this? I tried creating a normal report, but warranty level is not a report option to pick from.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dchristian
12 years ago
Here's a modified version of the built in expiration report.
It should only included servers and work for 365 days.
It should only included servers and work for 365 days.
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.SERVICE_PROVIDER,
DW.END_DATE AS EXPIRATION_DATE
FROM KBSYS.DELL_WARRANTY DW
LEFT JOIN KBSYS.DELL_ASSET DA
ON ( DW.SERVICE_TAG = DA.SERVICE_TAG )
LEFT 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.OS_NAME LIKE '%SERVER%'
AND M.BIOS_SERIAL_NUMBER!='
AND DA.DISABLED != 1
AND DW.END_DATE > NOW()
AND DW.END_DATE <= DATE_ADD(NOW(), INTERVAL 365 DAY)
AND DW.END_DATE = (SELECT Max(END_DATE)
FROM KBSYS.DELL_WARRANTY DW2
WHERE DW2.SERVICE_TAG = DW.SERVICE_TAG
AND DW2.SERVICE_LEVEL_CODE = DW.SERVICE_LEVEL_CODE);
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.