Checking Windows Version is greater that WINXP2

[nicob2k 0]

Hello,

This is my First topic :-) so I'd like to thanks you in advance for all the support you can give me.

I've develop an Installer that automatically install MS SQL SERVER 2005 Express, but some of my clients are running Windows version that is not compatible. In this case, I need to install MSDE.

NB : MS SQL SERVER 2005 Express need at least WIN XP SP2

I'm having trouble finding the OS build number for all Windows product!

Using the @OSBuild function I know that win XP have the @OSBuild = 2600

I don't want to install all version of windows to found this number....

Does anyone have a list?

Thanks a lot

Nicolas

[weaponx 11]

See how this works.

MsgBox(0,"","Service Pack: " & ServicePackLevel())

Func ServicePackLevel()
    $wbemFlagReturnImmediately = 0x10
    $wbemFlagForwardOnly = 0x20
    $colItems = ""
    $strComputer = "localhost"

    $objWMIService = ObjGet("winmgmts:\\" & $strComputer & "\root\CIMV2")
    $colItems = $objWMIService.ExecQuery("SELECT * FROM Win32_OperatingSystem", "WQL", $wbemFlagReturnImmediately + $wbemFlagForwardOnly)

    If IsObj($colItems) then
       For $objItem In $colItems
          Return $objItem.ServicePackMajorVersion
       Next
    Else
       Return 0
    Endif
    
    Return 0
EndFunc

[nicob2k 0]

After a look on the internet, I found that build number is gradually higher since Windows 98 (probably before, but I don't really mater for my script). So I only do :

CODE

If @OSBuild = 2600 AND @OSServicePack = "Service Pack 2" or @OSBuild > 2600 then

;Install SQL 2005 Express

Else

;Install MSDE

EndIf

PS/ Thanks weaponx for your help, but I think that the @OSServicePack is simpler to use ...

[weaponx 11]

You should take out the first condition, i'm pretty sure SP2 build number is 2900

[SmOke_N 201]

See how this works.

MsgBox(0,"","Service Pack: " & ServicePackLevel())

Func ServicePackLevel()
    $wbemFlagReturnImmediately = 0x10
    $wbemFlagForwardOnly = 0x20
    $colItems = ""
    $strComputer = "localhost"

    $objWMIService = ObjGet("winmgmts:\\" & $strComputer & "\root\CIMV2")
    $colItems = $objWMIService.ExecQuery("SELECT * FROM Win32_OperatingSystem", "WQL", $wbemFlagReturnImmediately + $wbemFlagForwardOnly)

    If IsObj($colItems) then
       For $objItem In $colItems
          Return $objItem.ServicePackMajorVersion
       Next
    Else
       Return 0
    Endif
    
    Return 0
EndFunc

There is an @OSServicePack.