/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How to generate report for new agent installed.

05/17/2015 653 views
Hi guys,

I need some help. I need to create a report that everytime new agent is installed, it will auto-generate a report and send to an email.  

thanks in advance.
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
This query will show computer records that were created in the past 7 days:
SELECT MACHINE.NAME, MACHINE.IP FROM ORG1.MACHINE
WHERE MACHINE.CREATED > DATE_SUB(NOW(),INTERVAL 7 DAY)
To create and schedule this report:
1. In the Reporting module, Choose Action, New (SQL)
2. Paste the query from above and enter the other information as you see fit
3. Save the report
4. Under Reporting click Report Schedules
5. Click Choose Action, New
6. Enter a descriptive name
7. Choose the report from the dropdown
8. Fill out the notify section appropriately
9. Select the schedule

For the above query it would make sense to schedule this report to run weekly. If you would prefer daily notification then change the query interval from 7 day to 1 day and set the schedule for daily.

Answered 05/18/2015 by: chucksteel
Red Belt

  • Hi chucksteel, thanks a lot.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ