/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Kace Service Desk Creation of a ticket when Dell Warranty will expire in x days

08/23/2017 656 views
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

Comments


All Answers

0
Please delete one of your double entry Question.
Answered 08/24/2017 by: akmagnum
Red Belt

0
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. 


Answered 08/24/2017 by: chucksteel
Red Belt

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