How do you generate a report using K1000 v6.0 to return all expired computers in your inventory?
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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chauchauf
10 years ago
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
Comments:
-
That threw a big old RED Error box on my K1000 6.0 box - cottonakin 10 years ago
