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

GetFirstAvailableIp Not working in 4.7

We were running IPAM version 4.5 and the following command to obtain the next available IP address for a subnet; Invoke-SwisVerb $swis IPAM.SubnetManagement GetFirstAvailableIp @.

We upgraded to version 4.7 and we have two issues; 1) Domain accounts will not authenticate/run APIs. We have to use local orion accounts to progress. 2) Once a local account is used, the above command is returning....

Invoke-SwisVerb : Incorrect syntax near 's'.

Unclosed quotation mark after the character string '

UNION ALL

SELECT obj.[GroupId],obj.[ParentId],obj.[GroupType],obj.[Address],obj.[AddressN],obj.[AddressEnd],obj.[AddressMask],obj.[CIDR],obj.[FriendlyName],obj.[Comments],obj.[VLA

N],obj.[Location],obj.[LastDiscovery],obj.[Status],obj.[ScanInterval],obj.[TransientPeriod],obj.[RetainUserData],obj.[NodeExpungeInterval],obj.[UsedCount],obj.[Available

Count],obj.[ReservedCount],obj.[TransientCount],obj.[DisableAutoScanning],obj.[TotalCount],obj.[PercentUsed],obj.[HasLicenceOverflow],obj.[DisableNeighborScanning],obj.[

NeighborScanAddress],obj.[NeighborScanInterval],obj.[DnsZoneId],obj.[EngineId],obj.[ClusterId] FROM [IPAM_Group] AS obj

INNER JOIN GroupTree ON obj.ParentId = GroupTree.GroupId

)

SELECT * FROM GroupTree

At C:\Users\admin-jcrowe\Downloads\getIP.ps1:4 char:10

+ $NEWIP = Invoke-SwisVerb $swis IPAM.SubnetManagement GetFirstAvailableIp @("10.2 ...

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

+ CategoryInfo : InvalidOperation: (:) [Invoke-SwisVerb], FaultException`1

+ FullyQualifiedErrorId : SwisError,SwisPowerShell.InvokeSwisVerb

Find more posts tagged with

Accepted answers

All comments

maryan.dmytriv

try looking into C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log for more hints about what went wrong.

I just ran command with Orion admin account and received result successfully

PS C:\WINDOWS\system32> Invoke-SwisVerb $swis IPAM.SubnetManagement GetFirstAvailableIp @("20.10.6.0", "24")

xmlns #text

----- -----

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

jbcrow3

2018-10-04 09:18:58,008 [90] ERROR SolarWinds.InformationService.Core.InformationService - SwisPowerShell (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.Invoke

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 's'.

Unclosed quotation mark after the character string '

UNION ALL

SELECT obj.[GroupId],obj.[ParentId],obj.[GroupType],obj.[Address],obj.[AddressN],obj.[AddressEnd],obj.[AddressMask],obj.[CIDR],obj.[FriendlyName],obj.[Comments],obj.[VLAN],obj.[Location],obj.[LastDiscovery],obj.[Status],obj.[ScanInterval],obj.[TransientPeriod],obj.[RetainUserData],obj.[NodeExpungeInterval],obj.[UsedCount],obj.[AvailableCount],obj.[ReservedCount],obj.[TransientCount],obj.[DisableAutoScanning],obj.[TotalCount],obj.[PercentUsed],obj.[HasLicenceOverflow],obj.[DisableNeighborScanning],obj.[NeighborScanAddress],obj.[NeighborScanInterval],obj.[DnsZoneId],obj.[EngineId],obj.[ClusterId] FROM [IPAM_Group] AS obj

INNER JOIN GroupTree ON obj.ParentId = GroupTree.GroupId

)

SELECT * FROM GroupTree

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandBehavior behavior)

at SolarWinds.IPAM.Storage.DAL.GroupNodeDAL.FindGroupsInTree(String friendlyName, String address, String rawCidr, String mask)

at SolarWinds.Data.Providers.Orion.IPAM.V3.Verbs.SubnetManagement.GetFirstAvailableIp(String subnetAddress, String subnetCidr, String friendlyName)

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at SolarWinds.InformationService.Verb.VerbExecutor.ReflectionInvocation(Object hostInstance, Object[] parameters)

at SolarWinds.InformationService.Verb.VerbExecutorContext.Invoke()

at SolarWinds.InformationService.Core.InformationService.Invoke[T](String entity, String verb, Action`1 setupParameters, Func`2 extractReturnValue)

ClientConnectionId:8d764b10-aa51-4ed8-9ede-7661d127e6c8

Error Number:102,State:1,Class:15