This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

IP Address history to MAC addresses report

Just for a case if somebody needs to see what MAC addresses were assigned to the single IP address over the time in UDT. Go and create this custom SQL report:

SELECT Distinct UDT_IPHistory.IPAddress, udt_endpoints.MACAddress

  FROM [SolarWindsOrionNPM].[dbo].[UDT_IPAddress] as UDT_IPHistory LEFT Join [SolarWindsOrionNPM].[dbo].[UDT_Endpoint] udt_endpoints ON UDT_IPHistory.[EndpointID] = udt_endpoints.EndpointID group by UDT_IPHistory.IPAddress, udt_endpoints.MACAddress order by UDT_IPHistory.IPAddress ASC

udt_report.png