Database Inventory Management for SQL Server, Azure SQL Database, and Amazon RDS for SQL Server

SQL Inventory Manager

SQL Inventory Manager Product Tour

SQL Inventory Manager Dashboard : For any SQL Server deployment, it’s important to inventory your entire environment and determine which SQL Servers need oversight and maintenance. SQL Inventory Manager provides a simple, efficient way to discover, document, and maintain your SQL Server environment as the organization grows.

View summary information across the environment for health checks and recommendations, database instance details, and server and environment information. Drill down to see health checks and details for specific instances, including connected applications and custom inventory fields. Drill down even further to view key details for specific databases.

View Database Instances : SQL Inventory Manager captures key information on your databases, such as where they reside and how they are configured, so you can better manage the server inventory as the organization grows. See a list of servers that are currently managed or decommissioned, and which have been recently discovered. Organize servers by owner, location, or custom categories to suit your needs.

View SQL Server Patches : Maintaining your SQL Servers with the latest patches requires a coordinated effort. Easily view the status of what patches need to be deployed to all instances of your servers and databases. Compare builds for servers that are in your inventory against the latest patch from Microsoft for that version, to determine if you have the latest patches or versions.

Manage Discovery Settings : SQL Inventory Manager helps you discover all the SQL Servers in your environment. Customize discovery settings, including the use of multiple credentials and extra validation for discovered instances. Add custom inventory fields at the database, instance, or server level. Automate discovery with scheduled scans to track future server additions.

Explorer View : Use the Explorer View to create reportable views to see top databases by size, growth, transaction activity, etc. with drill-downs for further details as needed. Generate customizable reports to compile key information about the SQL Server environment, including SQL licensing, inventory summary, chargeback, and health checks.