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]<mailto:[email protected]> | www.1e.com<http://www.1e.com/> Facebook<http://www.facebook.com/1eglobal> | Twitter<https://twitter.com/1e_global/> | YouTube<http://www.youtube.com/1enews> | Blogs<http://blogs.1e.com/> | RSS<http://blogs.1e.com/index.php/feed/> 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.
