Report to announce new machines added to inventory?
I'm not the best with scripting reports, so hopefully someone here can assist me. I'm looking for a simple report to send an email with information of a new machine added to the inventory. For example, we have a number of ip scans that run on the weekend. If a new device is added, I'd like the report to simply give the name of the machine as soon as it first checks into the system. Hopefully something like this is possible (I'd think it must).
Let me know if you need more information. Thanks!
This report will show you all the machine records created in the past day. You can modify the number to match what you need. SELECT NAME, IP,MAC, USER_LOGGED FROM MACHINE M WHERE CREATED > DATE_SUB(NOW(), INTERVAL 1 DAY) You can change "1DAY" to "1 WEEK" and run a weekly report.