That’s basically what I implemented. I’m not a fan of the three data and reporting classes though and the tables and views they create in the database. I prefer to have something more streamlined.
From: [email protected] [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Friday, May 02, 2014 7:28 PM To: [email protected]; HELMS, DAVID C Subject: Re: [mssms] SCCM 2012 + Collecting sqlserver info within Hardware Inventory? 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.
