You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

To access the cloud instances discovery options click Cloud on the left pane of the Discovery Center Options view. SQL Inventory Manager retrieves the majority of the metrics using SQL Scripts but retrieving performance metrics require the use of API calls.

There are two scenarios when discovering instances:

Scenario 1: Instance is discovered using cloud account. In this case, the account is already associated with this instance so API calls will be using this account

Scenario 2: Instance is not discovered, but added directly from add instance screen in this case, API calls will be using account details added via add instance wizard


Sql server login is mandatory when registering an instance

Discovering Amazon Instances

The Amazon tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.

Before you begin

Make sure you perform these steps before adding an Amazon account on SIM.

  1. Create an AWS account as trusted entity for read-only role on the main AWS account where SQL Inventory Manager discovery will be running.
  2. Create a read-only role on the user’s main AWS account (where SQL Inventory Manager discovery will be running)

Adding an Amazon account

For Amazon: "Specify the account to be used to connect to the Amazon EC2 or RDS instance. Amazon account information is needed to collect performance metrics. Please note that you may see charges from Amazon for Cloudwatch API requests. Click here [insert url to wiki page] for more information."


Click Add Amazon Account and enter the following information on the Amazon Account dialog.

AWS Account Name: Name for referencing the AWS account.

AWS Access Key: Access ID.

AWS Secret Key: Secret access key information.

AWS Region Endpoint: Select your Amazon region.


Editing an account

To edit an Amazon account click on the gear icon next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.

Removing an account

To remove an Amazon account click on the gear icon next to the account name you want to remove and select Remove.

Note: All the instances discovered before removing an account remain on the Discovered View.


Discovering Azure Instances

The Azure tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.

Adding an Amazon account

Click Add Azure Account and enter the following information on the Amazon Account dialog.

Azure Account Name: Name for referencing the Azure account.

Azure Tenant ID: The ID of the AAD directory in which the application resides.

Azure Client ID: The Application ID name.

Azure Client Secret Key: Application ID key.

Azure Subscription ID: Your subscription ID.

Editing an account

To edit an Azure account click on the gear icon next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.

Removing an account

To remove an Azure account click on the gear icon next to the account name you want to remove and select Remove.



SQL Inventory Manager Discover and visualize your SQL Server environment.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels