wmi filtering

Good evening !

My question is about WMI Filtering and GPO.
I need to create one GPO for SQL2000 servers and one other for SQL2005
servers because of different settings to be applied to each one. All servers
are located in the same OU and I can't create seperate ones for each version.
So I've been thinking about WMI Filters checking SQL Version. Unfortunately,
I am not an expert in WMI queries so I would appreciate if someone could help
me.

Thanks in advance for your help

Ken
Fri Mar 28 12:26:51 PDT 2008

Hello,
I am not a WMI expert, but I did find this:
http://msdn2.microsoft.com/en-us/library/bb326207.aspx
Try building your WMI query to process based on results for
GetDatabaseVersionDisplayName.

--
Ken Aldrich
DSRAZOR for Windows
Visual Click Software, Inc.
www.visualclick.com

"Vincent" <Vincent@discussions.microsoft.com> wrote in message
news:2396B7D8-93CE-41FE-93BD-C29BC7FBB175@microsoft.com...
> Good evening !
>
> My question is about WMI Filtering and GPO.
> I need to create one GPO for SQL2000 servers and one other for SQL2005
> servers because of different settings to be applied to each one. All
> servers
> are located in the same OU and I can't create seperate ones for each
> version.
> So I've been thinking about WMI Filters checking SQL Version.
> Unfortunately,
> I am not an expert in WMI queries so I would appreciate if someone could
> help
> me.
>
> Thanks in advance for your help

Paul
Fri Mar 28 12:54:56 PDT 2008

Test with Scriptomatic (from the Scripting guys, google it) against the
WMI namespace root\Microsoft\SqlServer\Computermanagement

I believe the WQL Query should look for the MSSQL$MICROSOFT##SSEE string
in the SqlServiceAdvancedProperty to detest 2005, or MSSQL$SQLEXPRESS
for express, not sure if this works for 2000 though.

That would make the query something like:

SELECT * FROM SqlServiceAdvancedProperty WHERE ServiceName =
'MSSQL$MICROSOFT##SSEE'

Or something along those lines...

-Note that I have not tested any of this-!

but hopefully this may put you on the right track.

/ ) Regards,
/ /_________
_|__|__) Paul Weterings
/ (O_) http://www.servercare.nl
__/ (O_)
____(O_)


Vincent wrote:
> Good evening !
>
> My question is about WMI Filtering and GPO.
> I need to create one GPO for SQL2000 servers and one other for SQL2005
> servers because of different settings to be applied to each one. All servers
> are located in the same OU and I can't create seperate ones for each version.
> So I've been thinking about WMI Filters checking SQL Version. Unfortunately,
> I am not an expert in WMI queries so I would appreciate if someone could help
> me.
>
> Thanks in advance for your help