/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Community Chosen Answer


Answers

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.
Answer this question or Comment on this question for clarity

Answers

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

Please log in to comment