Skip to main content

Snow Inventory Agent Script - Microsoft SQL Server editions and versions 1

Here you can find the release notes for Snow Inventory Agent Script - Microsoft SQL Server editions and versions 1.

1.4 latest​

Release date: 2023-02-22

Compatible Versions​

Snow Inventory Agent for WindowsMicrosoft PowerShell
Version 5 or laterVersion 3 and later

Information​

The scan-Microsoft-SQLServer.snow-ps1 script enhances the default scanning capabilities of the Snow Inventory Agent and allows the Software Recognition Service a more precise identification of installed Microsoft SQL Server editions.

This script must be executed as part of the Snow Inventory Agent for Windows, according to the Snow online documentation portal topic “Running PowerShell scripts as part of the scanning process” (https://docs.snowsoftware.com/snow-inventory/en/UUID-e3347090-a773-a05d-2e2c-ce197cd00a26.html#UUID-e3347090-a773-a05d-2e2c-ce197cd00a26_section-idm4654689347998432654961020269 ).

In the case that you want to run a manual scan, this script must be executed with appropriate permissions, so execute it using only “sc.exe control SnowInventoryAgent5 128”, as described in the online Help topic “Command line” (https://docs.snowsoftware.com/snow-inventory/en/UUID-50e53305-fd4c-eca1-94c8-c08949b593f0.html )

This script scans the ERRORLOG file within the SQL Server directory, which contains the accurate version and edition information.

With the found details, the script creates different software rows in the scan result.

Supported MS SQL Server Versions and what they are converted to:

  • 7.*             >              Microsoft SQL Server 7.0
  • 8.*             >              Microsoft SQL Server 2000
  • 9.*             >              Microsoft SQL Server 2005
  • 10.*    >              Microsoft SQL Server 2008
  • 10.*    >              Microsoft SQL Server 2008 R2
  • 11.*           >              Microsoft SQL Server 2012
  • 12.*           >              Microsoft SQL Server 2014
  • 13.*           >              Microsoft SQL Server 2016
  • 14.*           >              Microsoft SQL Server 2017
  • 15.*           >              Microsoft SQL Server 2019
  • 16.*           >              Microsoft SQL Server 2022

Enhancement​

  • added support for Microsoft SQL Server 2022

Flexera does not own the third party trademarks, software, products, or tools (collectively, the "Third Party Products") referenced herein. Third Party Product updates, including user interface updates, may not be reflected in this content.