Documentation forSolarWinds Platform Self-Hosted

View database details in the Database Manager

This topic applies to all SolarWinds Platform products.

With the Database Manager, you can review the database details, view details for individual database tables, and edit database fields.

Add your SQL Server

When you open the Database Manager, you need to specify the SQL server at first. If you have not designated a database for your SolarWinds Platform product, add a SQL server.

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. To add a default server, click Add Default Server.
  3. To select a server:
    1. Click Add Server.
    2. Select or enter the SQL Server instance you want to use in the server/instance format.
    3. Select the appropriate authentication method, enter your credentials, and click Connect.

    You can now see the server and associated databases in the tree structure of the Database Manager.

View database details

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. If the SQL Server hosting your SolarWinds Platform database is not listed in the left pane, add the SQL Server hosting the database.
  3. Click + in the left pane to expand the SQL Server hosting your SolarWinds Platform database, and right-click the database.

    The default database name is SolarWindsOrion.

  4. Click Database Details.
    • The Properties tab shows general statistics and descriptions of the selected database.
    • The Tables tab lists the tables and their respective sizes.
    • If you have not yet made a backup of the database, the Last Backup field on the Properties tab is blank.

View a table details

You can view the Table details for a selected database including the property, column, and index information through the Database Manager.

You can also query the selected table directly from the Table Details window for specific or additional data.

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. If the SQL Server hosting your SolarWinds Platform database is not listed in the left pane, add the SQL Server hosting the database.
  3. Expand the SQL Server hosting your SolarWinds Platform database in the left pane, and expand the SolarWinds Platform database.

    The default database name is SolarWinds Orion.

  4. From the tables displayed for the database, right‑click any table to view the Table Details.
    • The Properties tab includes general statistics relating to the selected table size and creation date.
    • The Columns tab lists keys, column names, size and data types in the selected table.
    • The Indexes tab shows indexes used in the table.
  5. To execute a query:
    1. Right-click the table name, and click Query Table.
    2. Adjust the default SQL query or create a new one, and click Execute.

      The default SQL query lists the contents of the table.

  6. To export a table, right-click the table name, and click Export to CSV. You will be asked to enter a name for the comma separated value file created.

Edit database fields

You can edit database fields in the Database Manager. We do not recommend changing values directly in the database unless clearly directed to do so by Support or as completed by a DBA. As you make changes and capture data through the SolarWinds Platform Web Console, this data saves safely to the database.

Table editing should only be performed by a database administrator (DBA) or other expert user. Changes made directly in your database can jeopardize the integrity of your data.

SolarWinds recommends that you change database settings and values using the Settings with your SolarWinds Platform Web Console.

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. If the SQL Server hosting your SolarWinds Platform database is not listed in the left pane, add the SQL Server hosting the database.
  3. Expand the SQL Server hosting your SolarWinds Platform database in the left pane, and expand the SolarWinds Platform database.

    4. The default database name is SolarWinds Orion.

  4. Right‑click a table, and click Table Details.
  5. Adjust the default SQL query or create a new one, and click Execute.

    The default SQL query lists the contents of the table.

  6. To edit the data in a table, click Enable Table Editing, and edit the fields in the table.