Novell Home

Office97 Service Pack Updates and ZENworks 2

Novell Cool Solutions: Feature
By Jeff Campbell

Digg This - Slashdot This

Posted: 9 Jul 1999
 

Recently we were given a moment's notice to come up with a quick solution to a fairly common problem. We needed a way to check for the current version of MS Office 97 on any selected machine, and make available the appropriate Service Pack for that machine using an App Object in NDS. Microsoft currently has two service packs for Office 97 and they are required to be installed in a specific order. We found that with some of the new features in ZENworks 2.0 this task would be simple!

We did some simple research to find out what changes we could look for in the different service packs once installed. In order to do this, we used snAppShot. First we installed MS Office 97, without any service packs, onto a fresh machine and took the first snAppShot. After we applied each service pack, we took another snAppShot so that we had a total of three snAppShots. We examined the files that were added/changed in each snAppShot. We found that there were a few files that existed from the original install, but were updated with each application of a service pack. We took the following file and identified its file version stamp number from the original install and from the two service packs:

File: MSO97.DLL
  • Original install - 8.0.0.3507
  • Service Pack 1 - 8.0.0.4202
  • Service Pack 2 - 8.0.0.5425

After finding this information, it was very simple to construct an Application Object that would display/launch the appropriate Service pack to an end user. The following are the steps we took to create our Application Objects:

Original Install to Service Pack 1

  1. Create a new Application Object in NDS.
  2. In the Identification tab, set up a running path to the Service Pack 1 (sr1off97.exe.
  3. System Requirements:
    • Add a System requirement that checks for the existence of MSO97.DLL.
    • Add a System requirement that checks if the version number on MSO97.DLL is less than 8.0.0.4202.
    • Add a System Requirement that checks for Windows 95/98.
    • Add a System Requirement that checks for Windows NT.
  4. Make any other custom changes such as description, associations, etc.

Service Pack 1 to Service Pack 2

  1. Create a new Application Object in NDS.
  2. In the Identification tab, set up a running path to the Service Pack 2 (sr2aof97.exe).
  3. System Requirements:
    • Add a System Requirement that checks for the existence of MSO97.DLL.
    • Add a System Requirement that checks if the version number on MSO97.DLL is less than 8.0.0.5425.
    • Add a System Requirement that checks if the version number on MSO97.DLL is greater than or equal to 8.0.0.4202.
    • Add a System Requirement that checks for Windows 95/98.
    • Add a System Requirement that checks for Windows NT.
  4. Make any other custom changes such as description, associations, etc.

Important: It is important to note that the file version number that is displayed in the file properties dialog box of a DLL file is not always the appropriate file version number. It is better to use a program like this one I created, FileUtil.exe or something of the sort, to correctly identify the file version number. (Note: ZENworks only uses the File version, NOT the Product version.)

Here are the AXT files for the two App Objects we created, in case you want to try this yourself.

Office97spaxt.zip

About the Author

Jeff is part of the Application Launcher engineering team. He has a degree in Computer Science, and programmed for several major companies before joining Novell earlier this year. He is currently working on App Launcher Library, NT Service, and the App Launcher Workstation Agent. He is one of the team's most ardent gadget aficionados. For him the term "geek" was invented.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell