Allow custom SQL notifications to display more (or less) than the 4 default columns
When doing a custom SQL query in a notification, no matter what columns the query specifies, the K1000 only sends data for 4 columns:
Computer Name, System Description, MAC Address, and IP Address
Test with the query below:
SELECT MACHINE.NAME AS SYSTEMNAME, MACHINE.USERFULLNAME as USERNAME, LASTSYNC as CHECKINTIME FROM MACHINE WHERE (((TIMESTAMP(LASTSYNC) > NOW() OR TIMESTAMP(LASTSYNC) <= DATESUB(NOW(),INTERVAL 18 DAY))))
Thank you for your UserVoice suggestion. This request has aged without many votes, so we are going to close it and free up your votes. If you still feel that it should be reconsidered, please feel create a new UserVoice request. Thank you again for your contribution!