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%'))
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%'))
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
efforts, please visit