Page History
IDERA SQL Inventory Manager continuously searches your network to find new SQL Server instances. To see newly discovered instances, go to the Discovered view on the Instances tab. SQL Inventory Manager shows you a list of those instances not yet monitored in your environment. From this view you can add or ignore instances.
| Note | ||
|---|---|---|
| ||
If you have the auto-registration option enabled, newly discovered instances will be automatically registered according to your settings in the Auto registration options. Those instances that were discovered before this option was enabled will remain on the Discovered view. |
What actions can you perform on the Discovered instances view?
Ignoring instances
You can choose to ignore any of these discovered instances. For this purpose, mark the checkbox next to the instance you want to ignore, and click Ignore on the action items bar.
SQL Inventory Manager no longer shows the ignored instances on the Discovered view but adds them to the Ignored view.
Auto registration options
Use these options to automatically register SQL Server instances as they are discovered. On this dialog window you can choose which SQL Server editions you want to exclude from auto registration.
Discover instances
Use this option to start a job to discover instances. Take into account that this process may take some time to complete. When you select to discover instances, SQL Inventory Manager displays two options:
- Discover Instances Browser Service - lets you discover instances by using "System.Data.Sql.SqlDataSourceEnumerator" which enumerates all available SQL Server instances within the local network.
- Discover Instances Odbc - lets you discover instances using "odbc32.dll" which gets the instances list from the system's registry data.
Adding instances
If you want to register some of these instances, select the respective checkboxes of the instances you want to add, and then click Add SQL Server Instance on the action items bar.
SQL Inventory Manager opens the wizard for adding new SQL Server instances, and automatically adds the names of the instances you selected before. For more information on how to register SQL Server instances, go to Adding SQL Server instances.
| Tip | ||
|---|---|---|
| ||
On the Discovered view, you can find the Microsoft SQL version and edition next to the instances status to help you decide which instances you want to add or ignore. |
Export reports
If you want to export the information displayed on the Discovered Instances view, go to the Export option, located on the action items bar, and select your preferred format (PDF, XLS, or XML) for exporting.
What filter options are available on this view?
On the left side of the Discovered Instances view you have the option for filtering instances by Version.
If you want to filter by specific versions, select them from this section. Enable or disable the option Apply filter as it changes depending if you want to see the changes as you apply the filters, or if you prefer to select your filters first and see the results when you finish.
users can mark instances and databases as "decommissioned" within the product, thereby preventing erroneous alerting yet retaining the data for historical purposes. Decommissioned items are not monitored, do not trigger alerts or recommendations, and do not count against your IDERA SQL Inventory Manager license. The data stored before an item is decommissioned remains in the repository database, but is only included in the Decommissioned tab in the Instances view and the Decommissioned Databases list at the bottom of the Instance Details view.
The Decommissioned tab and the Decommissioned Databases list show information about decommissioned items such as the name, timestamp of decommission, SQL Server version and edition (Instance only), recommendations (Databases only), and more. To access the Decommissioned tab, go to the Instances tab, and click Decommissioned.
| Info |
|---|
Users who decommission or recommission instances and databases must be administrators within IDERA SQL Inventory Manager. |
| Tip | ||
|---|---|---|
| ||
To add notes on why an instance is decommissioned, you can use the comments field on the Instance options, or you can create a custom inventory field. You must add the notes before changing the status to decommission. |
Available options
On the Decommissioned view there are two options available on the action items bar:
- Add. Click this option to go to the respective wizard and add new SQL Server instances.
- Export
. You can choose any of the following formats: PDF, XLS, or XML for exporting the information displayed on the Decommissioned view. Advanced Filter. Apply advanced filters.
Clear Filters. Clears any applied advanced filters.
| Tip |
|---|
You can type on the bottom section of this view the number of instances you want IDERA SQL Inventory Manager to display per page. Click Refresh to apply the changes. |
Options available when you select instances
On the Decommissioned view, IDERA SQL Inventory Manager allows you to perform several actions on a single instance as well as bulk actions on several selected instances.
If you select one or more instances, you can perform the following actions:
- Recommission
- Remove
| Tip |
|---|
You can also access most of these options from the gear icon next to the selected instance. To access the instance details view, you can click directly on the instance name. |
Viewing instance details
You can access an instance details view by clicking directly on the instance name. For more information about what information is available on the instance details view, refer to Viewing instance details. Decommissioned instances display a large message including the timestamp when the instance was decommissioned and to remind the user that all displayed data is for historical purposes only.
Remove
If you no longer want to manage an instance, you can remove it by selecting the respective instance, going to More Actions on the action items bar, and selecting Remove. You can also find this option by clicking the gear icon next to the instance. IDERA SQL Inventory Manager displays all removed instances on the Ignored instances view. For more information about removing instances click here.
Recommission
Select an instance and click Recommission on the action items bar. You can also find this option by clicking the gear icon next to the respective instance. On the confirmation message dialog, verify the correct instance(s) appears, and then click Yes. Note that the instance disappears from the Decommissioned tab and appears on the Managed tab. Remember that this instance is now active and does count against your IDERA SQL Inventory Manager license.
Add SQL Server instance
If you want to access the Add SQL Server instance wizard, click Add SQL Server instance. The wizard opens and allows you to browse and register SQL Server instances.
Advanced Filter
Apply advanced filters to your instances view, for more information refer to Filtering and Sorting.
Clear Filters
Clears any applied advanced filters.
Exporting from the Decommissioned view
On the action items bar of the Decommissioned view, you can find the Export option which allows you to choose your preferred format for exporting the information available on this view. You can export as a PDF, XLS, or XML file. The filters you choose on this view will be taken into account for your exported reports.
Filtering and Sorting
SQL Inventory Manager offers different ways of sorting and filtering the listed instances/servers, for further information refer to Filtering and Sorting
| Tip | ||
|---|---|---|
| ||
| IDERA SQL | ||
| Tip | ||
| ||
| SQL Inventory Manager displays the filters you select on the top section of your Discovered managed instances view under under Filtered by.You can remove filters from this section too. |
| Tip | ||
|---|---|---|
| ||
You can set the number of instances you want SQL Inventory Manager to show per page, go to the Display option at the bottom of this view, type the number you want, and click Refresh. |
Manage your Discovery Options
If you want to configure the discovery job, go to the Administration tab and click Manage Discovery Options on the Discovery section. On this dialog window you can specify not only those IP address ranges and domains where you want SQL Inventory Manager to perform the discovery job, but also you can choose which methods you want to use to search in each computer. You can schedule your discovery jobs, add IP address ranges and those domains that SQL Inventory Manager will use in discovery.
For more information on how to configure your manage discovery options, click here.
| Info | ||
|---|---|---|
| ||
You can also access the Discovered instances section by clicking New Instances on the right sidebar of the overview. For more information, go to Viewing information on the SQL Inventory Manager Overview. |
Need more help? Search the Idera Customer Support Portal.
...