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.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1
Here's a modified version of the built in expiration report.

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);
Answered 12/14/2011 by: dchristian
Red Belt

Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
That worked perfect. Thanks!
Answered 12/14/2011 by: tld212s
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity