SQL Inventory Manager v2.0

Released: Oct 1, 2015

Updates in this release

Updates in v2.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.