ReportIt - use windows uptime template/power fail?

[Moegoe]

Hi. Would anybody maybe have an idea how you could use the windows uptime template to generate a report on how many times a device rebooted over a specific time and for how long it was down in each reboot? Please - i need some help as i think it would be a good report to look at.

[Moegoe]

I notice that when you convert the rrd file for a better understanding you get NaN values during a power failure - how would you incorporate this for a calculation for report?


<!-- 2020-08-13 07:55:00 SAST / 1597298100 --> <row><v> 3.2671163840e+07 </v></row>
<!-- 2020-08-13 08:00:00 SAST / 1597298400 --> <row><v> 3.2701181520e+07 </v></row>
<!-- 2020-08-13 08:05:00 SAST / 1597298700 --> <row><v> 3.2731170320e+07 </v></row>
<!-- 2020-08-13 08:10:00 SAST / 1597299000 --> <row><v> 3.2761168053e+07 </v></row>
<!-- 2020-08-13 08:15:00 SAST / 1597299300 --> <row><v> 3.2791451240e+07 </v></row>
<!-- 2020-08-13 08:20:00 SAST / 1597299600 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:25:00 SAST / 1597299900 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:30:00 SAST / 1597300200 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:35:00 SAST / 1597300500 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:40:00 SAST / 1597300800 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:45:00 SAST / 1597301100 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:50:00 SAST / 1597301400 --> <row><v> NaN </v></row>
<!-- 2020-08-13 08:55:00 SAST / 1597301700 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:00:00 SAST / 1597302000 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:05:00 SAST / 1597302300 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:10:00 SAST / 1597302600 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:15:00 SAST / 1597302900 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:20:00 SAST / 1597303200 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:25:00 SAST / 1597303500 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:30:00 SAST / 1597303800 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:35:00 SAST / 1597304100 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:40:00 SAST / 1597304400 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:45:00 SAST / 1597304700 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:50:00 SAST / 1597305000 --> <row><v> NaN </v></row>
<!-- 2020-08-13 09:55:00 SAST / 1597305300 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:00:00 SAST / 1597305600 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:05:00 SAST / 1597305900 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:10:00 SAST / 1597306200 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:15:00 SAST / 1597306500 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:20:00 SAST / 1597306800 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:25:00 SAST / 1597307100 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:30:00 SAST / 1597307400 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:35:00 SAST / 1597307700 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:40:00 SAST / 1597308000 --> <row><v> NaN </v></row>
<!-- 2020-08-13 10:45:00 SAST / 1597308300 --> <row><v> 5.6606000000e+04 </v></row>
<!-- 2020-08-13 10:50:00 SAST / 1597308600 --> <row><v> 8.6102866667e+04 </v></row>
<!-- 2020-08-13 10:55:00 SAST / 1597308900 --> <row><v> 1.1581678000e+05 </v></row>
<!-- 2020-08-13 11:00:00 SAST / 1597309200 --> <row><v> 1.4589888333e+05 </v></row>
<!-- 2020-08-13 11:05:00 SAST / 1597309500 --> <row><v> 1.7592584000e+05 </v></row>
<!-- 2020-08-13 11:10:00 SAST / 1597309800 --> <row><v> 2.0621271000e+05 </v></row>
<!-- 2020-08-13 11:15:00 SAST / 1597310100 --> <row><v> 2.3548096667e+05 </v></row>
<!-- 2020-08-13 11:20:00 SAST / 1597310400 --> <row><v> 2.6585056667e+05 </v></row>
<!-- 2020-08-13 11:25:00 SAST / 1597310700 --> <row><v> 2.9570818667e+05 </v></row>
<!-- 2020-08-13 11:30:00 SAST / 1597311000 --> <row><v> 3.2591675667e+05 </v></row>
<!-- 2020-08-13 11:35:00 SAST / 1597311300 --> <row><v> 3.5572952667e+05 </v></row>
<!-- 2020-08-13 11:40:00 SAST / 1597311600 --> <row><v> 3.8582787000e+05 </v></row>
<!-- 2020-08-13 11:45:00 SAST / 1597311900 --> <row><v> 4.1591410000e+05 </v></row>
<!-- 2020-08-13 11:50:00 SAST / 1597312200 --> <row><v> 4.4573887333e+05 </v></row>
<!-- 2020-08-13 11:55:00 SAST / 1597312500 --> <row><v> 4.7586561333e+05 </v></row>
<!-- 2020-08-13 12:00:00 SAST / 1597312800 --> <row><v> 5.0586138000e+05 </v></row>

[netniV]

rrdtool has dump and csv options to export the data. you could then do a quick calculation on the exported data.

[Moegoe]

Thank you for taking the effort to reply - unfortunately im a noob and need a bit more spoon-feeding at this stage of my ReportIt journey I was hoping to be able to incorporate the f_max or nan operators somehow already in the program. If i want to count the amount of NaN`s in an rrd file is there a function like (count(nan)) i can put down on the "Calculation Formula" line in the "Measurand configuration"? I don`t mind reading - is there any other docs you could point me towards perhaps except for the "reportit_061 introduction.pdf"?

[netniV]

That is the one I always go back to when I need to refresh my memory. I don't use it enough and so when I come to develop any part of that or test it, I have to refer to it myself because it's not my code