Add Amazon Web Services (AWS) regions in Orion Platform modules that support cloud monitoring

11/7/2018 5:15 PM

11/7/2018 5:15 PM

This article describes how to use the Database Manager to add a Amazon Web Services (AWS) region in Orion Platform products that support cloud monitoring, such as SAM and VMAN. This procedure involves querying the Orion Platform database. 

Server Application Monitor

N/A

Important: SolarWinds recommends backing up the Orion SQL database before making changes. For assistance, check your vendor's site for documentation and instructions. If your database is on a VM, create a snapshot or copy of the VM. See Back up the SolarWinds Orion database using SQL Server Management Studio.

Perform the following steps to add an AWS region:

1. Log into your Orion server.
2. Open the Database Manager. (See Use Database Manager to view the SolarWinds database for details)
3. Click Add default server.
4. Right-click the SolarWinds database and enter the following query:

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   IF NOT EXISTS (SELECT 1 FROM CLM_AwsRegions WHERE SystemName = 'new-region')
   INSERT INTO CLM_AwsRegions([SystemName],[DisplayName],[Enabled])
   VALUES('new-region','EU (AvailablilityZone)',1)

Here is a sample script that adds Paris as an AWS region:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

IF NOT EXISTS (SELECT 1 FROM CLM_AwsRegions WHERE SystemName = 'eu-west-3')
INSERT INTO CLM_AwsRegions([SystemName],[DisplayName],[Enabled])
VALUES('eu-west-3','EU (Paris)',1)

For SystemName and DisplayName, see Regions and Availability Zones. (© 2018 Amazon Web Services, Inc., available at https://docs.aws.amazon.com, obtained on December 4, 2018)

The latest AWS regions appear on the Cloud Summary page .

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.