SQL Server xp_msver is a SQL Server system stored procedure, returning general sql server information I find it useful for gathering basic server build and server information. Run it as EXEC master..xp_msver

 I use it when I need gather information for a SQL Server Inventory audit. I use the process outlined in Powershell - run script on all sql servers  . This iterates through a list of servers , executes a script and returns the script output.

 The information it returns is :

 ProductName

ProductVersion

Language

Platform

Comments

CompanyName

FileDescription

FileVersion

InternalName

LegalCopyright

LegalTrademarks

OriginalFilename

PrivateBuild

SpecialBuild

WindowsVersion

ProcessorCount

ProcessorActiveMask

ProcessorType

PhysicalMemory

Product ID

SQL Server xp_msver  could also be stored in a table – where you could then analyse the data.

In this example , I’m using a temp table , but you could create a permanent system table .