Method to cross reference from .CAB files to the KB#

Method to cross reference from .CAB files to the KB#

Postby mdlueck » 21.03.2017, 15:08

Greetings,

We manage updates via the individual KB# downloads. WSUS Offline seems to download raw .CAB files which are not numbered matching the KB# update it is actually tied to.

Is there a way to cross reference back to the KB# from the .CAB filename?

Specifically we are looking to validate our downloads of Office 2007 updates does not contain extra patches.

Our deployment strategy for Office 2007 is we deploy out the product using a customizing MST. Then right away deploy SP3. So I am looking to validate the necessary post SP3 updates. I believe we have some extras which are no longer necessary as they have actually been superceded by a subsequent update.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
mdlueck
 
Posts: 4
Joined: 21.03.2017, 14:23

Re: Method to cross reference from .CAB files to the KB#

Postby jonas » 22.03.2017, 14:18

Hello,
mdlueck wrote:Is there a way to cross reference back to the KB# from the .CAB filename?


I dont think so. If you exand the *.cab-file you get a M$ Software Package (*.msp) and a *.xml-file. The xml-file deliveres the office version (e.g. Sequence>14.0.7179.5000</Sequence for office 2010 at the end of the file.
If you expand the msp-file with 7zip you will see the file named !_StringData (without an extension). In this file you find the information you will see after installation under programs and features/installed updates e.g. "Update for Microsoft Office 2007 suites (KB3141535)". It is painstaking to examine the downloaded updates individually. However, you can orient yourself to the date of the files and their size. The updates for Office 2007 (or 2010) are significantly smaller than those for Office 2013/2016.

have fun and good luck!
jonas
jonas
 
Posts: 64
Joined: 30.05.2014, 11:51

Re: Method to cross reference from .CAB files to the KB#

Postby mdlueck » 22.03.2017, 18:14

Greetings jonas,

jonas wrote:If you expand the msp-file with 7zip you will see the file named !_StringData (without an extension). In this file you find the information you will see after installation under programs and features/installed updates e.g. "Update for Microsoft Office 2007 suites (KB3141535)".


Ahhh!!! So I downloaded the suite of patches for Office 2007 already. I will work through doing the inspection you outlined here and see if that is a way to cross reference.

Perhaps start with updates just prior to Office 2007 SP3, and roll forward date wise. Any single patch prior to the release of SP3 should probably be already included in SP3... I suspect.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
mdlueck
 
Posts: 4
Joined: 21.03.2017, 14:23

Re: Method to cross reference from .CAB files to the KB#

Postby aker » 22.03.2017, 20:06

If you've got the missing UpdateIds (as done by ListMissingUpdateIds.vbs), you could find out the file names using the CSV-files in .\client\ofc
Wer Rechtschreibfehler findet, darf sie behalten oder an den Meistbietenden versteigern. / Everybody finding a misspelling is allowed to sell it.
aker
aker
 
Posts: 2765
Joined: 02.03.2011, 15:32

Re: Method to cross reference from .CAB files to the KB#

Postby mdlueck » 25.07.2017, 03:59

Greetings jonas,

jonas wrote:If you expand the msp-file with 7zip you will see the file named !_StringData (without an extension). In this file you find the information you will see after installation under programs and features/installed updates e.g. "Update for Microsoft Office 2007 suites (KB3141535)". It is painstaking to examine the downloaded updates individually. However, you can orient yourself to the date of the files and their size.



So blowing dust off this question.

I did a fresh pull of the O2K7 updates today. Copied the entire resulting WSUSOfflineUpdate directory structure out of the VM up to our Samba server.

With my Linux host OS, I...

1)
Code: Select all
/mnt/ldslnx01/stage/WSUSOfflineUpdate/client/ofc/glb$ cabextract -daccess-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b.cab
access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b.cab: WARNING; possible 15648 extra bytes at end of file.
Extracting cabinet: access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b.cab
  extracting access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b/access-x-none.msp
  extracting access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b/access-x-none.xml

All done, no errors.


2)
Code: Select all
/mnt/ldslnx01/stage/WSUSOfflineUpdate/client/ofc/glb/access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b$ 7z e access-x-none.msp \!_StringData

7-Zip [64] 9.20  Copyright (c) 1999-2010 Igor Pavlov  2010-11-18
p7zip Version 9.20 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,2 CPUs)

Processing archive: access-x-none.msp

Extracting  !_StringData

Everything is Ok

Size:       526
Compressed: 20641280


3)
Code: Select all
/mnt/ldslnx01/stage/WSUSOfflineUpdate/client/ofc/glb/access-x-none_86ec1696dbc69a7a7357768477803c6eae644f0b$ mousepad \!_StringData


And there is found: KB3101544

Bingo! I have something I can cross reference to. Thanks very much! 8-)

Now to script automate the above prototype steps.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
mdlueck
 
Posts: 4
Joined: 21.03.2017, 14:23

Re: Method to cross reference from .CAB files to the KB#

Postby mdlueck » 26.07.2017, 02:13

.... And.... DONE!

Now I can cross reference against my packaged list.

There are significantly more than I have packaged to appease Windows Update that Office 2007 is fully patched. Odd...

KB Updates I have packaged for O2K7 - 58 Total:
Code: Select all
Starting... CMDline=rexx.exe C:\Distrib\LDSHotFix.rex U:\Distrib\WinXP\Packages\Apps\Microsoft\Office2007\HotFix\Office2007.hlf
Beginning LDSHotFix.rex
ReadFile -> U:\Distrib\WinXP\Packages\Apps\Microsoft\Office2007\HotFix\Office2007.hlf
Number of HotFixes to check: 58
Number of HotFixes needing to be installed: 0
Ending LDSHotFix.rex
Ending... CMDline=rexx.exe C:\Distrib\LDSHotFix.rex U:\Distrib\WinXP\Packages\Apps\Microsoft\Office2007\HotFix\Office2007.hlf RC=0


This tool downloaded the following .CAB patches - 213 Total:
Code: Select all
/mnt/ldslnx01/stage/WSUSOfflineUpdate/client/ofc/enu
KB2956076
KB2956076
KB2920812
KB2920812
KB957646

/mnt/ldslnx01/stage/WSUSOfflineUpdate/client/ofc/glb
KB3101544
KB3085584
KB2910978
KB3101544
KB2910978
KB2596614
KB3085584
KB2687423
KB2596825
KB2687423
KB3162051
KB3162051
KB2596763
KB2596763
KB2596902
KB2596902
KB3172532
KB2687424
KB2596861
KB3191907
KB3191894
KB3213537
KB3203477
KB3213537
KB3203477
KB3191907
KB2553154
KB2596927
KB2726958
KB2726958
KB2553154
KB3203484
KB3178693
KB2597969
KB2687424
KB3085538
KB2553313
KB2553313
KB2596650
KB3039798
KB3085538
KB3039798
KB2596670
KB2553405
KB3203397
KB2596670
KB2899516
KB2899516
KB2899516
KB2899516
KB2899516
KB2899516
KB2899516
KB2899516
KB2899473
KB2899473
KB3114833
KB3054793
KB3114833
KB3114426
KB3114414
KB3054793
KB3114414
KB2687440
KB3203463
KB3203463
KB2596792
KB2880971
KB2880508
KB2880971
KB2589288
KB2596804
KB2589288
KB2760272
KB2760272
KB2881029
KB2920727
KB2881067
KB3039794
KB2596754
KB2850016
KB2850016
KB2850022
KB3213624
KB3213555
KB3191944
KB3039779
KB3213624
KB3191944
KB3213555
KB3039779
KB3213640
KB3178667
KB3178667
KB3213545
KB3213545
KB3115103
KB3115103
KB3191943
KB3191943
KB3128043
KB3054816
KB3085528
KB3054816
KB3085549
KB3085528
KB2880507
KB2825645
KB2687497
KB2687497
KB2984943
KB2975808
KB3101520
KB2975808
KB3101520
KB3054984
KB3054984
KB2984938
KB3118389
KB3118389
KB3191848
KB3191848
KB3191828
KB3114885
KB3115256
KB3114885
KB3115256
KB3115419
KB3115419
KB3114456
KB3039782
KB3039782
KB3039746
KB3114690
KB2910941
KB2956063
KB2956110
KB2920748
KB3191938
KB2837618
KB3203467
KB3191932
KB3191932
KB2837618
KB3191898
KB3203467
KB3191938
KB3118378
KB3118378
KB3115487
KB3114518
KB3114518
KB3127888
KB3115487
KB2566456
KB3162069
KB3127894
KB3118382
KB2596912
KB3114395
KB2920680
KB3085561
KB3114395
KB3085561
KB2920680
KB2880506
KB2596904
KB3203385
KB2596810
KB2863836
KB2810069
KB2810069
KB2863836
KB2752096
KB2752096
KB2863854
KB2863854
KB3191844
KB3191844
KB3191837
KB3203427
KB2986253
KB3115120
KB3115135
KB3115135
KB3115120
KB3115153
KB3115153
KB2596915
KB2999465
KB2999465
KB3191908
KB3191908
KB3191829
KB3203464
KB3203393
KB3203393
KB3203464
KB3191945
KB3203441
KB2965313
KB2965313
KB3191945
KB3203438
KB3191909
KB2596871
KB3191897
KB3191833


Now I see that this tool auto downloaded patches for OneNote, which our edition is ProPlus which did not come with OneNote. But even OneNote does not significantly account for the quantity dependency.

Disappointed in the results findings at the moment.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
mdlueck
 
Posts: 4
Joined: 21.03.2017, 14:23


Return to Download

Who is online

Users browsing this forum: No registered users and 2 guests