I am getting weird problem. On running the query on 64 bit powershell, it is running successfully, However when i am running the same on x86 query does not gives any output.
what could be the problem ?
X86 query
$query = 'SELECT TOP '+ $selectCount +' I.Status,I.DisplayName FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.VLAN = '''+$VlanID +''''
$availableIp = Get-SwisData -SwisConnection $swis -Query $query
x64 Query
$query = 'SELECT TOP '+ $selectCount +' I.Status,I.DisplayName FROM IPAM.IPNode I WHERE Status=2 AND I.Subnet.VLAN = '''+$VlanID +''''
$availableIp = Get-SwisData -SwisConnection $swis -Query $query