count number of rows matching in oid ?

RouterOS The Dude
1

Hi,

I want to count the number of dhcp leases in ROS,
for now I use

array_find(oid_column(“1.3.6.1.2.1.9999.1.1.6.4.1.4”),“dynamic (2)”)

but array_find only returns the number of the first row in the array where it finds “dynamic (2)”.
So, great to find IF there are any dynamic leases …
It returns 8 here because that is the 1st row which matches.
BUT I want to count the number of rows which contain “dynamic (2)”

any suggestions ?

2

You might want to know that the OID .1.3.6.1.4.1.14988.1.1.6.1.0 (MIKROTIK-MIB::mtxrDHCPLeaseCount.0) directly returns the total number of leases.

3

That wil give me the total number, including the expired … I want the total for active static and active dynamic

4

It does not include the expired leases. But it does include the static ones.

5

That is strange, it does here :

snmpwalk -v2c -c public -On mt .1.3.6.1.4.1.14988.1.1.6.1
.1.3.6.1.4.1.14988.1.1.6.1.0 = Gauge32: 66

snmpwalk -v2c -c public -On mt .1.3.6.1.2.1.9999.1.1.6.4.1.4 | wc -l
66

the array .1.3.6.1.2.1.9999.1.1.6.4.1.4 includes the expired static leases

static :
snmpwalk -v2c -c public -On mt .1.3.6.1.2.1.9999.1.1.6.4.1.4 | grep INTEGER:\ 1 | wc -l
31

dynamic :
snmpwalk -v2c -c public -On mt .1.3.6.1.2.1.9999.1.1.6.4.1.4 | grep INTEGER:\ 2 | wc -l
1

expired :
snmpwalk -v2c -c public -On mt .1.3.6.1.2.1.9999.1.1.6.4.1.4 | grep INTEGER:\ 3 | wc -l
34

6

Ah expired static leases, I did not think of those (we don’t have them as static leases are only used for equipment that is always on).
For sure it does not include expired dynamic leases.

7

tnx for thinking with me …

any other suggestions ?