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
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.