Andy Galbraith, one of Ntirety’s DBAs, recently published a blog post addressing some common questions he finds out in the SQLverse about polling Windows information from inside SQL Server itself. ┬áThere are a couple of frequently touted options that he dives into.┬áThe full explanation lives on his blog:

http://nebraskasql.blogspot.com/2017/03/querying-sql-and-windows-version-info.html?spref=tw