SCCM Report or SQL Query to fetch the information of all SQL server versions & editions installed in environment
I am looking out for SCCM Report or SQL Query to fetch the information of all SQL server versions (2008, 2008R2, 2012, 2014 and so on) along with its editions (Enterprise, Standatd or Express)installed in environment. The report should also have computer name where SQL is installed. I hav googled but haven’t found any SQL query which will fetch the exact information of computer name, SQL version along with editions. Please let me know if anybody having such SQL query or SCCM report.
Thanks in Advance