Export (0) Print
Expand All

Importing Software Licenses Into the Asset Intelligence Catalog

Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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.

ImportantImportant
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.

noteNote
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.

ImportantImportant
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

  1. Open the MVLS spreadsheet with Microsoft Office Excel and ensure that the License Summary tab is selected.

  2. 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.

  3. 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.

  4. From within the Configuration Manager console, use the Asset Intelligence License Import Wizard to import the newly created .xml license information file.

  5. 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

noteNote
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

  1. Open Microsoft Office Excel and create a new spreadsheet.

  2. On the first row of the new spreadsheet, enter all software license data field names.

  3. 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.

  4. From the Microsoft Office Excel file menu, save the file in .csv format.

  5. 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.

  6. From within the Configuration Manager console, use the Asset Intelligence License Import Wizard to import the newly created .csv license information file.

  7. 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.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft