Best Practices

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

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 6 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