Page History

...

IDERA SQL Inventory Manager uses the Computer scan to obtain a list of machines based on IP ranges or domains. You can set your preferred schedule for a Computer scan daily or weekly. If you choose a Daily schedule, then set the specific time for the discovery job. If you set a Weekly schedule, specify the days of the week and the time when the scan will be performed.

Image Modified

Add IP address ranges for discovery

...

Add Domains for discovery

You can Edit/Remove the domains you entered before. You can also select those domains that you want to scan immediately by clicking Run scan now. To add a domain click Add on the Domain section.

Image Added

The Discovery Center Options allows you to add domains for discovering SQL Server instances. Go to the Domain section, click Add, and specify DNS Name, the domain name with the account that will be used to connect to this domain (User and Password). Select Enable this rule/scan as part of the scheduled computer scan if you want IDERA SQL Inventory Manager to use the domain for running scheduled jobs.

Exclude

If you exclude a parent domain then all its children are also excluded from scan.

If you exclude a domain which is a subdomain of an included domain, then all the excluded domain's children are excluded from scan.

Discovery Scan type

Image Added

There are three types of scan available:

Full

The scan runs through all domains, sub-domain, and other trusted domains.

Specified And Sub

The scan runs trough the specified domain and its sub-domains.

Specified only

The scan only runs through the specified domainYou can Edit/Remove the domains you entered before. You can also select those domains that you want to scan immediately by clicking Run scan now.

Specify alternate credentials to use during the scan

IDERA SQL Inventory Manager allows you to specify multiple sets of credentials to attempt to use during instance discovery. Click Manage Discovery Credentials to add one or more user accounts to attempt to connect to an instance. List the credentials in the order in which you want IDERA SQL Inventory Manager to use.

Configure BI Services

When this option is enabled SQL Inventory Manager discovers both instances and BI services, the discovery of BI services is only possible when there's an specified IP range or domain and a scan type.

Enable FQDN 

Enable this option to use FQDN as part of the discovery process.

...

• Log into SQL Instances 
  When this option is enabled, SQL Inventory Manager attempts to connect to discovered SQL Server Instances to gather information such as Version and Edition. Go to Manage Discovery Credentials to make sure valid credentials are present.
  
  
• Only shows instances whose SQL Server version can be validated
  When this option is enabled, SQL Inventory Manager only displays  Instances  that can be validated.
• Only show instances discovered by at least two methods
  When this option is enabled,  SQL Inventory Manager only displays instances discovered with two different methods
  
  
  

...

You can set the schedule of your preference (Daily, Weekly) for any of the mentioned scans. If you choose a Daily schedule, then set the specific time for the discovery job. if you set a Weekly schedule, specify the days of the week and the time when the scan will be performed.

Image Modified

Specify alternate credentials to use during the scan

...

• Log into SQL Instances 
  When this option is enabled, SQL Inventory Manager attempts to connect to discovered SQL Server Instances to gather information such as Version and Edition. Go to Manage Discovery Credentials to make sure valid credentials are present.
  
  
• Only shows instances whose SQL Server version can be validated
  When this option is enabled, SQL Inventory Manager only displays  Instances  that can be validated.
• Only show instances discovered by at least two methods
  When this option is enabled,  SQL Inventory Manager only displays instances discovered with two different methods

...

...