Hi there,
We have lately come accross a limitation in the WCS search function about historical client IP address data.
Background information {
We have been trying to identify a specific wireless client by a its dynamic IP address at a given time.
The DHCP lease time for the scope is set to 2 hours.
The client connected to the wireless network multiple times throughout a day; getting three different IP addresses assigned.
WCS version used is 7.0.230.0.
}
Now, if we try to search for any of these three IP addresses, that is not the latest IP address the client got assigned, no result is provided.
There is no difference if using the Simple or Advanced Search.
By running a direct query against the solidDB of the WCS we could then identify the MAC address of the client.
select C.CLIENTUSERNAME, C.CLIENTMACADDRESS, C.CLIENTIPADDRESS,
C.SSID, C.PROFILENAME, C.SESSIONSTARTTIME,
C.SESSIONTIME
from
WCSDB.MODB.CLIENTSESSIONINFO C
where
C.CLIENTIPADDRESS = '172.26.123.4' and
C.SESSIONSTARTTIME > 1352160000000;
Trying to search with the MAC address of the client, now yields a result.
As can be seen below, the IP address of the client altered over time, being 172.26.123.4 not the latest.
Is this an expected behavior or considered a bug?
(At least we could not find any known one using the bug toolkit).
We would expect to not only be able to search for the latest IP address of a client but any that exists in the DB.
Any comments are appreciated!
Thank you and best regards,
---
Stephan