KACE Product Support

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