Compare availability of current year vs. previous year in Reports

I have created Reports for the availability of all my monitored Servers/ their services.
I am searching for an option to compare that availability percentages to them of the last year, so I can see if the availability has gotten better or worse. I could not find a native function therefore.
Thats why I allready checked the API option to extract the data and build my own report in another system but I also could not find a fitting API call.
The third Option I tried was extracting the data via all hosts → availability through URL editing, there it works pretty good, I can put in there URL that I want to extract it as csv, just putting the desired timespan didnt work so far in the URL.

Does anyone know a native solution for that? Or is there some plugin to reach it?

Thanks in advance!
Greetings

1 Like

You can use Checkmk URL to adjust your query for availability data, unfortunately I was not able to find a lot of details but here what Im using:

avo_rangespec_sel=0 - The last 4 hours
avo_rangespec_sel=1 - The last 25 hours
avo_rangespec_sel=2 - The last 8 days
avo_rangespec_sel=3 - The last 35 days
avo_rangespec_sel=4 - The last 400 days
avo_rangespec_sel=5 - Today
avo_rangespec_sel=6 - Yesterday
avo_rangespec_sel=7 - 7 days back (this day last week)
avo_rangespec_sel=8 - 8 days back
avo_rangespec_sel=9 - This week
avo_rangespec_sel=10 - Last week
avo_rangespec_sel=11 - 2 weeks back
avo_rangespec_sel=12 - This month
avo_rangespec_sel=13 - Last month
avo_rangespec_sel=14 - This year
avo_rangespec_sel=15 - Last year
avo_rangespec_sel=16 - The last…
avo_rangespec_sel=17 - Date range

avo_rangespec_16_days=0
avo_rangespec_16_hours=0
avo_rangespec_16_minutes=0
avo_rangespec_16_seconds=0

17_0 = Start, 17_1 = End
avo_rangespec_17_0_year=2024
avo_rangespec_17_0_month=1
avo_rangespec_17_0_day=1
avo_rangespec_17_1_year=2024
avo_rangespec_17_1_month=1
avo_rangespec_17_1_day=31

You will generate your regular report and use the fields that I shared to change the parameters. You can also create two custom views using your availability report and then create a dashboard to put it side by side.

1 Like

Thank you,
I just tried it again with these parameters and what I observed was that it indeed changed the timespan under display option but does not get applied until I press apply there, so its not really usable for an automatism, is there another URL Parameter which does the instant apply of it?
Your second call with the custom views oft the availability report also does sound interesting, can you maybe explain that further to me, because I also dont see how to add reports into a dashboard.

1 Like

The parameters are in the URL. You can modify the URL and the data will be shown according to the values available in the URL.

Regarding the dashboard you can do in the following order:

Select a view that contain all the hosts that you need.
Move to Availability view and adjust it accordingly to what you need.
Copy the generated URL (It should contain everything that you need in there)
Create a dashboard and add a object called Custom URL.