IP Address Query

You may end up having to spend some time playing with it but the newest versions of swql have substring and replace functions, perhaps you can rig something up like (replace(i.ipaddress,'%.',''))+0 to drop everything but the last octet and then convert it to an int.  I'm not entirely sure the replace function works with wildcards though and if so will it only replace one octet or everything to the left of the final period. Let us know if you get any success with that or some up with a different work around.

Here is a sample how you can achive your goal

$startIp = '20.20.20.14'

$startIpParts = $startIp.Split('.')

$startIpHex = [String]::Format("{0:x2}{1:x2}{2:x2}{3:x2}-0000-0000-0000-000000000000", [convert]::ToInt32($startIpParts[3]), [convert]::ToInt32($startIpParts[2]), [convert]::ToInt32($startIpParts[1]), [convert]::ToInt32($startIpParts[0]))

$endIp = '20.20.20.125'

$endIpParts = $startIp.Split('.')

$endIpHex = [String]::Format("{0:x2}{1:x2}{2:x2}{3:x2}-0000-0000-0000-000000000000", [convert]::ToInt32($endIpParts[3]), [convert]::ToInt32($endIpParts[2]), [convert]::ToInt32($endIpParts[1]), [convert]::ToInt32($endIpParts[0]))

$query = 'SELECT TOP 1 I.IpAddress FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.DisplayName = ''Morden'' AND IPAddressN >= ''' + $startIpHex + ''' AND IPAddressN <= ''' + $endIpHex + ''''

Get-SwisData $swis $query

Good idea, makes sense to get around the limitations of SWQL itself using the features of your scripting language.

mesverrum, do you need any help with topic above or it can be closed?