How to Run a SQL Query in Database Manager

This article teaches users how to run an SQL query using the SolarWinds Platform Database Manager.

1.  Open a Remote Desktop connection  to the SolarWinds Server.
2. Click on Database Manager in the SolarWinds Platform start menu group
3. Click Add default server.
    
4. Expand the SolarWinds database.
5. Right-click and enter New Query.
   
6. Enter the SQL query you want to run. Example:
    

-- 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.

SELECT TOP 1000 * FROM [dbo].[Websites]

1. Click Execute Query.

Edit information in the database

• Click the Enable table editing button
• Double-click the field you wish to edit
• Type new data in then hit enter
• Click the Execute query button to make sure that the updated data was saved
• Click the Enable table editing button to disable editing

Export the result to CSV