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

how get Percentile and 95th from api/historicdata.xml

Votes:

0

i use this address to extract Percentile and 95th fro a sensor

/historicdata_html.htm?id=16604&sdate=2016-10-17-10-26-00&edate=2016-10-31-10-26-00&avg=3600&pctavg=3600&pctshow=true&pct=95&pctmode=false

but in api/historicdata.xml output i can't find this value please help me

version: PRTG Network Monitor 13.2.3.2235+

95th api percentile

Created on Oct 31, 2016 1:33:14 PM

Last change on Jan 23, 2017 11:31:39 AM by  Luciano Lingnau [Paessler]



4 Replies

Votes:

0

Did you try to set pctmode to true in the query to receive the percentile'd values? :)

Created on Oct 31, 2016 7:28:30 PM by  Stephan Linke [Paessler Support]



Votes:

0

In the current PRTG Version ( 17.1.28.1032 ), the following works:

/api/historicdata.xml?id=1001&avg=300&pctavg=120&pctshow=true&pct=95&pctmode=true&sdate=2017-01-10-00-00-00&edate=2017-01-10-01-00-00

And produces the following XML output:

<?xml version="1.0" encoding="UTF-8"?>
  <histdata totalcount="12" listend="1">
   <prtg-version>17.1.28.1032</prtg-version>
   <item>
    <datetime>10.01.2017 00:00:00 - 00:05:00</datetime>
    <datetime_raw>42744.9618055556</datetime_raw>
    <value channel="Health" channelid="0">100 %</value>
    <value_raw channel="Health" channelid="0">100.0000</value_raw>
    <value channel="System CPU Load" channelid="1">5 %</value>
    <value_raw channel="System CPU Load" channelid="1">5.0000</value_raw>
    <value channel="Available Memory Percent" channelid="2">51 %</value>
    <value_raw channel="Available Memory Percent" channelid="2">50.6000</value_raw>
    <value channel="Available Memory" channelid="3">1.034 MByte</value>
    <value_raw channel="Available Memory" channelid="3">1084643737.6000</value_raw>
    <value channel="Downtime" channelid="-4">0 %</value>
    <value_raw channel="Downtime" channelid="-4">0.0000</value_raw>
    <percentile>100 %</percentile>
    <percentile_raw>0000000000001000.0000</percentile_raw>
    <coverage>100 %</coverage>
    <coverage_raw>0000010000</coverage_raw>
   </item>
   <item>
    <datetime>10.01.2017 00:05:00 - 00:10:00</datetime>
    <datetime_raw>42744.9652777778</datetime_raw>
    <value channel="Health" channelid="0">100 %</value>
    <value_raw channel="Health" channelid="0">100.0000</value_raw>
    <value channel="System CPU Load" channelid="1">5 %</value>
    <value_raw channel="System CPU Load" channelid="1">4.8000</value_raw>
    <value channel="Available Memory Percent" channelid="2">48 %</value>
    <value_raw channel="Available Memory Percent" channelid="2">47.8000</value_raw>
    <value channel="Available Memory" channelid="3">982 MByte</value>
    <value_raw channel="Available Memory" channelid="3">1029293670.4000</value_raw>
    <value channel="Downtime" channelid="-4">0 %</value>
    <value_raw channel="Downtime" channelid="-4">0.0000</value_raw>
    <percentile>100 %</percentile>
    <percentile_raw>0000000000001000.0000</percentile_raw>
    <coverage>100 %</coverage>
    <coverage_raw>0000010000</coverage_raw>
   </item>

Note: Please beware that in the current release (and probably on older versions as well), the readings of the percentile_raw are off by a factor of 10x. This is being looked into.

Best Regards,
Luciano Lingnau [Paessler Support]

Created on Jan 23, 2017 11:34:12 AM by  Luciano Lingnau [Paessler]



Votes:

0

Hi Luciano,

two questions:

  1. The result only get total percentile, how to get separate in & out by API? refer to this
  2. Is possible only get calculate 95 percentile in & out like the report template?

e.g.: i need generate a report only with result of 95th of month from snmp traffic sensor sensor:

interfacepercentile traffic inpercentile traffic outmaximum traffic inmaxium traffic out
traffic 15Mb12Mb8Mb23Mb
traffic 23Mb11Mb7Mb19Mb

Created on Oct 30, 2018 2:01:18 PM

Last change on Nov 1, 2018 10:04:26 AM by  Luciano Lingnau [Paessler]



Votes:

0

Hello Dorian,
thank you for your reply.

This is currently no possible. The reason being that PRTG only calculates the percentile for the sensor's primary channel. Not for individual channels. As a result, obtaining such percentiles is only possible if you instead export the raw values of PRTG and calculate the percentile for the individual channels using a 3rd party tool. Excel for example.

Best Regards,
Luciano Lingnau [Paessler Support]

Created on Nov 1, 2018 10:08:55 AM by  Luciano Lingnau [Paessler]




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.