References > Aliases > Maintain the SolarWinds Orion database > View table details

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