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 get free IP Address

Hi Team,

We try to get the free IP’s details from IPAM and we have run the below command, but it’s not working and we are getting below error need your help on this.

$hostname = "10.218.x.x"

$username =

$password =

$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $username, $password

$swis = Connect-Swis -host $hostname -Credential $cred

Get-SwisData $swis -Query 'SELECT TOP 1 I.Status, I.DisplayName FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = ''APR1*'''

Invoke-SwisVerb $swis IPAM.SubnetManagement GetFirstAvailableIp @("199.10.1.0", "24")

Find more posts tagged with

Accepted answers

All comments

dan_jagnow

The options for connecting to SWIS via PowerShell are described at Connecting to SWIS · solarwinds/OrionSDK Wiki · GitHub . For details about different ways to create a PSCredential object, see also https://adamtheautomator.com/powershell-get-credential/ .

jayakumarhs

Thanks Dan, Now i am able to login. But if i try below commands i am not getting any output. even if there are many free IPSs. Could you please let us know Whether command needs any correction..

Get-SwisData $swis 'SELECT TOP 1 I.Status, I.DisplayName FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = @subnet'; @{subnet="AN1"}

Get-SwisData $swis -Query 'SELECT TOP 1 I.Status, I.DisplayName FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = ''AN1'''

dan_jagnow

I don't see anything obviously wrong with the format of your query. Have you tried removing the WHERE clause to see if you get data back? You may also find it helpful to install SWQL Studio (https://github.com/solarwinds/OrionSDK/releases), which makes it easier to explore the data that Orion has to offer. You can test your queries there before running them via PowerShell. The IPAM documentation at https://github.com/solarwinds/OrionSDK/wiki/IPAM-API may also be a useful reference.