Votes:
Hello-
Is it possible to generate a report of all alerts received for a set of sensors or a group?
Basically, I'd like to be able to generate a monthly report for customers showing them a summary of all the alerts that their devices have generated in the last month.
Is this possible?
Paul
Votes:
For these sensors you could set up a batch file Notification that appends the alert to a .csv file.
The name of the text file can include the year, month and day number, so there will be a separate "report" for every year,month or day. The example below produces a separate file for every day.
@echo off
rem based on date output "vr 03-12-2010"
@For /F "tokens=1,2,3,4 delims=- " %%A in ('Date /t') do @(
Set day=%%B
Set month=%%C
Set year=%%D
)
FOR /F %%a IN ('time /t') DO SET Time=%%a
Set file="c:\temp\Notification %year%-%month%-%day%.csv"
rem based on PRTG's default input parameters for notifications %sitename %device %name %status %down %message
if not exist %file% echo Date,Time,Sitename,Device,Name,Status,Down,Message >> %file%
echo %year%-%month%-%day%,%time%,%1,%2,%3,%4,%5,%6 >> %file%
If you set up different notifications for different customers, you can also include the customer name in the name of the text file.
Open the .csv file with Excel for further processing and reporting.
Last change on Jun 3, 2011 11:56:34 AM by
2 Replies
Votes:
Dear Paul,
I'm afraid such a report is not possible.
best regards.
Created on May 30, 2011 1:22:21 PM by
Votes:
For these sensors you could set up a batch file Notification that appends the alert to a .csv file.
The name of the text file can include the year, month and day number, so there will be a separate "report" for every year,month or day. The example below produces a separate file for every day.
@echo off
rem based on date output "vr 03-12-2010"
@For /F "tokens=1,2,3,4 delims=- " %%A in ('Date /t') do @(
Set day=%%B
Set month=%%C
Set year=%%D
)
FOR /F %%a IN ('time /t') DO SET Time=%%a
Set file="c:\temp\Notification %year%-%month%-%day%.csv"
rem based on PRTG's default input parameters for notifications %sitename %device %name %status %down %message
if not exist %file% echo Date,Time,Sitename,Device,Name,Status,Down,Message >> %file%
echo %year%-%month%-%day%,%time%,%1,%2,%3,%4,%5,%6 >> %file%
If you set up different notifications for different customers, you can also include the customer name in the name of the text file.
Open the .csv file with Excel for further processing and reporting.
Last change on Jun 3, 2011 11:56:34 AM by
Add comment