/build/static/layout/Breadcrumb_cap_w.png

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.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: dchristian 12 years ago
Red Belt
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);
Posted by: tld212s 12 years ago
Senior Yellow Belt
0
That worked perfect. Thanks!
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ