Kace Service Desk Creation of a ticket when Dell Warranty will expire in x days
Is it possible with Kace SMA to have a ticket created in the service desk when The dell warranty will be expired in 90 days? I'm at loss to even begin to make the rule for this.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
chucksteel
7 years ago
I would suggest creating a report that indicates those machines and scheduling the report to run on a recurring basis. Personally, I would not directly create tickets because implementing a logic flow that only creates one ticket per computer would make it much more complicated.
Here is a report showing the computers with a maximum warranty expiration date in the next 90 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, MAX(DW.END_DATE) AS EXPIRATION_DATE
FROM DELL_WARRANTY DW JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG)
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 M.BIOS_SERIAL_NUMBER!=''
AND DA.DISABLED != 1
GROUP BY MACHINE_NAME
HAVING EXPIRATION_DATE BETWEEN NOW() and DATE_ADD(NOW(), INTERVAL 90 DAY)
ORDER BY EXPIRATION_DATE DESC
Note that your Dell hardware may have multiple associated warranties and this report only looks at the longest one.