/build/static/layout/Breadcrumb_cap_w.png

Adding notes to MIA 30 notification email

Hello, We have a weekly Notification email (Reports>Notifications) sent out to all of our techs containing a list of machines that have not checked into KACE in 30 days. This is done per region so our techs can review machines that haven't checked in to see if they can be deleted. Currently, our notification email only shows columns for Computer name, system description, MAC address, and IP Address but I would like to change it so the columns are for Computer name, Model, last logged in user, and notes so our techs can update an inventory device (not asset) with a note and have it appear in that email. For example, if someone is on maternity leave, the device notes can be updated with that information and when the email is read, it'll be listed that they are on maternity leave and that's the reason why it's on the list. I can locate the SQL for the notification but unfortunately I'm not with SQL. Any help with update the SQL so the columns instead would be Computer name, Model, Last logged in user, and notes columns? No matter what I change, it seems like the default columns of System description, MAC Address, and IP address are hardcoded. Thanks in advance! This is the existing SQL code: SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE (((TIMESTAMP(LAST_INVENTORY) > NOW() OR TIMESTAMP(LAST_INVENTORY) <= DATE_SUB(NOW(),INTERVAL 30 DAY))) AND (TZ_AGENT like '%America%'))

0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 2 years ago
Red Belt
0

Column names

Computer Name    Model   Description     Last Login



SELECT MACHINE.NAME AS 'Computer Name', MACHINE.CS_MODEL as 'Model', MACHINE. SYSTEM_DESCRIPTION as 'Description', MACHINE.LAST_USER as 'Last Login', MACHINE.ID as TOPIC_ID FROM MACHINE WHERE (((TIMESTAMP(LAST_INVENTORY) > NOW() OR TIMESTAMP(LAST_INVENTORY) <= DATE_SUB(NOW(),INTERVAL 30 DAY))) AND (TZ_AGENT like '%America%'))

Posted by: Fieds 2 years ago
White Belt
0

Thanks for the reply.  Unfortunately, it didn't work though.  I'm getting the sense that the columns are not customizable for notifications.



2Q==

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