IP Address history to MAC addresses report

Version 1

    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