Configurar Asset Inteligence para importar dados de Licenciamento


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

Esse post foi publicado em SMS 2003 / SCCM 2007. Bookmark o link permanente.

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do

Você está comentando utilizando sua conta Sair /  Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair /  Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair /  Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair /  Alterar )


Conectando a %s