RE: [ActiveDir] WMI and >Vista
Now the real challenge is to build a relatively simple filter that will select only the server SKUs or just the client SKUs. It looks like you can do it for Vista/Longhorn but it progressively nastier as you go back to XP and W2K. Wook -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alain Lissoir Sent: Sunday, January 21, 2007 4:32 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] WMI and >Vista So, here you go! Select * from Win32_OperatingSystem where Version >= "6.0" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 4:24 PM To: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] WMI and >Vista A very highly academic question to see if there's a way to even build such a filter :-) Alain Lissoir wrote: > It is hard to guarantee what the version # of the next OS will be :) > obviously, but I would do something like: > > Select * from Win32_OperatingSystem where Version >= "6.0" > > What's the reasoning or issue behind this specific "weird" question? :) > > /Alain > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA > aka Ebitz - SBS Rocks [MVP] > Sent: Sunday, January 21, 2007 1:24 PM > To: ActiveDir@mail.activedir.org > Subject: Re: [ActiveDir] WMI and >Vista > > But can you do a detection of Vista and Vista+next OS? > > It's a weird request I know > > Alain Lissoir wrote: > >> Btw, if the goal is just to detect, Vista (and not the SKU a I replied >> below), then: >> >> Select * from Win32_OperatingSystem where Version = "6.0" >> >> will make it. >> The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). >> >> 5.0 Windows 2000, all flavors (SKU) >> 5.1 XP 32-bit, all flavors (SKU) >> 5.2 XP 64-bit if client, Windows Server 2003 if Server >> 6.0 Windows Vista, all flavors >> 6.0 Longhorn Server for now, but this may change ... Still under >> > development > >> as you know. >> >> HTH. >> /Alain. >> >> -Original Message- >> From: Alain Lissoir [mailto:[EMAIL PROTECTED] >> Sent: Sunday, January 21, 2007 11:46 AM >> To: 'ActiveDir@mail.activedir.org' >> Subject: RE: [ActiveDir] WMI and >Vista >> >> Have you looked at the OperatingSystemSKU property? This is a property >> > added > >> in Vista to support the distinction between Vista Home, Ultimate, >> > Business, > >> etc ... >> http://msdn2.microsoft.com/en-gb/library/aa394239.aspx >> >> OperatingSystemSKU Data type: uint32 >> >> Stock Keeping Unit (SKU) number for the operating system. >> >> Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This >> property is not available. >> >> Possible SKU values are: >> >> Value Meaning >> 0 Undefined >> 1 Ultimate Edition >> 2 Home Basic Edition >> 3 Home Basic Premium Edition >> 4 Enterprise Edition >> 5 Home Basic N Edition >> 6 Business Edition >> 7 Standard Server Edition >> 8 Datacenter Server Edition >> 9 Small Business Server Edition >> 10 Enterprise Server Edition >> 11 Starter Edition >> 12 Datacenter Server Core Edition >> 13 Standard Server Core Edition >> 14 Enterprise Server Core Edition >> 15 Enterprise Server IA64 Edition >> 16 Business N Edition >> 17 Web Server Edition >> 18 Cluster Server Edition >> 19 Home Server Edition >> 20 Storage Express Server Edition >> 21 Storage Standard Server Edition >> 22 Storage Workgroup Server Edition >> 23 Storage Enterprise Server Edition >> 24 Server For Small Business Edition >> 25 Small Business Server Premium Edition >> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, >> > CPA > >> aka Ebitz - SBS Rocks [MVP] >> Sent: Sunday, January 21, 2007 11:00 AM >> To: ActiveDir@mail.activedir.org >> Subject: [ActiveDir] WMI and >Vista >> >> If one wanted to build a WMI query that would capture Vista "and" any >> other workstation OS after Vista... how would one build that query? >> >> I know that this will capture Vista: >> Select * from Win32_OperatingSystem where Version = "6.0.6000" >> >> But will this catch any version of Vista after XP if, on the odd chance >> they change the bu
RE: [ActiveDir] WMI and >Vista
So, here you go! Select * from Win32_OperatingSystem where Version >= "6.0" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 4:24 PM To: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] WMI and >Vista A very highly academic question to see if there's a way to even build such a filter :-) Alain Lissoir wrote: > It is hard to guarantee what the version # of the next OS will be :) > obviously, but I would do something like: > > Select * from Win32_OperatingSystem where Version >= "6.0" > > What's the reasoning or issue behind this specific "weird" question? :) > > /Alain > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA > aka Ebitz - SBS Rocks [MVP] > Sent: Sunday, January 21, 2007 1:24 PM > To: ActiveDir@mail.activedir.org > Subject: Re: [ActiveDir] WMI and >Vista > > But can you do a detection of Vista and Vista+next OS? > > It's a weird request I know > > Alain Lissoir wrote: > >> Btw, if the goal is just to detect, Vista (and not the SKU a I replied >> below), then: >> >> Select * from Win32_OperatingSystem where Version = "6.0" >> >> will make it. >> The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). >> >> 5.0 Windows 2000, all flavors (SKU) >> 5.1 XP 32-bit, all flavors (SKU) >> 5.2 XP 64-bit if client, Windows Server 2003 if Server >> 6.0 Windows Vista, all flavors >> 6.0 Longhorn Server for now, but this may change ... Still under >> > development > >> as you know. >> >> HTH. >> /Alain. >> >> -Original Message- >> From: Alain Lissoir [mailto:[EMAIL PROTECTED] >> Sent: Sunday, January 21, 2007 11:46 AM >> To: 'ActiveDir@mail.activedir.org' >> Subject: RE: [ActiveDir] WMI and >Vista >> >> Have you looked at the OperatingSystemSKU property? This is a property >> > added > >> in Vista to support the distinction between Vista Home, Ultimate, >> > Business, > >> etc ... >> http://msdn2.microsoft.com/en-gb/library/aa394239.aspx >> >> OperatingSystemSKU Data type: uint32 >> >> Stock Keeping Unit (SKU) number for the operating system. >> >> Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This >> property is not available. >> >> Possible SKU values are: >> >> Value Meaning >> 0 Undefined >> 1 Ultimate Edition >> 2 Home Basic Edition >> 3 Home Basic Premium Edition >> 4 Enterprise Edition >> 5 Home Basic N Edition >> 6 Business Edition >> 7 Standard Server Edition >> 8 Datacenter Server Edition >> 9 Small Business Server Edition >> 10 Enterprise Server Edition >> 11 Starter Edition >> 12 Datacenter Server Core Edition >> 13 Standard Server Core Edition >> 14 Enterprise Server Core Edition >> 15 Enterprise Server IA64 Edition >> 16 Business N Edition >> 17 Web Server Edition >> 18 Cluster Server Edition >> 19 Home Server Edition >> 20 Storage Express Server Edition >> 21 Storage Standard Server Edition >> 22 Storage Workgroup Server Edition >> 23 Storage Enterprise Server Edition >> 24 Server For Small Business Edition >> 25 Small Business Server Premium Edition >> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, >> > CPA > >> aka Ebitz - SBS Rocks [MVP] >> Sent: Sunday, January 21, 2007 11:00 AM >> To: ActiveDir@mail.activedir.org >> Subject: [ActiveDir] WMI and >Vista >> >> If one wanted to build a WMI query that would capture Vista "and" any >> other workstation OS after Vista... how would one build that query? >> >> I know that this will capture Vista: >> Select * from Win32_OperatingSystem where Version = "6.0.6000" >> >> But will this catch any version of Vista after XP if, on the odd chance >> they change the build number? >> >> I know that you can also add a ProductType=1 that captures the >> workstation only and not servers. >> >> But how can you build a WMI query string for Group policy filtering that >> is smart enough to capture Vista OS and whatever comes out after Vista >> (and yes, they are already looking for ideas for the next version see >
Re: [ActiveDir] WMI and >Vista
A very highly academic question to see if there's a way to even build such a filter :-) Alain Lissoir wrote: It is hard to guarantee what the version # of the next OS will be :) obviously, but I would do something like: Select * from Win32_OperatingSystem where Version >= "6.0" What's the reasoning or issue behind this specific "weird" question? :) /Alain -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 1:24 PM To: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] WMI and >Vista But can you do a detection of Vista and Vista+next OS? It's a weird request I know Alain Lissoir wrote: Btw, if the goal is just to detect, Vista (and not the SKU a I replied below), then: Select * from Win32_OperatingSystem where Version = "6.0" will make it. The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). 5.0 Windows 2000, all flavors (SKU) 5.1 XP 32-bit, all flavors (SKU) 5.2 XP 64-bit if client, Windows Server 2003 if Server 6.0 Windows Vista, all flavors 6.0 Longhorn Server for now, but this may change ... Still under development as you know. HTH. /Alain. -Original Message- From: Alain Lissoir [mailto:[EMAIL PROTECTED] Sent: Sunday, January 21, 2007 11:46 AM To: 'ActiveDir@mail.activedir.org' Subject: RE: [ActiveDir] WMI and >Vista Have you looked at the OperatingSystemSKU property? This is a property added in Vista to support the distinction between Vista Home, Ultimate, Business, etc ... http://msdn2.microsoft.com/en-gb/library/aa394239.aspx OperatingSystemSKU Data type: uint32 Stock Keeping Unit (SKU) number for the operating system. Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This property is not available. Possible SKU values are: Value Meaning 0 Undefined 1 Ultimate Edition 2 Home Basic Edition 3 Home Basic Premium Edition 4 Enterprise Edition 5 Home Basic N Edition 6 Business Edition 7 Standard Server Edition 8 Datacenter Server Edition 9 Small Business Server Edition 10 Enterprise Server Edition 11 Starter Edition 12 Datacenter Server Core Edition 13 Standard Server Core Edition 14 Enterprise Server Core Edition 15 Enterprise Server IA64 Edition 16 Business N Edition 17 Web Server Edition 18 Cluster Server Edition 19 Home Server Edition 20 Storage Express Server Edition 21 Storage Standard Server Edition 22 Storage Workgroup Server Edition 23 Storage Enterprise Server Edition 24 Server For Small Business Edition 25 Small Business Server Premium Edition -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 11:00 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] WMI and >Vista If one wanted to build a WMI query that would capture Vista "and" any other workstation OS after Vista... how would one build that query? I know that this will capture Vista: Select * from Win32_OperatingSystem where Version = "6.0.6000" But will this catch any version of Vista after XP if, on the odd chance they change the build number? I know that you can also add a ProductType=1 that captures the workstation only and not servers. But how can you build a WMI query string for Group policy filtering that is smart enough to capture Vista OS and whatever comes out after Vista (and yes, they are already looking for ideas for the next version see Steve Riley's blog with questions about firewalls in the next version if you don't believe me http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-imp rovements-would-you-like-in-windows-firewall-and-ipsec.aspx Also, can you do: select * from Win32_OperatingSystem where Caption contains "Vista" ? List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
RE: [ActiveDir] WMI and >Vista
It is hard to guarantee what the version # of the next OS will be :) obviously, but I would do something like: Select * from Win32_OperatingSystem where Version >= "6.0" What's the reasoning or issue behind this specific "weird" question? :) /Alain -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 1:24 PM To: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] WMI and >Vista But can you do a detection of Vista and Vista+next OS? It's a weird request I know Alain Lissoir wrote: > Btw, if the goal is just to detect, Vista (and not the SKU a I replied > below), then: > > Select * from Win32_OperatingSystem where Version = "6.0" > > will make it. > The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). > > 5.0 Windows 2000, all flavors (SKU) > 5.1 XP 32-bit, all flavors (SKU) > 5.2 XP 64-bit if client, Windows Server 2003 if Server > 6.0 Windows Vista, all flavors > 6.0 Longhorn Server for now, but this may change ... Still under development > as you know. > > HTH. > /Alain. > > -Original Message- > From: Alain Lissoir [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 21, 2007 11:46 AM > To: 'ActiveDir@mail.activedir.org' > Subject: RE: [ActiveDir] WMI and >Vista > > Have you looked at the OperatingSystemSKU property? This is a property added > in Vista to support the distinction between Vista Home, Ultimate, Business, > etc ... > http://msdn2.microsoft.com/en-gb/library/aa394239.aspx > > OperatingSystemSKU Data type: uint32 > > Stock Keeping Unit (SKU) number for the operating system. > > Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This > property is not available. > > Possible SKU values are: > > Value Meaning > 0 Undefined > 1 Ultimate Edition > 2 Home Basic Edition > 3 Home Basic Premium Edition > 4 Enterprise Edition > 5 Home Basic N Edition > 6 Business Edition > 7 Standard Server Edition > 8 Datacenter Server Edition > 9 Small Business Server Edition > 10 Enterprise Server Edition > 11 Starter Edition > 12 Datacenter Server Core Edition > 13 Standard Server Core Edition > 14 Enterprise Server Core Edition > 15 Enterprise Server IA64 Edition > 16 Business N Edition > 17 Web Server Edition > 18 Cluster Server Edition > 19 Home Server Edition > 20 Storage Express Server Edition > 21 Storage Standard Server Edition > 22 Storage Workgroup Server Edition > 23 Storage Enterprise Server Edition > 24 Server For Small Business Edition > 25 Small Business Server Premium Edition > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA > aka Ebitz - SBS Rocks [MVP] > Sent: Sunday, January 21, 2007 11:00 AM > To: ActiveDir@mail.activedir.org > Subject: [ActiveDir] WMI and >Vista > > If one wanted to build a WMI query that would capture Vista "and" any > other workstation OS after Vista... how would one build that query? > > I know that this will capture Vista: > Select * from Win32_OperatingSystem where Version = "6.0.6000" > > But will this catch any version of Vista after XP if, on the odd chance > they change the build number? > > I know that you can also add a ProductType=1 that captures the > workstation only and not servers. > > But how can you build a WMI query string for Group policy filtering that > is smart enough to capture Vista OS and whatever comes out after Vista > (and yes, they are already looking for ideas for the next version see > Steve Riley's blog with questions about firewalls in the next version if > you don't believe me > http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-imp > rovements-would-you-like-in-windows-firewall-and-ipsec.aspx > > Also, can you do: > select * from Win32_OperatingSystem where Caption contains "Vista" ? > > > > > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.activedir.org/ma/default.aspx > > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.activedir.org/ma/default.aspx > > List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
Re: [ActiveDir] WMI and >Vista
But can you do a detection of Vista and Vista+next OS? It's a weird request I know Alain Lissoir wrote: Btw, if the goal is just to detect, Vista (and not the SKU a I replied below), then: Select * from Win32_OperatingSystem where Version = "6.0" will make it. The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). 5.0 Windows 2000, all flavors (SKU) 5.1 XP 32-bit, all flavors (SKU) 5.2 XP 64-bit if client, Windows Server 2003 if Server 6.0 Windows Vista, all flavors 6.0 Longhorn Server for now, but this may change ... Still under development as you know. HTH. /Alain. -Original Message- From: Alain Lissoir [mailto:[EMAIL PROTECTED] Sent: Sunday, January 21, 2007 11:46 AM To: 'ActiveDir@mail.activedir.org' Subject: RE: [ActiveDir] WMI and >Vista Have you looked at the OperatingSystemSKU property? This is a property added in Vista to support the distinction between Vista Home, Ultimate, Business, etc ... http://msdn2.microsoft.com/en-gb/library/aa394239.aspx OperatingSystemSKU Data type: uint32 Stock Keeping Unit (SKU) number for the operating system. Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This property is not available. Possible SKU values are: Value Meaning 0 Undefined 1 Ultimate Edition 2 Home Basic Edition 3 Home Basic Premium Edition 4 Enterprise Edition 5 Home Basic N Edition 6 Business Edition 7 Standard Server Edition 8 Datacenter Server Edition 9 Small Business Server Edition 10 Enterprise Server Edition 11 Starter Edition 12 Datacenter Server Core Edition 13 Standard Server Core Edition 14 Enterprise Server Core Edition 15 Enterprise Server IA64 Edition 16 Business N Edition 17 Web Server Edition 18 Cluster Server Edition 19 Home Server Edition 20 Storage Express Server Edition 21 Storage Standard Server Edition 22 Storage Workgroup Server Edition 23 Storage Enterprise Server Edition 24 Server For Small Business Edition 25 Small Business Server Premium Edition -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 11:00 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] WMI and >Vista If one wanted to build a WMI query that would capture Vista "and" any other workstation OS after Vista... how would one build that query? I know that this will capture Vista: Select * from Win32_OperatingSystem where Version = "6.0.6000" But will this catch any version of Vista after XP if, on the odd chance they change the build number? I know that you can also add a ProductType=1 that captures the workstation only and not servers. But how can you build a WMI query string for Group policy filtering that is smart enough to capture Vista OS and whatever comes out after Vista (and yes, they are already looking for ideas for the next version see Steve Riley's blog with questions about firewalls in the next version if you don't believe me http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-imp rovements-would-you-like-in-windows-firewall-and-ipsec.aspx Also, can you do: select * from Win32_OperatingSystem where Caption contains "Vista" ? List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
RE: [ActiveDir] WMI and >Vista
Btw, if the goal is just to detect, Vista (and not the SKU a I replied below), then: Select * from Win32_OperatingSystem where Version = "6.0" will make it. The Vista RTM build is "6.0.6000" regardless of the SKU (Vista Flavor). 5.0 Windows 2000, all flavors (SKU) 5.1 XP 32-bit, all flavors (SKU) 5.2 XP 64-bit if client, Windows Server 2003 if Server 6.0 Windows Vista, all flavors 6.0 Longhorn Server for now, but this may change ... Still under development as you know. HTH. /Alain. -Original Message- From: Alain Lissoir [mailto:[EMAIL PROTECTED] Sent: Sunday, January 21, 2007 11:46 AM To: 'ActiveDir@mail.activedir.org' Subject: RE: [ActiveDir] WMI and >Vista Have you looked at the OperatingSystemSKU property? This is a property added in Vista to support the distinction between Vista Home, Ultimate, Business, etc ... http://msdn2.microsoft.com/en-gb/library/aa394239.aspx OperatingSystemSKU Data type: uint32 Stock Keeping Unit (SKU) number for the operating system. Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This property is not available. Possible SKU values are: Value Meaning 0 Undefined 1 Ultimate Edition 2 Home Basic Edition 3 Home Basic Premium Edition 4 Enterprise Edition 5 Home Basic N Edition 6 Business Edition 7 Standard Server Edition 8 Datacenter Server Edition 9 Small Business Server Edition 10 Enterprise Server Edition 11 Starter Edition 12 Datacenter Server Core Edition 13 Standard Server Core Edition 14 Enterprise Server Core Edition 15 Enterprise Server IA64 Edition 16 Business N Edition 17 Web Server Edition 18 Cluster Server Edition 19 Home Server Edition 20 Storage Express Server Edition 21 Storage Standard Server Edition 22 Storage Workgroup Server Edition 23 Storage Enterprise Server Edition 24 Server For Small Business Edition 25 Small Business Server Premium Edition -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 11:00 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] WMI and >Vista If one wanted to build a WMI query that would capture Vista "and" any other workstation OS after Vista... how would one build that query? I know that this will capture Vista: Select * from Win32_OperatingSystem where Version = "6.0.6000" But will this catch any version of Vista after XP if, on the odd chance they change the build number? I know that you can also add a ProductType=1 that captures the workstation only and not servers. But how can you build a WMI query string for Group policy filtering that is smart enough to capture Vista OS and whatever comes out after Vista (and yes, they are already looking for ideas for the next version see Steve Riley's blog with questions about firewalls in the next version if you don't believe me http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-imp rovements-would-you-like-in-windows-firewall-and-ipsec.aspx Also, can you do: select * from Win32_OperatingSystem where Caption contains "Vista" ? List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
RE: [ActiveDir] WMI and >Vista
Have you looked at the OperatingSystemSKU property? This is a property added in Vista to support the distinction between Vista Home, Ultimate, Business, etc ... http://msdn2.microsoft.com/en-gb/library/aa394239.aspx OperatingSystemSKU Data type: uint32 Stock Keeping Unit (SKU) number for the operating system. Windows Server 2003, Windows XP, Windows 2000, and Windows NT 4.0: This property is not available. Possible SKU values are: Value Meaning 0 Undefined 1 Ultimate Edition 2 Home Basic Edition 3 Home Basic Premium Edition 4 Enterprise Edition 5 Home Basic N Edition 6 Business Edition 7 Standard Server Edition 8 Datacenter Server Edition 9 Small Business Server Edition 10 Enterprise Server Edition 11 Starter Edition 12 Datacenter Server Core Edition 13 Standard Server Core Edition 14 Enterprise Server Core Edition 15 Enterprise Server IA64 Edition 16 Business N Edition 17 Web Server Edition 18 Cluster Server Edition 19 Home Server Edition 20 Storage Express Server Edition 21 Storage Standard Server Edition 22 Storage Workgroup Server Edition 23 Storage Enterprise Server Edition 24 Server For Small Business Edition 25 Small Business Server Premium Edition -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] Sent: Sunday, January 21, 2007 11:00 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] WMI and >Vista If one wanted to build a WMI query that would capture Vista "and" any other workstation OS after Vista... how would one build that query? I know that this will capture Vista: Select * from Win32_OperatingSystem where Version = "6.0.6000" But will this catch any version of Vista after XP if, on the odd chance they change the build number? I know that you can also add a ProductType=1 that captures the workstation only and not servers. But how can you build a WMI query string for Group policy filtering that is smart enough to capture Vista OS and whatever comes out after Vista (and yes, they are already looking for ideas for the next version see Steve Riley's blog with questions about firewalls in the next version if you don't believe me http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-imp rovements-would-you-like-in-windows-firewall-and-ipsec.aspx Also, can you do: select * from Win32_OperatingSystem where Caption contains "Vista" ? List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
[ActiveDir] WMI and >Vista
If one wanted to build a WMI query that would capture Vista "and" any other workstation OS after Vista... how would one build that query? I know that this will capture Vista: Select * from Win32_OperatingSystem where Version = "6.0.6000" But will this catch any version of Vista after XP if, on the odd chance they change the build number? I know that you can also add a ProductType=1 that captures the workstation only and not servers. But how can you build a WMI query string for Group policy filtering that is smart enough to capture Vista OS and whatever comes out after Vista (and yes, they are already looking for ideas for the next version see Steve Riley's blog with questions about firewalls in the next version if you don't believe me http://blogs.technet.com/steriley/archive/2007/01/18/it-s-your-turn-what-improvements-would-you-like-in-windows-firewall-and-ipsec.aspx Also, can you do: select * from Win32_OperatingSystem where Caption contains "Vista" ? List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ma/default.aspx
