2 Replies Latest reply on Dec 15, 2016 8:17 AM by Mike Lomax

    Get-SwisData Statement works correctly in PS Command window but not in same ISE Script window

    Mike Lomax

      Very simple test query to get a list of nodes that start with a certain string.  Here is the code:

       

      Add-PSSnapin SwisSnapIn

       

      $DataPath = '<path>'

      $OrnUsr = '<username>'

      $OrnSvr = '<srvrname>'

       

      $OrnCredFile = "$DataPath\User$OrnUsr.txt"

      $OrnCreds = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $OrnUsr, (Get-Content $OrnCredFile | ConvertTo-SecureString)

       

      $SwisCnctn = Connect-Swis -Hostname $OrnSvr -Credential $OrnCreds

      $Query = "SELECT NodeID, Caption from Orion.Nodes WHERE Caption LIKE 'ott-sw-p%'"

      $QResults = Get-SwisData $SwisCnctn $Query

       

      Write-Host $QResults

       

      Obviously I replaced some variables with placeholders ("<>").

       

      I can copy "Get-SwisData  $SwisCnctn $Query" to the Command window and it returns the expected results:

      But when I execute from the Script window I get the following:

       

      I have looked at several samples and I believe I have my script structure correct.  So why the difference and what can I do to fix it?

       

      Also wondering why the command result above is not left justified which might be related.

       

       

      THANKS

       

      Mike