Automatic reports with data of last 12 months

Hi Benny,

What exactly do you mean with "the report will almost be ready"? If better reporting capabilities are required, check out PRTG SLA from our partner ITCorp :)

Kind regards,
Stephan Linke, Tech Support Team

Sorry..typo…...the report will be almost "empty" if we run it on 1 January with settings to current year...

Please post the entire configuration of the report as screenshot, maybe some of the settings are not quite correct :)

Kind regards,
Stephan Linke, Tech Support Team

How do I add screenshots or files to a post?

Simply upload it to a image host of your choice and use the following syntax to embed

{ { image url | title } }

Remove the whitespaces to make this markup work, I just added them for display purposes :)

Kind regards,
Stephan Linke, Tech Support Team

Hi Sorry for this late reply...

I'm just looking for a report that i can send to a people each month, showing the trend of the last x months... When i set in settings of a report: - period: current - report period type: quarter

I get a report showing the current quarter, a graph running from 1/7 until 30/9 (witch is blank for september) and also date in this same period where the data is blanc for the whole month of september. When i would run this report on 1/10...i suppose everything will be blank as the current quarter then will be from 1/10 until 31/12???

Can you indicate me what params i need to setup the make a automatic report with the data from the past 3 months (or x months if possible?) ...so that at any time this report runs it takes the last 3 months of data available in the system?

Rgds Benny

Hello Benny,

You have to either select the time frame of the last quarter within the report's Settings tab. Please scroll down to Period ("What time span will the report cover?" and select

Afterwards, navigate to the report's Run Now tab and select the last three months from the Quick Range section as well.

Best regards,
Sebastian

Hey Sebastian, I know about the previous or current quarter. But changing this every time defeats the purpose or automatically sending a report per email about sensor readings from the last 3 months???

if we need to change every time we need to run the report range selection manually, it's not an automatic report anymore?

I just want to automate some reports to management, sending the last 3 months of sensor readings every beginning of the month.

PS. the link you send for the addon from itcorp in the first respons does not work....

Hi Benny,

Thank you very much for your reply.

I just tested the following settings and can confirm that the configuration below works:

Schedule ("When will this report be run?"):

Period ("What time span will the report cover?"):

Of course, configure things such as Template, Paper Size, Orientation etc. to the settings that suit your needs. Afterwards, select the sensors and objects that should be covered within the report from the Select Sensors Manually tab and save the report generation.

This will create the report on the first day after the quarter has finished. I just verified it with the report generated at a specific hour instead.

The link above should direct to: https://www.corp-it.ch/#slaPlugin.

Best regards,
Sebastian

Hi Sebastian, thnx for the reply, and indeed if you set the params like you propose, on the first day of the quarter i can sent a report about the last quarter.

But if we set it like this, we will only be able to sent the report once every quarter. Is there really no way to setup a automatic report that sends an overview of the last 3 months every first day of the every month? I can setup every first day of the month to sent the previous month...but this will only contain data of one month….

Rgds Benny

Hello Benny,

Sorry to say but there is only the option to generate the report of the previous month or the previous quarter. At least for the internal reporting system.

If your keen, you could check out if you're able to export the data using PRTG's API. Navigate to "Setup | PRTG API | Historic Data". There are a bunch of highly customizable API calls that might help to export the data as required. However, the data will be not really impressive in terms of readability as they are most likely .xml raw data exports so you'll need to post-process the raw data in Excel in this case.

I'm sorry but there is no more satisfactory answer.

Best regards,
Sebastian

Hi Sebastian, to come back on this, I think we our self found a solution to our problem.

we created a custom template for the report, based on an existing one.

In the reportgraph section, we changed the parameters of the graph, and added startoff="-90" endoff="0" apparently these parameters control the start/enddate offset from what the chosen date range is in the setup.

so now, every first day of the month, we generate a report period type month, with report period previous. If we run this for the period 1/9-30/9....with the offset calculated, it will give us a graph from 1/6..30/9....just what we wanted.

We had to figure out some stuff in the report templates, but the result is there so now we can start using this...

Thnx for the previous help, but as we resolved the problem, this thread can be closed.

Rgds

Benny Giebens

Hello Benny,

Nice work!

Best regards,
Sebastian