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" <dahe...@scana.com> 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.
