Discover, Track and Manage Your SQL Server Inventory

SQL Inventory Manager

Version 2.3

  • Discovery of BI Services – Discover SQL BI services (SSRS, SSIS, SSAS) that are not running on DB Engine.
  • Support for AlwaysOn Availability Groups – Discover and monitor database instances on AlwaysOn Availability Groups.
  • Patch and Version List – Ability to compare builds for servers that are in your inventory vs what is the latest patch from MS for that version.
  • Enhancements to Discovery – Add new Discovery options such as Include/Exclude Domains and Organizational Unit.
  • Configure Health Checks – Set threshold values at risk warning alerts for the database Volume, Data and Data Logs.
  • Improved Import Capability – Ability to import additional data such as locations, owners, database tags for database instances that user wants to monitor.
  • Enhancements with IDERA Dashboard – Ability to promote tags to IDERA Dashboard to be used by other IDERA products.
  • Bug fixes and enhancements

Version 2.2

  • Number of cores and core factor information added to MS licensing view
  • Ability to configure default values of health check settings
  • Support for SQL Server 2016
  • Performance improvements to optimize for larger environments

Version 2.0

  • Product name changed from SQL Elements to SQL Inventory Manager
  • Enhancements to Discovery
    • Expands discovery collection criteria to those which Microsoft Assessment and Planning (MAP) toolkit uses for SQL Servers.
    • Specify a listing of alternate credentials with admin privileges to use during the discovery process in case the original credentials are not valid.
  • Enhancements to Inventory Management
    • Database Level Tagging – set tags and comment on databases distinctly from the server instances they reside upon.
    • Custom Inventory Fields – create custom inventory fields or labels at the server, instance &/or database level to further categorize assets.
    • Server & Database Decommissioning – mark any instances and databases taken offline to prevent erroneous alerting. Those servers will preserve asset and tagging information in the event you need to re-commission later.
    • View Application Information – see the applications running on an instance to understand how the server is being utilized and how often the applications are used.
    • Improved Scalability – monitor and manage thousands of databases.
    • Expanded Search – search by text string for specific instances or databases across the managed inventory.
  • Role-based Security Enhancements
    • Specify different levels of user access including administrator, modify only and read-only.
  • Integration with Idera Dashboard
    • Access a consolidated dashboard console to quickly view and navigate between the different products you use from Idera. SQL Inventory Manager will show key indicators in the dashboard view including:
      • Top Databases by Size
      • Top Databases by Activity
      • Tags cloud
      • SQL Server Licensing Info
  • Additional Platform Support
    • Monitor and manage IaaS for Amazon RDS, SQL Azure and SQL Server 2000.

Version 1.2

  • Bug fixes and enhancements

Version 1.1

  • Expanded Discovery & Registration
    • Discovery capabilities of SQL instances expanded to include domains, IP address ranges and both standard and custom TCP ports.
    • Added ability to schedule scans of the environment to suit specific days or timeframes as needed.
    • Add option to import server lists for registration
    • Improve auto-registration process to better accommodate additional discovery methods and large scale environments, allowing users to specify which SQL Server editions are automatically monitored.
  • Reporting
    • View inventory reports grouped by server attributes and annotations
    • Capability to export and print server inventory and recommendation reports as needed.
  • New Views
    • View list of SQL Servers to ensure adherence to Microsoft licensing compliance. View displays all SQL Servers, which versions they are running, how many instances reside on them, how many CPUs, etc. You can also export this list and give to internal licensing team as needed.
No credit card required! Fully functional for 14 days HeroShot

Buy Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart
Request a Quote

Live product Demo

See SQL Inventory Manager in action with a seasoned pro.

Request a Demo