SCCM Report or SQL Query to fetch the information of all SQL server versions & editions installed in environment
Question
Hello Guys,
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
Regards,
Pritam Mayekar
Answers ( 2 )
You have to achieve it by extending the hardware inventory.Check below article
https://sccm-zone.com/sql-version-detection-and-report-sccm-2012-r2-12f299b5e63b
Thank you very much Ankit for your response. Today I have also found the same article on internet. Besides this article I have found below mentioned article and as our management is hurry I have used the below article to fetch the SQL server information.
https://www.sqlservercentral.com/blogs/list-out-all-the-sql-servers-in-domain