6 Replies Latest reply on Jul 17, 2014 7:26 AM by bluefunelemental

    Get-Swisdata to return all properties.

    jrremillard

      Hi

       

      I am trying to get back all the properties that I am able to get data from. Is there a select query to do this?

       

      currently I am doing

      Get-SwisData $swis "SELECT IPAddress, Caption, Status FROM Orion.Nodes"

       

      This returns a subset of data. I am looking for all the properties that I can get data from.

       

      Thank you

        • Re: Get-Swisdata to return all properties.
          fholzapfel

          Hi,

           

          start your Database Manager on your Win 2012 System.

          Add Default Server (only click on it) and after that scroll down to your table "Nodes" and with a right click you can display the Details of the table.

          visa.PNG

           

          in the columns you can see all properties.

           

          Kind regards,

          flo

          1 of 1 people found this helpful
          • Re: Get-Swisdata to return all properties.
            jrremillard

            I have pulled back all the data that the parmeters but do not find one thing I am looking for.

             

            Within the ip management console I can see under the "Status" weather an ip is used, available, reserved, or transient. I do not get this data under the status when I run the query. Is this in a different "NODE"

             

            I want to see the IPs that are reserved so we can put in the proper server information we are trying to clean up the ip manager to get the data associated with the proper servers and remove all the stale info.

             

            Thank you all for your help.