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 )

    0
    2021-05-16T20:11:30+05:30

    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

Leave an answer

Sorry, you do not have permission to answer to this question .