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

[Christopher Farrar]

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?

[Jacky_Mahadab]

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

[Anon Anon]

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

 

select * from servers;

 

or

 

select server_name, server_ip from servers;

[Christopher Farrar]

That is exactly what I needed.  Thank you!