Office Service Pack via PowerShell (WMI)

I can retrieve the OS service pack via WMI with Powershell without a problem.
However, finding the Service Pack for Office is proving to be a bit more
difficult. I need to script this out and so far, have not been able to do so.

Any ideas?
Thanks!
Wes

Assuming you are trying to query remote computers you can use the following code to remotely query the registry:


$cn="computername"

$rk = [microsoft.win32.registrykey]:penremotebasekey([Microsoft.Win32.RegistryHive]::LocalMachine,$cn)



#Office 2007

$rr = $rk.opensubkey("SOFTWARE\Microsoft\Office\12.0\Common\ProductVersion")

$rr.getvalue("LastProduct")



#Office 2003

$rr = $rk.opensubkey("SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion")

$rr.getvalue("LastProduct")


For a chart of the different versions and the service pack level they correspond to:

http://support.microsoft.com/kb/928116 For Office 2007
http://support.microsoft.com/kb/821549 For Office 2003


Gaurhoth





"stahlerw" <stahlerw@discussions.microsoft.com> wrote in message news:950CF751-E943-44E9-9DBB-7FF9A6375A6D@microsoft.com...
>I can retrieve the OS service pack via WMI with Powershell without a problem.
> However, finding the Service Pack for Office is proving to be a bit more
> difficult. I need to script this out and so far, have not been able to do so.
>
> Any ideas?
> Thanks!
> Wes

Thanks Gaurhoth.


"Gaurhoth" wrote:

> Assuming you are trying to query remote computers you can use the following code to remotely query the registry:
>
>
> $cn="computername"
>
> $rk = [microsoft.win32.registrykey]:penremotebasekey([Microsoft.Win32.RegistryHive]::LocalMachine,$cn)
>
>
>
> #Office 2007
>
> $rr = $rk.opensubkey("SOFTWARE\Microsoft\Office\12.0\Common\ProductVersion")
>
> $rr.getvalue("LastProduct")
>
>
>
> #Office 2003
>
> $rr = $rk.opensubkey("SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion")
>
> $rr.getvalue("LastProduct")
>
>
> For a chart of the different versions and the service pack level they correspond to:
>
> http://support.microsoft.com/kb/928116 For Office 2007
> http://support.microsoft.com/kb/821549 For Office 2003
>
>
> Gaurhoth
>
>
>
>
>
> "stahlerw" <stahlerw@discussions.microsoft.com> wrote in message news:950CF751-E943-44E9-9DBB-7FF9A6375A6D@microsoft.com...
> >I can retrieve the OS service pack via WMI with Powershell without a problem.
> > However, finding the Service Pack for Office is proving to be a bit more
> > difficult. I need to script this out and so far, have not been able to do so.
> >
> > Any ideas?
> > Thanks!
> > Wes