We help IT Professionals succeed at work.

How to use SCCM 2012 to get SQL edition

I have just been handed an urgent need to report all installations of SQL Server. The problem is I need a custom report that identifies the editions as well to determine if it is SQL Server or SQL Express.
I am on the ropes because 2012 doesn't use the MOF, and I have no idea how to pull anything beyond Versions.
There are SQL Server/Express for all releases from 2005 through 2014.
I must be able to identify which are SQL Express and which are SQL Server full because we are at a cross-road with licenses and need to true up ASAP.
Please any help or is this even possible?

Watch Question

IT Engineer
Distinguished Expert 2017
Meanwhile check if the answer to this question can help you.


That post allowed me to see more into the structure I needed but the MOF is not in 2012.
I had to get a DBA involved to breakdown and target the info. We are still narrowing it down.