Version Audit
Version Audit
Business Case
When working with multiple environments using MSSQL database instances, it is often the case where different versions of MSSQL are deployed across development and test environments and left to languish until a decision to review and potentially upgrade, is made. This tool set expedites the auditing time for your DBA.
Overview
Version Audit is a collection of scripts used to automate the creation of a spreadsheet (csv), detailing the Instance Version information of multiple MS SQL Instances. This set of scripts can also be extended to automate other sql process as its core feature provides the ability to execute a single sql script across multiple MSSQL instances and capture the output.
Input Example
SRD01\DEVELOPMENT01,5022
SRD01\DEVELOPMENT02,5023
Output Example
| SQL | Version | Pack Level | Machine Name | Instance Name | Edition |
|---|---|---|---|---|---|
| Microsoft SQL Server 2012 - 11.0.2218.0 (X64) | 11.0.2218.0 | RTM | SRD01 | DEVELOPMENT01 | Developer Edition (64-bit) |
| Microsoft SQL Server 2012 - 11.0.2218.0 (X64) | 11.0.2218.0 | RTM | SRD01 | DEVELOPMENT02 | Developer Edition (64-bit) |