Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Orion Platform > Orion Documentation > Orion Platform Administrator Guide > View database details in the Database Manager

View database details in the Database Manager

Created by Magdalena.Markova, last modified by Magdalena.Markova on Dec 10, 2018

Views: 53 Votes: 0 Revisions: 2

Updated: December 4, 2018

This topic applies to all Orion 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 Orion 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 Orion 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 Orion 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 Orion database is not listed in the left pane, add the SQL Server hosting the database.
  3. Expand the SQL Server hosting your SolarWinds Orion database in the left pane, and expand the SolarWinds Orion 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 Orion 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 Orion Web Console.

The default database name is SolarWinds Orion.

  1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
  2. If the SQL Server hosting your SolarWinds Orion database is not listed in the left pane, add the SQL Server hosting the database.
  3. Expand the SQL Server hosting your SolarWinds Orion database in the left pane, and expand the SolarWinds Orion database.
  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.
 
Last modified

Tags

Classifications

Public