What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Report of all alerts received?

Votes:

0

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

alerts reports summary

Created on May 27, 2011 4:03:40 PM



Best Answer

Accepted Answer

Votes:

0

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.

Created on May 31, 2011 8:12:26 AM

Last change on Jun 3, 2011 11:56:34 AM by  Torsten Lindner [Paessler Support]



2 Replies

Votes:

0

Dear Paul,

I'm afraid such a report is not possible.

best regards.

Created on May 30, 2011 1:22:21 PM by  Torsten Lindner [Paessler Support]



Accepted Answer

Votes:

0

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.

Created on May 31, 2011 8:12:26 AM

Last change on Jun 3, 2011 11:56:34 AM by  Torsten Lindner [Paessler Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.