/build/static/layout/Breadcrumb_cap_w.png

Custom Dell Warranty Report - Locks up K1000

I am using the K1000 box and running version 5.3.47927. I created a custom SQL report to pull out the Dell Warranty information for computers with a certain label and everytime I run the report it just sits there saying it is processing the report and then eventually locks up the kbox. I was able to run a custom Dell Warranty report without the machine label section successfully. Below is the SQL I used:

_________________________________________________________________________________________________________________________________________

Dell Warranty Report - Label

SELECT DISTINCT M.NAME AS MACHINE_NAME,M.CS_MODEL AS MODEL, OS_NAME, DA.SERVICE_TAG, DA.SHIP_DATE, M.USER_LOGGED AS LAST_LOGGED_IN_USER,

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)

LEFT JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)

LEFT JOIN LABEL L ON (ML.LABEL_ID = L.ID)

WHERE M.CS_MANUFACTURER LIKE '%dell%'

AND M.BIOS_SERIAL_NUMBER!=''

AND DA.DISABLED != 1

AND L.NAME LIKE 'FDST'

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);

Break on Columns: MACHINE_NAME

__________________________________________________________________________________________________________________________________

Dell Warranty Report - All machines (this is the one that works)

SELECT DISTINCT M.NAME AS MACHINE_NAME,M.CS_MODEL AS MODEL, OS_NAME, DA.SERVICE_TAG, DA.SHIP_DATE, M.USER_LOGGED AS LAST_LOGGED_IN_USER,

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.BIOS_SERIAL_NUMBER!=''

AND DA.DISABLED != 1

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);

_______________________________________________________________________________________________________________________________________

thanks in advance!

Seth


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
This was an issue which has been resolved in server version 5.3.53053. Upgrade your server and you should not have any more problems with Dell Warranty reports.
Posted by: PHKace 12 years ago
Blue Belt
3

Hi Seth,

This was an issue which has been resolved in server version 5.3.53053.  Upgrade your server and you should not have any more problems with Dell Warranty reports.

Don't be a Stranger!

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

Sign up! or login

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