LastSeen in User Device Tracker

Question

Hi all,

i need for my costumized report the LastSeen from the UDT Search.

The LastSeen from sql-tables udt_ipadress udt_endpoint is different of the UDT Search.

From which sql-table is the LastSeen of the UDT Search.

Thanks in advanced

Bedrich.Michalek · Accepted Answer

Hi,

this value comes from two tables:

- [UDT_Switch].[LastSuccessfulScan] for layer2 data

- [UDT_Router].[LastSuccessfulScan] for layer3 data

In the search grid you can distinguish layer2/layer3 by the (MAC) and (IP) next to the LastSeen/FirstSeen values.