[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Powershell Script to get Outlook/Office Version and Service Pack Info on Our Domain

Posted on 2012-04-10
8
Medium Priority
?
8,141 Views
Last Modified: 2013-02-28
Hi  ,

I want to write a powershell script to know the MS Office Version and Service Pack Info on the desktop machine . We have about 4000 machines on our network.

The current script gives me only the version number :


foreach ($computer in (Get-Content ipaddress.txt)) {
  foreach ($computer ) {
  $version = 0
  $reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $computer)

  $reg.OpenSubKey('software\Microsoft\Office').GetSubKeyNames() |% {
    if ($_ -match '(\d+)\.') {
      if ([int]$matches[1] -gt $version) {
        $version = $matches[1]
      }
    }    
  }
  if ($version) {
      "$computer : found $version"
    }
    else {
      "Could not find version for $computer"
  }
}


Any ideas ?
0
Comment
Question by:MOITExperts
6 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37828136
service pack information is in the version number... you have to detect which version means what.... see below for details of sp1 changes to version

http://support.microsoft.com/kb/928116/
0
 

Author Comment

by:MOITExperts
ID: 37828174
Yep you are right but the issue i am having with the script above is i just get version numbers as 12,14,13 etc .

And that does not help me in finding the service pack info.

I am just doing a match using the registry and check the version ... i am not able to find the service pack info

Thanks
-Shreyas
0
 
LVL 6

Expert Comment

by:slidingfox
ID: 37828321
foreach ($computer in (Get-Content ipaddress.txt)) {

    $officever = ''
    $officesp = ''

    $reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('ClassesRoot', $computer)

    $reg = $reg.OpenSubKey('Word.Application\CurVer').GetValue('')
     
    if ($reg.EndsWith(11)) {
     
        $officever = 'Office 2003'
        $sp = (Get-ItemProperty HKLM:\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion).LastProduct

        if ($sp -like '11.0.8*') {
            $officesp = 'Service Pack 3'
        } elseif ($sp -like '11.0.7*') {
            $officesp = 'Service Pack 2'
        } elseif ($sp -like '11.0.6*') {
            $officesp = 'Service Pack 1'
        } else {
            $officesp = 'No Service Pack'
        }        
       
     
    } elseif ($reg.EndsWith(12)) {
       
        $officever = 'Office 2007'
        $sp = (Get-ItemProperty HKLM:\SOFTWARE\Microsoft\Office\12.0\Common\ProductVersion).LastProduct
       
        if ($sp -like '12.0.66*') {
            $officesp = 'Service Pack 3'
        } elseif ($sp -like '12.0.64*') {
            $officesp = 'Service Pack 2'
        } elseif ($sp -like '12.0.62*') {
            $officesp = 'Service Pack 1'
        } else {
            $officesp = 'No Service Pack'
        }
     
    } elseif ($reg.EndsWith(14)) {
   
        $officever = "Office 2010"
        $sp = (Get-ItemProperty HKLM:\SOFTWARE\Microsoft\Office\14.0\Common\ProductVersion).LastProduct
     
        if ($sp -like '14.0.60*') {
            $officesp = 'Service Pack 1'
        } else {
            $officesp = 'No Service Pack'
        }  
     
    }
   
Write-Output "$officever $officesp"
     
}
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
LVL 6

Expert Comment

by:slidingfox
ID: 37828451
Apologies, forgot to add the computername to the output. Replace the Write-Output line with

"$computer - $officever $officesp"
0
 

Author Comment

by:MOITExperts
ID: 37829032
Thank you for the script but this again helps me in retrieving the version but when i go through the loop where it checks for service pack i get an error

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\Office\14.0\Common\ProductVersion' because it does not ex
ist.
+  $sp = (Get-ItemProperty <<<<  HKLM:\SOFTWARE\Microsoft\Office\14.0\Common\ProductVersion).LastProduct
    + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...\ProductVersion:String) [Get-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.GetItemPropertyCommand

So i did open the registry and i did try to find the "Productversion" under /software/microsoft/common/

There was no file and hence it was not able to compare the string so everytime i get this error and output is returned as "Office 200x No Service Pack found "

Once Again Thank you for your help !!!
0
 
LVL 4

Accepted Solution

by:
Eric Woodford earned 2000 total points
ID: 38046629
get-logonstatistics "mailbox"  | select  UserName, Clientversion 

Open in new window


Will tell what client version that they just logged on to their mailbox with.

Username  ClientVersion
Eric W             14.0.6109.5000

You can search Technet to get exactly what patch/hotfix this relates to.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
Organisation is organized in a pattern to flow the day to day business, every application and system is interdepended on each other and when very important “Exchange Server downtime” happened.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question