Skip to content

SQL Server Input - Add Readable SQL Server Version to ServerProperties #8252

@Trovalo

Description

@Trovalo

Feature Request

Add the readable version of the SQL Server Instance

Proposal:

Add a new tag [sql_version_desc] to the measurement sqlserver_serverproperties.
It contains the SQL Server version in a readable way.

The value can be fetched using

SELECT LEFT(@@VERSION,CHARINDEX(' - ',@@VERSION)) AS [sql_version_desc]

The result is Microsoft SQL Server 2016 (SP2-GDR) (KB4532097) and is coherent in any SQL Server version from 2008 and later. It also works for Azure (even if is way less useful).

Current behavior:

This data is available only in numeric format es "13.0.5102.14" in the tag "sql_version"

Desired behavior:

Add an additional tag "sql_version_desc" which displayed the readable version, es: "Microsoft SQL Server 2016 (SP2-GDR) (KB4532097)"

Metadata

Metadata

Assignees

No one assigned

    Labels

    feature requestRequests for new plugin and for new features to existing plugins

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions