Report to announce new machines added to inventory?
Hello,
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!
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
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.
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.
Please log in to answer
Posted by:
dugullett
11 years ago
I don't use IP scans so there may be a way to report on that. 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)
Comments:
-
You can change "1DAY" to "1 WEEK" and run a weekly report. - dugullett 11 years ago
-
That works pretty well, thanks! So if I make this an automatic thing by day, for example, will it send out a report once a day regarldess of new information, or is there a way to have it only send out a report when new machines are added? - Mark_B 11 years ago
-
You can leave it as is, and run it daily. When you schedule the report there is a check mark box under "Email Notification" that will only send when results are present. If no machines were added that day there will be no report sent.
This looks at the "Record Created" field in your inventory. If that record is less than a day old it will fall into this report. The next day the record will be two days old so it will drop off. - dugullett 11 years ago-
Doy. Sorry, it's a Monday. Thanks so much! - Mark_B 11 years ago
-
- Mark_B 11 years ago
