Page History
IDERA SQL Inventory Manager constantly discovers SQL Server instances so you can select those the ones that you want to monitor. When you open the Add SQL Server Instance wizard, you can choose those ones you want to register with IDERA SQL Inventory Manager; however, you can also import a list of instances from your computer. Go to the Administration tab, on the Instances section you can find the option Import SQL Servers. Use this option to import a .csv file from your computer.
Acceptable .csv format
You must use a properly-formatted .csv for each kind of instance you want to import. There are no limits on the number of rows included in the file, but note that if a row is incorrectly formatted, IDERA SQL Inventory Manager imports all rows above the incorrect row but does not import the incorrect row or any of the rows below that row.
Info |
---|
For users who must use a fully qualified domain name (FQDN) instead of the Windows Internet Naming Service (WINS), IDERA SQL Inventory Manager accepts the FQDN name for import and will collect information for that SQL Server instance. However, if you also add this instance as WINS, then realize that you have two records pointing to the same instance. IDERA SQL Inventory Manager does allow you to connect to the same instance using FQDN or WINS. If you don't want to have WINS instances, set the instances to Ignore. You can view ignored instances on the Instances > Ignored tab. |
On-Premise instances
For importing On-premises a successful import of SQL Server instances, please use the OnPremise.csv or use the following general rules and .csv file format.
- Enter or Browse SQL Server Instances cannot be null.
- Instance Owner should be unique across an instance.
- Instance Location should be unique across an instance.
- The next time the user uploads a record for the same instances, the Instance Tags / Database Name / Database Tags should be added to the existing IDERA SQL Inventory Manager data. But the Instance Owner and Instance Location should be updated with the new values.
- Database Tags can be a list of comma separated values.
- Instance Name cannot be null.
- Instance Owner, Instance Location, Instance Tags, and Instance Database can be null.
- Comments
- Current Tags
- Add New Tag
Enter or Browse SQL Server Instances | Owner | Location | Comments | Current Tags | Add New Tag |
---|---|---|---|---|---|
Amazon instances
For importing amazon SQL Server instances, please use the SQL Inventory Manager Import_Azure.csv instances or use the following general rules and .csv file format.
- Enter or Browse Amazon SQL Server Instances
- Owner
- Location
- Comments
- Current Tags
- DataBase Name
- Add New Tag
- AWS Account Name
- AWS Access Key
- AWS Secret Key
- AWS Region Endpoint
Enter or Browse Amazon SQL Server Instances | Owner | Location | Comments | Current Tags | DataBase Name | Add New Tag | AWS Account Name | AWS Access Key | AWS Secret Key | AWS Region Endpoint |
---|---|---|---|---|---|---|---|---|---|---|
Azure instances
For importing On-premises SQL Server instances, please use the SQL Inventory Manager Import_Amazon.csv instances or use the following general rules and .csv file format.
- Enter or Browse Azure SQL Server Instances
- Owner
- Location
- Comments
- Current Tags
- DataBase Name
- Add New Tag
- Azure Account Name
- Azure Tenant ID
- Azure Client ID
- Azure Client Secret Key
- Azure Subscription ID
- Account Type
Enter or Browse Azure SQL Server Instances | Owner | Location | Comments | Current Tags | DataBase Name | Add New Tag | Azure Account Name | Azure Tenant ID | Azure Client ID | Azure Client Secret Key | Azure Subscription ID | Account Type |
---|
Name
Owner
Location
(Comma separated list in quotation marks)
Name
(Comma separated list in quotation marks)
ABC_1 | Group1 | West | "InstProd, Production, 24Hour" | Test | "X, A, C" | |||||||
ABC_1 | Group1 | West | "InstProd, Production, 24Hour" | DB2 | "DBA, ProductionDB, TESTDB" | |||||||
XYZ | Owner | , | , | , | , |
Importing a .csv file
To import a file:
- Select what type of instances you want to import, either Private/On-Premise , Amazon , or Azure.
- Click Browse to choose a properly formatted Click Upload to choose a .csv file from your computer.
- Go to C:> Program Files> Idera> SQLInventoryManager> CollectionService, either OnPremise , Amazon , or Azure. IDERA SQL Inventory Manager displays the instances from your uploaded .csv file.
- Select or clear those instances that you want to import, and then click Import.
Note | ||
---|---|---|
| ||
Keep in mind that the .csv files you use to import must have only the names of the instances. |
Making bulk changes after importing instances
After
...
importing the instances, you can use the bulk options available on the Managed Instances view to set the credentials for monitoring them, as well as editing their owners, locations, comments, and tags
...
.
Info |
---|
In the .csv file format, there is no separate column for credentials. However, after importing, you can update these instances using a bulk action to edit the credentials for all affected instances. For example:
|
Excerpt |
---|
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...