SCCM 2007 has some great reports such as 14A and 14B which allow you to view how many and what computers are using a license from you volume license agreements, and what software you are under licensed for.

But first you will need to get you license details from Microsoft into SCCM. If you read the documentation on how to do this it pretty much says go to the Licensing poratl and download your licenses without an explanation of how, the below aims to explain this further.

Obtain Information from the Microsoft Licensing Portal

1) First you will need a computer with Internet Explorer 7.x or greater and Excel 2003 or greater
2) Open Excel
2a) Excel 2003 – choose “Import External Data” and then “New Web Query” and go to
2b) Excel 2007 – Choose “Data” and THEN “From Web” and go to
3) Login to site with credentials that hold most if not all microsoft agreements
4) Then choose “View the new License Summary” on the screen that appears will be atable with product information
5) Next to the word “Product Pool” there will a tick or selection box to select table on the left hand side, when you click on it the “Click to delect table will appears now click on import button and click “OK” to the next dialog box that appears

Edit Excel Document

You now need to make following changes to document

1) Delete Sheet 2 and 3
2) Name the Sheet License Data
3) Delete Column A
4) For each cell in column C (excluding theheader) adding the character ‘ before the data so Excel treats it as a string not a number
5a) Excel 2003– Save file as XML Spreadsheet (*.XML) to network share
5b) Excel 2007– Save file as XML Spreadsheet 2003 (*.XMl) to network share

Import Data to SCCM

1) Log onto your SCCM server
2) Open z command prompt and change to the following directory C:\Program Files\MicrosoftConfiguration Manager\bin\i386
3) Now run following

cmd mvlsimport /file <UNC path of the MVLS XML file saved above>


cmd mvlsimport /file\\Fileserver\share\test1.xml

And hit Enter

View Report Data

1) Run SCCM reports
i) License 14A – Microsoft Volume Licensing Reconciliation Report
ii) License 14B – List of Microsoft Software Inventory not found in MVLS