cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

394
Views
0
Helpful
0
Replies
Highlighted

WCS client search - cannot search for historical client IP address data

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.

1.PNG

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;

2.PNG

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.

3.PNG

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

Everyone's tags (4)
CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards