Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

IPAM Report to display all ip addresses per host

Deltona

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

Find more posts tagged with

Accepted answers

All comments

michal.hrncirik

Hi Deltona,

just to make sure, the report should show only IP addresses that were ever assigned to some MAC address, correct?

Deltona

Hi Michal,

IP addresses assigned to the host, as the host could change IP. But now that you mention it, I would also like to see this report display IP address assignments to a MAC.

thanks!

michal.hrncirik

ok, in the mean time (looking for custom SQL). could you just tell me who is the consumer of this report (why you need that)?

thanks,

Michal

Deltona

It will be used by the auditing department (server guys).

venugopal.natarajan

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

Deltona

Hi there,

Thanks for joining this discussion.

What exactly am I supposed to get from the report apart from MAC address and IP address?

Thanks

venugopal.natarajan

Hi Deltona,

The report will display IP address assignments to a MAC.

Thanks,

Venu

Deltona

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

crypto_root

Hello there, any news about that report?

Deltona

Nope

BUMP!

michal.hrncirik

Hi Deltona,

I apologize for delay on this, team is aware of this customization but now finishing latest version of IPAM release, we will re-focus on this report soon. please, stay tuned.

Deltona

Hi Michal,

Any chance this report can be made come new IPAM release?