Systems Management

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%'))