Topic Last Updated—August 2008
The following sections describe the procedures necessary to import both Microsoft and non-Microsoft software licensing information into the Configuration Manager 2007 SP1 site database using the Asset Intelligence License Import Wizard.
When importing software licenses from license information files into the site database, the site server computer account requires full control NTFS permissions to the file share that will be used to import software license information.
 Important |
|---|
| When software license information is imported into the site database, existing software license information is overwritten. Ensure that the software license information file used with the Asset Intelligence License Import Wizard contains a complete listing of all necessary software license information. |
For more information about using the Asset Intelligence License Import Wizard, see How to Import Software License Information.
 Note |
|---|
| The information in this topic applies only to Configuration Manager 2007 SP1 and later. |
Importing Microsoft Volume Licensing (MVLS) Software License Information
Microsoft software license information can be imported into the Asset Intelligence catalog directly from a Microsoft licensing spreadsheet. Before importing software license information, the MVLS spreadsheet must be converted to an .xml file. The following procedure describes how to convert an MVLS licensing spreadsheet file to .xml format using Microsoft Office Excel.
| Important |
|---|
| Either Microsoft Office Excel 2003 or Microsoft Office Excel 2007 can be used to complete this procedure. However, if you attempt to convert an MVLS spreadsheet created in Microsoft Office Excel 2003 (.xls) with Microsoft Office Excel 2007 (.xlsx), this procedure will fail. Before beginning this procedure, ensure that the MVLS statement file type is the same as the version of Microsoft Office Excel that will be used. |
To Convert a Microsoft Volume Licensing Statement to .xml Format
-
Open the MVLS spreadsheet with Microsoft Office Excel and ensure that the License Summary tab is selected.
-
From the Microsoft Office Excel file menu, save the file in .xml format. When using Microsoft Office Excel 2003, the file created should be saved as an XML Spreadsheet formatted file. When using Microsoft Excel 2007, the file created should be saved as an XML Spreadsheet 2003 formatted file.
-
Copy the .xml file to the file share that will be used to import software license information into the Asset Intelligence catalog using the Asset Intelligence License Import Wizard.
-
From within the Configuration Manager console, use the Asset Intelligence License Import Wizard to import the newly created .xml license information file.
-
Run the Asset Intelligence License 14A – Microsoft Volume Licensing Reconciliation Report to verify that the licensing information has been successfully imported into the Asset Intelligence catalog.
Importing non-Microsoft Volume Licensing (MVLS) Software License Information
Non-Microsoft software license information can also be imported into the Asset Intelligence catalog using a manually created license import file in .csv file format. When creating a non-Microsoft license import file, the information in the following table can be used to describe software licenses to be imported into the Asset Intelligence catalog. Name, Publisher, Version, Language, Effective Quantity, PO Number, Reseller Name, Date of purchase, Support purchased (1 or 0), Support Expiration Date, and Comments.
| Column Name | Data Type | Required | Example |
|---|---|---|---|
|
Name |
Up to 255 characters |
Yes |
Software title |
|
Publisher |
Up to 255 characters |
Yes |
Software publisher |
|
Version |
Up to 255 characters |
Yes |
Software title version |
|
Language |
Up to 255 characters |
Yes |
Software title language |
|
EffectiveQuantity |
Integer value |
Yes |
Number of licenses purchased |
|
PONumber |
Up to 255 characters |
No |
Purchase order information |
|
ResellerName |
Up to 255 characters |
No |
Reseller information |
|
DateOfPurchase |
Date value in the following format: Month/Day/Year. |
No |
Date of license purchase. |
|
SupportPurchased |
Bit value |
No |
0 or 1 Enter 0 for Yes or 1 for No. |
|
SupportExpirationDate |
Date value in the following format: Month/Day/Year. |
No |
End date of purchased support. |
|
Comments |
Up to 255 characters |
No |
Optional comments |
| Note |
|---|
| While only the Name, Publisher, Version, and EffectiveQuantity fields are required to contain data, all fields must be entered on the first row of the license import file. All date fields should be displayed in the following format: Month/Day/Year as in this example: 8/4/2008. |
The following procedure describes the process that can be used to create a non-Microsoft software license import file using Microsoft Office Excel.
To Create a non-Microsoft License Import File Using Microsoft Office Excel
-
Open Microsoft Office Excel and create a new spreadsheet.
-
On the first row of the new spreadsheet, enter all software license data field names.
-
On the second and subsequent rows of the new spreadsheet, enter software license information as required. Ensure that at least all of the required software license data fields are entered on subsequent rows for each software license to be imported. The software title name entered in the spreadsheet must be the same as the software title that is displayed in Resource Explorer for a client computer after hardware inventory has run.
-
From the Microsoft Office Excel file menu, save the file in .csv format.
-
Copy the .csv file to the file share that will be used to import software license information into the Asset Intelligence catalog using the Asset Intelligence License Import Wizard.
-
From within the Configuration Manager console, use the Asset Intelligence License Import Wizard to import the newly created .csv license information file.
-
Run the Asset Intelligence License 15A – Third Party Software Reconciliation Report to verify that the licensing information has been successfully imported into the Asset Intelligence catalog.