[stork-users] DHCPv4 and V6 stats not displayed properly

[Slawek Figiel]

Hello Bertrand,

I'm pretty sure that the utilization is displayed properly.

You attached the below statistic output from Kea:

```

[ { "arguments": { "result-set": { "columns": [ "subnet-id", 
"total-addresses", "cumulative-assigned-addresses", 
"assigned-addresses", "declined-addresses" ],
"rows": [ [ 200, 6, 5, 0, 0 ], [ 201, 15, 0, 0, 0 ] ], "timestamp": 
"2023-06-13 07:36:46.830289" } }, "result": 0, "text": 
"stat-lease4-get[all subnets]: 2 rows found" } ]

```

It shows the subnet 200 has:

- 6 total addresses
- 5 cumulative assigned addresses
- 0 assigned addresses
- 0 declined addresses

The "cumulative assigned addresses" term means (from Kea ARM):

 > Cumulative number of addresses that have been assigned
 > since server startup. It is incremented each time an address
 > is assigned and is not reset when the server is reconfigured.

The current (momentary) state of the DHCP server is described by the 
"total-addresses", "assigned-addresses", and "declined-addresses".
The utilization is calculated as: ("assigned-addresses" / 
"total-addresses") * 100% .

The number of assigned addresses is zero in all subnets from your 
screenshots. The expected utilization is zero percent in every case.

Hint: you can display the raw subnet statistic values by hovering a 
mouse pointer on the subnet bar.

Is my explanation sufficient for you? Do you agree the utilization 
presented by Stork is correct?

Regards,
Slawek

On 13/06/2023 10:51, Buclin, Bertrand wrote:
>
> HI Stork team,
>
> Looks like the Stork server GUI (version 1.10 and 1.11, at least; not 
> checked on prior versions, agent version 1.10 and 1.11 too showing the 
> same behavior; KEA 2.2) is not displaying properly the utilization of 
> IPv4 subnets. The Kea Control Agent is showing its receiving and 
> responding to the API call properly (log entries trimmed to relevant 
> stuff only):
>
> DEBUG [kea-ctrl-agent.http/594970.140579578214272] 
> HTTP_CLIENT_REQUEST_RECEIVED_DETAILS detailed information about 
> well-formed request
>
> received from
>
> …
>
> {"command":"stat-lease4-get","service":["dhcp4"]}
>
> …
>
> DEBUG [kea-ctrl-agent.http/594970.140579578214272] 
> HTTP_SERVER_RESPONSE_SEND_DETAILS detailed information about response 
> sent to
>
> …
>
> [ { "arguments": { "result-set": { "columns": [ "subnet-id", 
> "total-addresses", "cumulative-assigned-addresses", 
> "assigned-addresses", "declined-addresses" ],
>
> "rows": [ [ 200, 6, 5, 0, 0 ], [ 201, 15, 0, 0, 0 ] ], "timestamp": 
> "2023-06-13 07:36:46.830289" } }, "result": 0, "text": 
> "stat-lease4-get[all subnets]: 2 row
>
> s found" } ]
>
> But the Stork GUI shows:
>
> A screenshot of a calculator Description automatically generated with 
> medium confidence
>
> It is showing the subnets (200 and 201), with the right number of 
> total addresses, but it is not displaying the 
> cumulative-assigned-addresses (should be 5 for the top subnet, and 83% 
> utilization).
>
> On Ipv6 subnets, I get something similar:
>
> {"command":"stat-lease6-get","service":["dhcp6"]}
>
> 2023-06-13 08:34:55.149 
> INFO[kea-ctrl-agent.auth/594970.140579578214272] 
> HTTP_CLIENT_REQUEST_AUTHORIZED received HTTP request authorized for 
> 'stork-agent'
>
> 2023-06-13 08:34:55.149 
> INFO[kea-ctrl-agent.commands/594970.140579578214272] COMMAND_RECEIVED 
> Received command 'stat-lease6-get'
>
> …
>
> 2023-06-13 08:34:55.241 DEBUG 
> [kea-ctrl-agent.http/594970.140579578214272] 
> HTTP_SERVER_RESPONSE_SEND_DETAILS detailed information about response sent
>
> …
>
> [ { "arguments": { "result-set": { "columns": [ "subnet-id", 
> "total-nas", "cumulative-assigned-nas", "assigned-nas", 
> "declined-nas", "total-pds", "cumulative-a
>
> ssigned-pds", "assigned-pds" ], "rows": [ [ 200, 281474976710656, 0, 
> 0, 0, 256, 0, 0 ], [ 201, 281474976710656, 55, 0, 0, 0, 0, 0 ], [ 202, 
> 281474976710656, 0,
>
> 0, 0, 0, 0, 0 ], [ 999901, 281474976710656, 0, 0, 0, 0, 0, 0 ] ], 
> "timestamp": "2023-06-13 08:34:55.240818" } }, "result": 0, "text": 
> "stat-lease6-get[all sub
>
> nets]: 4 rows found" } ]
>
> And Stork GUI shows :
>
> A screenshot of a calculator Description automatically generated with 
> medium confidence
>
> It should show the 55 addresses assigned in the bottom subnet. It can 
> show the 256 PD prefixes available in the top one, so clearly, it is 
> receiving the API response and doing something with it.
>
> *Bertrand Buclin*
>
> AT&T
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/stork-users/attachments/20230613/f33387f3/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10333 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/stork-users/attachments/20230613/f33387f3/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 26568 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/stork-users/attachments/20230613/f33387f3/attachment-0003.png>