Hotfix rollup for Asset Intelligence compatibility issues in System Center Configuration Manager 2007 SP2: March 2012

Symptoms

This hotfix rollup package resolves compatibility issues of Asset Intelligence in Microsoft System Center Configuration Manager 2007 Service Pack 2 (SP2) with other Microsoft volume license products. This hotfix rollup resolves the following issues and is dated March 2012:

The query for the Asset Intelligence "License 01A" report does not detect Microsoft System Center Configuration Manager 2007 licenses.
The query for the Asset Intelligence "License 01A" report does not detect Microsoft System Center Data Protection Manager 2010 licenses or Microsoft System Center Operations Manager 2007 R2 licenses.
The query for the Asset Intelligence "License 01A" report does not detect Microsoft Exchange Server 2003 licenses.
The query for the Asset Intelligence "License 01A" report does not detect Microsoft Visio 2010 edition changes after an upgrade operation.
The query for the Asset Intelligence "License 01A" report incorrectly reports some editions of Windows Server 2008 as Windows XP.
The query for the Asset Intelligence "License 06A" report does not detect Microsoft SQL Server 2005 licenses.
The query for the Asset Intelligence "License 06A" report detects Microsoft SQL Server 2005 licenses incorrectly on computers that have Microsoft SQL Server 2005 administration tools installed.
The query for the Asset Intelligence "Software 01A" report reports the instance count of Microsoft BizTalk Server 2010 incorrectly. The reported count is two times the number of instances.
The query for the Asset Intelligence "Software 01A" report reports the instance count of Microsoft Word 2010 incorrectly. The reported count is two times the number of instances.
The query for the Asset Intelligence "Software 01A" report reports the instance count of 64-bit versions of Microsoft SQL Server 2005 incorrectly.
Some Asset Intelligence data is not synchronized correctly in System Center Configuration Manager 2007 SP2 because of key constraint violations.
Configuration Manager 2007 SP2 does not report SQL Server 2008 R2 in the "License 01D" report after you install SQL Server 2008 R2 SP1.
Configuration Manager 2007 SP2 does not completely download and process Microsoft Product Code (MPC) catalog data. This may result in incomplete updates to the Asset Intelligence catalogs.

Resolution

To resolve these issues, install the following hotfix rollup package on the affected System Center Configuration Manager 2007 SP2 primary site server. The installation wizard for the package creates another package for clients. To deploy the package to all clients after you run the package on the primary site server, you have to create an advertisement.

Note The hotfix package can be installed on a System Center Configuration Manager 2007 SP2 site server that is running an x86-based or x64-based version of an operating system.

For more information about installation guide, click the following article number to view the article in the Microsoft Knowledge Base:

2477182 System Center Configuration Manager 2007 Hotfix Installation Guidance

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:

http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

To apply this hotfix, you must have System Center Configuration Manager 2007 Service Pack 2 (SP2) installed.

Registry information

To use the hotfix in this package, you do not have to make any changes to the registry.

Restart information

You do not have to restart the computer after you apply this hotfix.

Note You have to close Configuration Manager administration console before you install this hotfix package.

Hotfix replacement information

This hotfix replaces the following hotfixes:

2444668 Hotfix rollup for Asset Intelligence compatibility issues in System Center Configuration Manager 2007 SP2 with other Microsoft volume license products: November 2010

2536089 Hotfix rollup for Asset Intelligence compatibility issues in System Center Configuration Manager 2007 SP2: May 2011

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

File name	File version	File size	Date	Time	Platform
Aikbmgr.dll	4.0.6487.2204	124,776	01-Feb-2010	17:35	x86
Sccm2007ac-sp2-kb2659258-x86-enu.msp	Not Applicable	531,456	01-Feb-2010	17:05	Not Applicable
Update.sql	Not Applicable	23,226	01-Feb-2010	17:35	Not Applicable

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

This hotfix applies to the following roles in Configuration Manager 2007:

Primary Site
Secondary Site
Client

Note You cannot apply the hotfix on the SMS clients directly. You have to run the hotfix on the site server and then deploy the generated package to the clients.

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates