how to view db structure

johnthemonkey

Hi

Im new with solarwinds.  Can anyone help me how to view or open the database structure of SW..? Is it possible to view it thru web..?

Thanks in advance

sean.martinez

The Database is not easily accessible from the Web Console. The best way to access the Database is though Microsoft SQL Studio or Database Manger on the server

For SQL Studio Manager:

1. Start > All Programs > Microsoft SQL Server > SQL Server Management Studio

1. Using sa credentials, log in to your SQL Server\Instance
   1. If you have forgotten your SQL Server\Instance see the Note at the Bottom

1. Click plus sign in the database, and right click SolarwindsOrion, and click New Query, paste the query and apply execute, it will let you know by say (x rows affected)

    

For our Database Manager

1. Start> Programs> Solarwinds Orion> Advanced Features> Database Manager
2. Click New Server
3. Enter in your SQL Server\Instance and the Account information
4. If you have forgotten your SQL Server\Instance, see the Note at the Bottom
5. Expand out the Solarwinds Orion Database.
6. Right Click on any Table and select Query Table
7. Clear out the “Select Top 1000 * from (Table)” and enter in the Query information and select Refresh

Note: If you have forgotten your SQL Server\Instance, you can find this information under Start> Programs> Solarwinds Orion> Configuration and Auto-Discovery> Configuration Wizard, then Database and Next. The Top Entry will be your SQL Server\Instance.