/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


How to email users regarding MIAs?

02/24/2017 870 views
I would like to set up an automated process that emails the users when their device(s) are MIA for +15 days. I found one article but the solution failed ~ even with adjustments to the code.
8 Comments   [ + ] Show comments

Comments

  • Please post the article and adjustments that failed.
  • Article: http://www.itninja.com/blog/view/using-ticket-rules-to-automate-non-ticket-emails
    Code: IF(USER.EMAIL IS NULL or USER = '', 'my.email@domain.com', USER.EMAIL) as user_email,
    -- 'my.email@domain.com' as user_email, -- (for testing)
    • Does your MIA report run successfully?
  • yes and I can do a mail merge using Excel and Word, but I just want the emails sent automatically to the user of the device.
  • Can you paste the full MIA report SQL? If you've set up the CTR page already, let us know the settings you have on there, too.
  • SELECT MACHINE.NAME AS SYSTEM_NAME, LAST_SYNC, OS_NAME, MACHINE.IP, USER_FULLNAME, ASSET_OWNER.EMAIL AS ASSIGNEE_EMAIL, BIOS_SERIAL_NUMBER, CS_MANUFACTURER, CS_MODEL, MACHINE.NOTES FROM MACHINE LEFT JOIN ASSET ON ASSET.MAPPED_ID = MACHINE.ID AND ASSET.ASSET_TYPE_ID=5 LEFT JOIN USER ASSET_OWNER ON ASSET_OWNER.ID = ASSET.OWNER_ID LEFT JOIN KBSYS.KUID_ORGANIZATION KUID_ORG ON KUID_ORG.KUID = MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID AND substring(SCHEMA(),4) = KUID_ORG.ORGANIZATION_ID WHERE ((SC.DISCONNECT_TIME < now() ) AND (concat(SC.CLIENT_CONNECTED) = '0') AND ((TIMESTAMP(SC.DISCONNECT_TIME) > NOW() OR TIMESTAMP(SC.DISCONNECT_TIME) <= DATE_SUB(NOW(),INTERVAL 15 DAY)))) ORDER BY ASSIGNEE_EMAIL
  • The report is scheduled to run everyday at noon and should be emailed to me. It never runs, but I can run it manually.
  • Sorry, but I don't know what the CTR page is...
  • I know this has been a year, but I still need help in accomplishing this task. I am now on the current version.
    KACE Systems Management Appliance
    Model: K1000
    Hardware Model: Virtual (VMware/Hyper-V)
    Version: 8.1.108
    Surely by now there is a simple solution. Thanks!

Be the first to answer this question

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