How to include a Where LIKE in powershell?

Question

What's the trick to include a LIKE in powershell? The same query works fine in SWQL studio.

PS U:\> Get-SwisData $swisdev 'select top 5 interfaces.caption from orion.npm.interfaces'
Local Netflow Source
GigabitEthernet0/0/0 · #LAN ph004-ch3-rta eth1/9
GigabitEthernet0/0/1 · #WAN ph004-ch3-pea
Crypto-Engine0/0/6 - Cr0/0/6
GigabitEthernet0 - Gi0

PS U:\> Get-SwisData $swisdev 'select top 5 interfaces.caption from orion.npm.interfaces where interfaces.caption like 'gig%''
Get-SwisData : Cannot bind parameter 'Parameters'. Cannot convert the "gig%" value of type "System.String" to type "System.Collections.Hashtable".
At line:1 char:113
+ ... ption from orion.npm.interfaces where interfaces.caption like 'gig%''
+ ~~~~~~
+ CategoryInfo : InvalidArgument: (:) [Get-SwisData], ParameterBindingException
+ FullyQualifiedErrorId : CannotConvertArgumentNoMessage,SwisPowerShell.GetSwisData

dan_jagnow · Accepted Answer

Looks like a problem with the quotes. You're using single quotes around the entire query. Any single quotes inside the query need to be repeated to escape them. So you would have two single quotes before and after the string literal of "gig". This should work for you:

Get-SwisData $swisdev 'select top 5 interfaces.caption from orion.npm.interfaces where interfaces.caption like ''gig%'''

Also see the examples at https://github.com/solarwinds/OrionSDK/wiki/PowerShell for how you can pass parameters to those queries.

How to include a Where LIKE in powershell?

Top Replies