Release Automation

Expand all | Collapse all

Is There A SQL Table That Lists All Agents in the RA Environment?

Jump to Best Answer
  • 1.  Is There A SQL Table That Lists All Agents in the RA Environment?

    Posted 08-21-2015 01:00 PM

    I need to get a listing of all RA agents in my environment and copy/ paste it into an excel sheet.  I cannot seem to find an easy way to do this.  If I am missing something then please let me know, if not then is there a SQL table that I can query to get these results?



  • 2.  Re: Is There A SQL Table That Lists All Agents in the RA Environment?

    Posted 08-21-2015 01:30 PM

    You can use SOAP call "getEnvironmentServers" to get this info.

    e.g

    <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:mod="http://model.api.dataservices.server.platform.nolio.com/">

       <soap:Header/>

       <soap:Body>

          <mod:getEnvironmentServers>

             <!--Optional:-->

             <mod:username>superuser</mod:username>

             <!--Optional:-->

             <mod:password>suser</mod:password>

             <!--Optional:-->

             <mod:appName>cars</mod:appName>

             <!--Optional:-->

             <mod:envName>QA</mod:envName>

          </mod:getEnvironmentServers>

       </soap:Body>

    </soap:Envelope>

     

    output

     

    <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

       <soap:Body>

          <ns1:getEnvironmentServersResponse xmlns:ns1="http://model.api.dataservices.server.platform.nolio.com/">

             <ns1:return>

                <ns2:EnvironmentServerWS xmlns:ns2="http://dto.webservice.model.api.dataservices.server.platform.nolio.com">

                   <ns2:mappedServerHostName xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>

                   <ns2:mappedServerIp xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>

                   <ns2:serverTypeName>Database Server</ns2:serverTypeName>

                </ns2:EnvironmentServerWS>

                <ns2:EnvironmentServerWS xmlns:ns2="http://dto.webservice.model.api.dataservices.server.platform.nolio.com">

                   <ns2:mappedServerHostName>SRV553</ns2:mappedServerHostName>

                   <ns2:mappedServerIp>127.0.0.1</ns2:mappedServerIp>

                   <ns2:serverTypeName>Application Server</ns2:serverTypeName>

                </ns2:EnvironmentServerWS>

                <ns2:EnvironmentServerWS xmlns:ns2="http://dto.webservice.model.api.dataservices.server.platform.nolio.com">

                   <ns2:mappedServerHostName>SRV552</ns2:mappedServerHostName>

                   <ns2:mappedServerIp>127.0.0.1</ns2:mappedServerIp>

                   <ns2:serverTypeName>Web Server</ns2:serverTypeName>

                </ns2:EnvironmentServerWS>

                <ns2:EnvironmentServerWS xmlns:ns2="http://dto.webservice.model.api.dataservices.server.platform.nolio.com">

                   <ns2:mappedServerHostName>SRV551</ns2:mappedServerHostName>

                   <ns2:mappedServerIp>127.0.0.1</ns2:mappedServerIp>

                   <ns2:serverTypeName>Utility</ns2:serverTypeName>

                </ns2:EnvironmentServerWS>

             </ns1:return>

          </ns1:getEnvironmentServersResponse>

       </soap:Body>

    </soap:Envelope>

     

    Of course you can build sql query to get the info directly from the DB

    Thanks

    Jacky



  • 3.  Re: Is There A SQL Table That Lists All Agents in the RA Environment?
    Best Answer

    Posted 08-21-2015 04:31 PM

    I believe the SQL from the DB you are looking for is :

     

    select * from servers;

     

    or

     

    select server_name, server_ip from servers;



  • 4.  Re: Is There A SQL Table That Lists All Agents in the RA Environment?

    Posted 08-24-2015 09:39 AM

    That is exactly what I needed.  Thank you!