Identify Additional Web Servers (AWS) in SolarWinds Platform environment via SQL

In some environments, SolarWinds Platform may have a large number of servers in the environment, making it difficult to determine which ones are Additional Pollers, Additional Web Servers, or Main Pollers.

Note the following for each query below:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

1. Connect to the SolarWinds Platform Main Polling Engine.
2. Open Database Manager from the SolarWinds Platform folder of the start menu.
3. Select Add Orion Server and expand the SQL server and database in bold.
4. Right-click the database and select New Query.
5. Paste one of the below queries in the window on the right and select Execute query to display the servers for each type:

Additional Web Servers:

Select * from Orionservers 
where servertype= 'AdditionalWebsite'

Additional Poller Engine:

Select * from OrionServers 
where servertype= 'AdditionalPoller'

Main Poller:

Select * from OrionServers 
where servertype= 'MainPoller'