I am trying to generate a report in KACE (K1000 v6.0) to return all computers in my inventory that have expired warranty's.  I have done this before using the reporting wizard in K1000 v5.5 but now the option to select expiration date seems to be gone, unless i am overlooking it or are in the wrong place.  Can someone point me to where this is or is there a code to input into the SQL report generator?  Thanks.
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Hello,

Well, we use this SQL query :


SELECT DISTINCT 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.END_DATE AS EXPIRATION_DATE
FROM DELL_WARRANTY DW
LEFT JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG)
LEFT JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG)
WHERE M.CS_MANUFACTURER LIKE '%dell%'
AND DW.END_DATE=(Select Max(DW2.END_DATE) FROM DELL_WARRANTY DW2 WHERE DW2.SERVICE_TAG=DA.SERVICE_TAG)
AND M.BIOS_SERIAL_NUMBER!=''
AND DA.DISABLED != 1
AND DW.END_DATE AND DW.SERVICE_TAG NOT IN ( SELECT SERVICE_TAG FROM DELL_WARRANTY WHERE END_DATE > NOW())
Order by EXPIRATION_DATE

Br,

Alexandre

Answered 06/27/2014 by: chauchauf
White Belt

  • That threw a big old RED Error box on my K1000 6.0 box
Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity

Share