Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Adding record to the Websites table

Adding record to the Websites table

Table of contents
Created by Craig Healy, last modified by Michael Perez on Jan 30, 2017

Views: 125 Votes: 3 Revisions: 15

Updated June 02, 2016

Overview

This article provides steps (SQL query) to allow adding additional record to the Websites table in Orion database. These steps can be used to update URL for the Orion web console to use a DNS alias instead of the hostname of the server.  

Environment

  • Orion Platform 2016.2 and earlier

Detail

Note:

  • Before making any manual changes to the database, make sure to back up the database.

 

To add a record to the Websites table, follow the steps below:

  1. Log in to the Orion Server.

  2. Open the Orion Database Manager.

  3. Expand the Server.
  4. Expand the Orion Database.
  5. Double-click the Websites table (or any table as it makes no difference).
  6. Overwrite the existing query with the following query:
     
    INSERT INTO [dbo].[Websites] ([ServerName],[IPAddress],[Port],[SSLEnabled],[Type])
    VALUES ('HOST','(All Unassigned)','PORT',SSL,'TYPE')
    

    HOST - hostname, FQDN, IP address
    PORT - relevant port (i.e. 80 for default Non-SSL, 443 for default SSL)
    SSL - 0 if Non-SSL or 1 if SSL
    TYPE - additional or primary depending on function of the website (Note: there can only be one primary and the first one will always be selected in case multiple primary records are in table)
  7. Click Execute Query.
  8. Close Database Manager.
  9. Once the Entry has been Added Please Restart all Orion Services using Orion Service Manager

Note:  If you are using a DNS alias as the Server Name, you may need to revisit these changes after the Configuration Wizard is run.  

 

Last modified
14:27, 30 Jan 2017

Tags

Classifications

Public