16 Replies Latest reply on Oct 22, 2014 1:07 PM by jbiggley

    SWQL Query tool

    uidzer0

      Can i attach the SWQL Query tool to Virtualization Manager?

       

      If not, what is the process to get attached to the database for queries?

        • Re: SWQL Query tool
          lukas.cerny

          Hello,

           

          yes starting with Virtualization Manager 6.0 provides a SWIS service to which you can connect using the SWQL Studio. However, be aware that since support for this was added mainly for purpose of integration with SAM and NPM it was tuned up for that specific purpose. This means that you may not be able to access all the data that you would like to this way.

           

          Connecting to the Virtualization Manager is a little bit different from connecting to the Orion SWIS:

           

          1. You need to specify full endpoint address in the following format:
            https://[VMan.IP.address.or.hostname]:443/swvm/services/InformationService
          2. Then for the Server Type select: Java over HTTP
          3. You can then log in using Virtualization Manager credentials

           

          Following is the screenshot of the log in dialog:

          jswis-auth.png

           

          Now I suppose that you have default Virtualization Manager installation which uses self signed certificate for the HTTPS port, if that is the case you will see another dialog informing you about certificate issue. When you see this dialog just hit Yes.

           

          jswis-cert.png

           

          After that you should be able to see and query some of the Virtualization Manager entities:

           

          jswis-entitites.png

          Let me know if you have any questions.

          1 of 1 people found this helpful