The IDERA SQL Inventory Manager Patches view helps you manage SQL Server patches and keep your environment properly patched. The Patches view displays a list of your managed SQL Server instances including whether they are running a supported version of SQL Server. In addition, you can get information about the patches running on your SQL Server and whether additional hotfixes are available for your SQL Server level.
Access the Patches view by going to the Instances view, and then clicking the arrow icon to the right of the current view title, such as Database Instances.
The Patch view allows you to:
- Verify that your SQL Servers instances are patched to the same level and/or the appropriate level.
- Identify whether any SQL Server instances are running unsupported versions of SQL Server (or versions whose support is about to expire).
- Use quick links to Microsoft Knowledge Base articles to get more information about applied hotfixes and new hotfixes.
- Keep up with the latest patches by downloading the most recent list compiled by IDERA.
Available actions
Display Build List (mm/dd/yyyy)
Displays the SQL Server build list associated with the date in parentheses. You can expand/contract the content for each SQL Server version by clicking the small arrow icon next to the version name.
You can get additional information about the build by clicking the link for the associated Microsoft Knowledge Base article, if available.
Check for New Build List
Verifies that the build file located on your IDERA SQL Inventory Manager server matches the latest build file located on the IDERA server. If the current build list on your machine is older, your list is updated and the changes are applied to the Patches view for the managed instances. IDERA SQL Inventory Manager displays a message if your list matches the latest list on the IDERA server.
Export
On the action items bar of the Patches view, you can find the Export option which allows you to choose your preferred format for exporting the information available on this view. You can export as a PDF, XLS, or XML file. The filters you choose on this view will be taken into account for your exported reports.
View available updates
View support status
To use Patch Analyzer:
- Open the IDERA SQL Admin Toolset Launchpad, and then click Patch Analyzer.
- Specify the SQL Server instance or server group whose SQL Server versions you want to check. To specify multiple SQL Servers, separate each instance name with a semicolon.
- Click Load Version Information. Review the results and note the highlighted versions that are no longer supported or are soon becoming unsupported.
- If you want to group the results by SQL Server version, click Show Groups on the View menu.
- If you want to see more information about a hotfix that was applied to your SQL Server instance, select the instance from the results list, and then click View the Microsoft Knowledge Base Article.
- If you want to see which new hotfixes are available, select the SQL Server instance you want to update from the results list, and then click View Available Updates.
- If you want to save the results, copy the list to clipboard, or save the results as an XML or CSV file.
To use find SQL Server downloads:
- Click SQL Server Downloads / Support Lifecycle.
- Find the download you need, and then click the link to proceed to the corresponding Microsoft Web site page.
To review which patches are checked:
- Click the Display Build List link. If you are not sure you have the latest list, click Check for New List. This link downloads the most recent list of releases, service packs, and hotfixes for SQL Server software.
- Review the list of all known releases of SQL Server software.
- To see the Microsoft Knowledge Base article for a specific hotfix, select the hotfix, and then click View Microsoft Knowledge Base Article.
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >