Topic last updated—March 2008

The Asset Intelligence catalog can be manually updated by downloading a catalog update Windows Installer (.msi) file from the Microsoft Download Center and installing it on the site database server.

Note
The Asset Intelligence catalog update file has a dependency on the SQL Server bulk copy program (bcp.exe). The bulk copy program is a stand-alone utility that is installed with Microsoft SQL Server client tools installations. If you receive an error stating that bcp is not recognized as an internal or external command, an operable program, or a batch file, while performing the procedures in this topic, it means that bcp is not installed on the computer used to update the Asset Intelligence catalog and the procedures will not succeed. For more information about the bcp, see "Importing and Exporting Bulk Data by Using the bcp Utility at http://go.microsoft.com/fwlink/?LinkId=111811.

The following procedures can be used both by Configuration Manager 2007 and by Configuration Manager 2007 SP1 Asset Intelligence administrators to update the Asset Intelligence catalog locally at the site database server or from a remote computer.

Note
The user account running the Asset Intelligence catalog update installation must have administrative rights to the SQL Server site database computer and site database to perform these procedures.

To manually update the Asset Intelligence catalog from a remote computer

  1. Verify that the SQL Server client tools are installed on the computer that will be used to update the SQL Server site database server computer.

  2. Download the Asset Intelligence catalog update Windows Installer (MSI) file (AICU.MSI) from the Microsoft download center, and save it to the local computer.

  3. Open a command prompt, and navigate to the directory that the Asset Intelligence catalog update file is saved in.

  4. At the command prompt, run the following command:

    AICU.MSI SQLServer=<site database server name> SITEDB=<site database name>

  5. Review the log file created in the <root drive> \ AI \ BCP_OSQL_LOGS directory to ensure that the update was successful.

To manually update the Asset Intelligence catalog at the site database server computer

  1. Verify that the SQL Server client tools are installed on the SQL Server site database server computer.

  2. Download the Asset Intelligence catalog update Windows Installer (MSI) file (AICU.MSI) from the Microsoft Download Center, and save it to the local computer.

  3. Double-click the AICU.MSI file to start the Asset Intelligence and License Management Catalog Update Setup Wizard.

  4. Continue through the wizard to update the Asset Intelligence catalog.

  5. Review the log file created in the <root drive> \ AI \ BCP_OSQL_LOGS directory to ensure that the update was successful.

See Also