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!

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.
Cancel
0 Comments   [ + ] Show Comments

Comments

  • This content is currently hidden from public view.
    Reason: Member is not approved yet
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Member is not approved yet
    For more information, visit our FAQ's.
Please log in to comment

Answers

3

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)
Answered 02/25/2013 by: dugullett
Red Belt

  • You can change "1DAY" to "1 WEEK" and run a weekly report.
  • 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?
    • 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.
      • Doy. Sorry, it's a Monday. Thanks so much!
Please log in to comment
Answer this question or Comment on this question for clarity