Re: [Perfparse-users] Data in Database

[Yves <yme...@pe...>]

> I use the plugin check_icmp
> which output look like this:
>
> nagios@rzvlabwks:/usr/local/nagor/nagios/libexec> ./check_icmp -H jholl=
e
> OK - jholle: rta 0.25 ms, lost 0%|rta=3D0.25ms;200;500;; pl=3D0%;60;80;=
;
>
> it's ok.
> But the Database look so:
>
> 42684 | jholle    | Ping                | rta    | 2005-02-28 08:38:29 =
|
> 0 |   200 |      500 |     0 |
> | 42685 | jholle    | Ping                | pl     | 2005-02-28 08:38:2=
9 |
>   0 |    40 |       80 |     0 |
>
> So for the time is always a 0 value. Is this a known problem or what do=
 I
> wrong?


Anybody to help ?
Anybody who can check if this can be the storage format of the database t=
hat does not
allow float values ?

> Another question is how many data is stored into my database. Is it def=
ined
> how many data is stored? When yes where?

This is not defined anywhere.
However, you can use SQL requests like this:
select count(*) from perfdata_host
select count(*) from perfdata_service_bin
select count(*) from perfdata_service_metric
... and so on

Yves

--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://www.perfparse.org/                          -