/build/static/layout/Breadcrumb_cap_w.png

ITNinja Question


Report - Servers with Expiring Warranty

12/14/2011 3493 views
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



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

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

All Answers

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

 
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