Beautiful. Thank you Sherry. From: [email protected] [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Friday, May 2, 2014 7:28 PM To: [email protected]; HELMS, DAVID C Subject: Re: [mssms] SCCM 2012 + Collecting sqlserver info within Hardware Inventory?
***This is an EXTERNAL email. Please do not click on a link or open any attachments unless you are confident it is from a trusted source. ________________________________ Use this: http://myitforum.com/myitforumwp/2012/02/21/installed-sql-05-sql08-and-sql12-version-information-via-configmgr-hardware-inventory/ I haven't checked yet if I need to update that for sql 2014.... I'll probably know that next week On May 2, 2014 9:48:44 AM CDT, "HELMS, DAVID C" <[email protected]<mailto:[email protected]>> wrote: I am trying to collect information about Sqlserver instances within WMI. I was able to add this class in hardware inventory, but the location of this information can differ depending on the version of SQL installed. Is there an easier way to be able to retrieve this without having to have multiple Namespace locations? The Class ID seems to be the same but the namespace will vary. Below is a snip it from the exported mof from SCCM 2012 on this namespace. The highlighted part is what could be different depending on sql. [ SMS_Report (TRUE), SMS_Group_Name ("SqlServiceAdvancedProperty"), SMS_Class_ID ("MICROSOFT|SQLSERVICEADVANCEDPROPERTY|1.0"), Namespace ("root\\\\Microsoft\\\\SqlServer\\\\ComputerManagement11") ] class SqlServiceAdvancedProperty : SMS_Class_Template { [ SMS_Report (TRUE), key ] UInt32 PropertyIndex; [ SMS_Report (TRUE), key ] String PropertyName; [ SMS_Report (TRUE), key ] String ServiceName; [ SMS_Report (TRUE), key ] UInt32 SqlServiceType; [ SMS_Report (TRUE) ] Boolean IsReadOnly; [ SMS_Report (TRUE) ] UInt32 PropertyNumValue; [ SMS_Report (TRUE) ] String PropertyStrValue; [ SMS_Report (TRUE) ] UInt32 PropertyValueType; }; -- Sent from my Android phone with K-9 Mail. Please excuse my brevity.
