UpSearch’s Data Estate Assessment for SQL Server relies on our exclusive Microsoft SQL Server inventory tool. Also known as the “Tool” or “Application,” the Data Estate Assessment is an agentless desktop application with a small installation footprint. The Tool scans comprehensively to gather enterprise-wide details about each Microsoft SQL Server instance and the underlying Windows Operating System.
The Tool provides several SQL Server Discovery Methods for Domain Administrators to identify and locate SQL Server instances within a network. Let’s delve into these methods and their advantages:
- DNS Server: You can specify ‘Automatic’ or the Name/IP address of an Active Directory DNS server to query for a list of hosts with installed SQL Server instances. When ‘Automatic’ is selected, the function will use WMI queries to determine the current computer’s DNS server(s) for querying.
- DNS Domain: Choose ‘Automatic’ or specify the Active Directory domain name for querying DNS. If ‘Automatic’ is chosen, the function will use the current computer’s AD domain.
- Subnet: Specify ‘Automatic’ or provide a list of subnets (in CIDR notation) to scan for SQL Server instances. Choosing ‘Automatic’ uses the current computer’s IP configuration to determine subnets for scanning.
- IP Range: You can provide a list of IP ranges to be included in the inventory.
- Computer Names: Specify a list of computer names to be included in the inventory.
- Exclude Subnets: Choose a list of subnets (in CIDR notation) to exclude when testing for connectivity.
- Limit Subnets: Specify a list of subnets (in CIDR notation) to limit the scope of connectivity tests. Only hosts within the specified subnet(s) will be included in the results.
- Exclude Computer Names: Provide a list of computer names to be excluded when testing for connectivity. Wildcards are accepted, and IP Addresses of each computer in this list will be resolved for inclusion or exclusion.
- Private Only: Restrict inventory to instances on private class A, B, or C IP addresses.
- Username and Password: Specify the SQL Server username and password for connecting to instances. Windows authentication will be used if not provided.
These SQL Server Discovery Methods grant Domain Administrators the necessary choices to efficiently use this Microsoft SQL Server inventory tool. Contact Us if you require other SQL Server Discovery Methods to discover what’s in your SQL Server environment.