/build/static/layout/Breadcrumb_cap_w.png

How to email users regarding MIAs?

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.

9 Comments   [ + ] Show comments
  • Please post the article and adjustments that failed. - chucksteel 7 years ago
  • 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) - ncaplan 7 years ago
    • Does your MIA report run successfully? - chucksteel 7 years ago
  • 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. - ncaplan 7 years ago
  • 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. - JasonEgg 7 years ago
  • 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 - ncaplan 7 years ago
  • The report is scheduled to run everyday at noon and should be emailed to me. It never runs, but I can run it manually. - ncaplan 7 years ago
  • Sorry, but I don't know what the CTR page is... - ncaplan 7 years ago
  • 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! - ncaplan 5 years ago
  • NCAPLAN, I was able to get this solution to work. Let me know if your still looking for help. - dnbfsu 3 years ago

Answers (0)

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