This is only for SMS 2003 SP3 not ConfigMgr, ConfigMgr will be updated when SP1 is released in the not too distant future.

Direct Download or Source.

Brief Description

This package will update the Asset Intelligence catalog and bring the knowledge base to the level of SCCM 2007 RTM. It contains additional software titles and several additional updates that make the content more accurate and relevant.

Overview

Asset Intelligence enhances the inventory capabilities of SMS 2003 SP3 by extending hardware and software inventory. Many inventory classes improve the breadth of information gathered about hardware and software assets. This update, which is mentioned in the SMS 2003 SP3 help file, is the first periodic update to the Asset Intelligence Knowledge Base tables, containing newly released software information. Please note that this will update the SMS 2003 SP3 Asset Intelligence knowledge base and bring it to the same content level as SCCM 2007 RTM. This update is not intended for SCCM and is limited to SMS 2003 SP3. An update for SCCM 2007 will be provided with SCCM 2007 SP1.

Instructions

This update can be installed directly on the SQL server or from a remote machine. Please note that installation instructions differ from local to remote installation.
IMPORTANT:
Bulk Copy Program (BCP) must be installed on the system you are running the AICU.msi on.

This can be the client or server on which you are executing this update MSI.

You can check this by running “bcp ?” from command prompt

If you see error stating that “bcp is not recognized as an internal or external command, operable program or batch file”, then bcp is NOT installed and you can’t proceed.
You can install BCP as part of the SQL client tools If you opt to run this update package (i.e. AICU.msi) on a remote machine then you will need to supply 2 parameters:

Name of the SQLServer and Name of the SMS Site DB.

DO NOT use quotes or braces around the SQL server name or the DB name in parameters.
HOW TO USE:
On a remote machine:

Verify BCP is installed

Copy the update MSI and verify you have administrator rights on the SQL server hosting the SMS DB

Run the following command (again, the client you are running this on, must have bcp): AICU.msi SQLSERVER=[Sql Server Name] SITEDB=[DB Name]
On the local SMS SQL Server (i.e. if you are running the MSI on the Site Server)

You do not need to specify any parameters.

Run the MSI update package
In both cases, a single log file will be generated

See C:\AI\BCP_OSQL_LOGS says: 207189 rows affected.

Look for the phrase ‘Install success!!’

Regards,
Anthony

Anthony Clendenen | Solutions Engineer | 1E

http://configmgr.com

© Anthony Clendenen