Depending upon what you are looking for, this will normally be helpful: http://myitforum.com/myitforumwp/2012/02/21/installed-sql-05-sql08-and-sql12-version-information-via-configmgr-hardware-inventory/
Sherry Kissinger Microsoft MVP - ConfigMgr [email protected] ________________________________ From: Russ Rimmerman <[email protected]> To: "[email protected]" <[email protected]> Sent: Thu, May 23, 2013 11:06:54 PM Subject: [mssms] RE: Detecting SQL in CM You could use the SqlServiceAdvancedProperty WMI class from the root\microsoft\sqlserver\computermanagement namespace for 2005, root\microsoft\sqlserver\computermanagement10 for sql 2008/r2, and root\microsoft\sqlserver\computermanagement11 for sql 2012. PropertyName0 has a ‘SKUNAME’ which shows the SQL edition, ‘VERSION’ which shows the version # and SPLEVEL for the Service Pack, and you can also get the name of the Instance from ServiceName0, and even startup parameters if that’s of interest. If you want to add some core counts for license true-up purposes, you could join in NumberOfCores0 from v_GS_Processor. From: [email protected] [mailto:[email protected]] On Behalf Of Michael Mott Sent: Thursday, May 23, 2013 7:23 AM To: [email protected] Subject: [mssms] Detecting SQL in CM Guys, any good blog posts on sql installation detections thru SCCM\CM, even if it’s just SQL queries themselves? Michael Mott| Solutions Engineer – MI and OH 1E | Empowering Efficient IT Mobile: 734-790-6643 [email protected]| www.1e.com Facebook| Twitter| YouTube| Blogs| RSS Please consider the environment before printing this e-mail ________________________________ DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
