cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

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

Version history
Revision #:
1 of 1
Last update:
‎06-24-2015 09:06 AM
Updated by: