Hi,
Has anyone created such a report, that includes all the ip addresses currently and historically assigned to a host?
I would love to get a copy of it
Best regards,
Deltona
Use custom report in IPAM for this requirement,
1. Go to Orion Home Page and select the sub tab 'Reports'.
2. Click 'Manage Reports' in the 'Reports' page.
3. Click 'Create New Report' in ''Manage Reports' page.
4. Select 'Unknown' in the group by combo in the 'Add Content' screen and select the 'Custom Query' option and proceed.
5. In Add Report screen, Enter the mandatory details and click 'Edit Resource' of the Custom Query.
6. Paste the query (mentioned below) in the 'Custom SWQL Query' section. Then submit the screen.
7. Complete the 'Add report Wizard'
select FromValue as MAC, IPAddress from IPAM.IPHistory where HistoryType = 'MAC' and FromValue != '' and FromValue in (SELECT MAC
FROM IPAM.IPNode where MAC is not null)
union
(select IntoValue as MAC, IPAddress from IPAM.IPHistory where HistoryType = 'MAC' and IntoValue != '' and IntoValue in (SELECT MAC
FROM IPAM.IPNode where MAC is not null))
order by MAC
Hope this solves.
Thanks,
Venu
Thanks Venu but I think it's best you share this report in another discussion as it doesn't apply to the report requested here.
I am looking for a report that includes all the ip addresses currently and historically assigned to a host (Node/Caption).
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.