Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > How to Run a SQL Query in Orion Database Manager on Windows Server 2008

How to Run a SQL Query in Orion Database Manager on Windows Server 2008

Table of contents
Created by Harry Griffiths, last modified by christopher.daly on Nov 14, 2018

Views: 5,690 Votes: 4 Revisions: 9

Overview

This article provides information on how to run an SQL query in the Orion Database Manager when Orion is installed on Windows Server 2008.

Environment

  • Orion product(s)
  • Windows Server 2008

Steps

  1.  Remote Desktop (MSTSC)  to the Orion Server.
             
     
  2. Click Start and type Database.

     
  3. Right-click Database Manager and choose Run as Administrator.

     
  4. Click Add default server.
     
     
  5. Expand the Orion database.
  6. Right-click and enter New Query.

     
  7. Enter the SQL query you want to run. Example:

     
  8. Click Execute Query.

 

Export the result to CSV

  1. To export the result press Export to CSV tab.

 

 

Last modified

Tags

Classifications

Public