Script request - SQL server inventory

PowerShell Help
1

I’d like to know what version of sql and to what patch level my servers are running.

So the output would be something like

SERVER1 Windows 2012r2 SQL 2014 SP3

SERVER2 Windows 2016 SQL 2017 cu3

I have the list of servers in a csv file and would like to use that as the source for the servers the script looks for.

Can anyone help with a script for this?

2

Did you attempt to search for this? “powershell get sql version” provide many results. If you have SQL Management installed on your system, you can use this:

If not, then search and there are registry and WMI solutions.