Invoke-SwisVerb Access Denied

You need to authenticate first. Try using this command to authenticate before using other commands.

Add-PSSnapin SwisSnapin

$swis = Connect-Swis -host YOURORIONSERVERNAME -Trusted

Wow WTH....I tried all of this except for the - Trusted....it worked except I got this:

xmlns                                                                          #text

-----                                                                          -----

http://schemas.datacontract.org/2004/07/SolarWinds.InformationService.Contract 10.8.63.7

But I need JUST the IP returned

Interesting. That output looks like you get an XML element returned. Which is what you expect from the Invoke-SwisVerb PowerShell · solarwinds/OrionSDK Wiki · GitHub

I ran the same script using Get-SWISDATA and get a string back.

Import-Module SwisPowerShell

Add-PSSnapin SwisSnapin

$swis = Connect-Swis -host <myhost name> -Trusted

$IP= Get-SwisData $swis 'SELECT TOP 1 I.IpAddress FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = ''Muscatine Datacenter'''

PS> Get-Member -InputObject $IP

TypeName: System.String

PS> $IP

10.1.190.54

I run this from my PC and connect to my SolarWinds primary poller. What does your Invoke-SwisVerb command look like?

Yes if I use SWQL commands I do get a string....however my goal is to perform the following

1. Get the next available IP (within a range like between 10.10.10.30 and 10.10.10.230)

2. Set it to USED

3. Write The Hostname

All that can be done with the cmdlets (https://github.com/solarwinds/OrionSDK/wiki/IPAM-API)

My understanding is that SWQL only reads command, you have to use the Invoke commands or CRUD to write

Add-PSSnapin SwisSnapin

$swis = Connect-Swis -host fooweb.foobar.com -Trusted

$result = Invoke-SwisVerb -SwisConnection $Swis -EntityName IPAM.SubnetManagement -Verb GetFirstAvailableIp -Arguments @("10.1.190.0", "23")

$IP = $result.Innertext

# WANT TO GET THE NODEID

$Select = "SELECT I.IPNodeID,I.IPAddress FROM IPAM.IPNode I WHERE I.IPAddress = '" + $IP + "'"

$R2 = Get-SwisData $swis $Select

$R2 | FT

Invoke-SwisVerb $swis IPAM.SubnetManagement ChangeIPStatus  @($IP, "Used")

$URI = 'swis://fooweb.foobar.com/Orion/IPAM.IPNode/IpNodeId=' + $R2.IPNodeID

# Change the property you want I just used Alias because it was easy

Set-SwisObject $swis -Uri $URI -Properties @{ Alias = 'Reset Me' }

sorry...I meant get the first available IP ONLY within that range. They dont want us to use anything below .30 or above .230. Is that possible. I can have them set those to reserved in IPAM, but that would not be preferred if possible

Also that last line in that script returns this for me even if I use Alias or any other of the listed properties:

Set-SwisObject : Entity IPAM.IPNode does not contain requested property HOSTNAME

At line:1 char:1

+ Set-SwisObject $swis -Uri $URI -Properties @{ HOSTNAME = 'HostnameTes ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : InvalidOperation: (:) [Set-SwisObject], FaultException`1

    + FullyQualifiedErrorId : SwisError,SwisPowerShell.SetSwisObject

It only seems to work if you use it to set and change custom properties....it doesnt appear that the API has access to Description, Alias...etc.

Thanks!

I can do this Get-SwisData $swis 'SELECT TOP 1 I.IpAddress FROM IPAM.IPNode I WHERE Where IpAddress >30 AND Status=2 AND I.Subnet.DisplayName = ''10.8.63.0/24'''

But I need the first available between 10.8.63.30 - 10.8.63.230

I am confused by a couple of things. First, the IPAddress is stored as a varchar in the IPAM.Nodes table. Your WHERE clause is trying to compare it to an INT. That should not work at all. Second, I am not aware that IPAM will let you define random IPv4 ranges. You have to specify a standard mask. The IP addresses you are looking for do not break across IPv4 subnets nicely.

So the only way I can think of is to get the whole set of available IP addresses in the 10.8.63.0/24 range and then cycle thru them. You could convert the last element to and INT and compare them so you get into the range.

I am still looking into modifying the hostname issue.

Oops yeah that was the wrong command....and you are right that does NOT work at all =)

I meant to paste $IP= Get-SwisData $swis 'SELECT TOP 1 I.IpAddress FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = ''10.8.63.0/24'' .This will pull the first available...

Also if you change the above command to 'SELECT', it will return ALL the address in the subnet but it returns like 50 for EACH one....really bizarre.

.I also did something like this:

Get-SwisData $swis 'SELECT  I.IpAddress FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayNa

me = ''10.8.63.0/24''' | Where {$_.Split(".")[3] -ge 30 -and $_.Split(".")[3] -le 40}

That worked to a degree, but still returns too many IPs, I need the FIRST one in that range.

I figured out the hostname part. If you use the ReverseDNS cmdlet, it actually write the hostname in there as long as the attribute is not marked as available, it has to marked as used.

So if you are not running the release candidate 4.6 of IPAM there is an issue: API returns lots of identical rows when running "SELECT [...] FROM IPAM.Subnet WHERE [...]" · Issue #52 · solarwinds/Ori…

If you use a SELECT DISTINCT I.IPADDRESSS.... you should get your numbers.