WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
Document ID : WP1004-001 Version 1.0 - lundi 3 mai 2010 Status : Validated - Diffusion : Free Author : Aurélien BONNIN © Copyright vNext – This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
General Information about this document Modification History Date
Version
Author(s)
Approved by
Description
29/04/2010
1.0
Aurélien Bonnin
Aurélien Bonnin
Création Document
Diffusion Type Diffusion Free
Prénom Nom
Fonction PDF
References Reference
Date - Version
Importing Software Licenses Into the Asset Intelligence Catalog http://technet.microsoft.com/en-us/library/cc431362.aspx
01/08/2008
Add Microsoft Licenses (MVLS) to SCCM Asset Inventory http://blogs.catapultsystems.com/javery/archive/2010/02/22/addmicrosoft-licenses-mvls-to-sccm-asset-inventory-1.aspx
22/02/2010
Disclaimer This Document is provided “AS IS” and has been checked for errors and any inaccuracies; the steps described in it have been tested in validation and production environments and the procedure is refined to perfection. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. We “vNext” hold no responsibility for any damages or/and loss happened from the incorrect usage of these instructions. By continuing to read this guide you “Agree” to accept any risks and demand nothing from the Author.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 2 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
Summary 1. INTRODUCTION ............................................................................................................................ 4 2. GENERATE MICROSOFT SOFTWARE LICENSES CUSTOM XML FILE .............................................................. 5 3. IMPORT MICROSOFT SOFTWARE LICENSES DATA INTO ASSET INTELLIGENCE CATALOG ................................. 19 4. VERIFY THAT THE LICENSING INFORMATION HAS BEEN SUCCESSFULLY IMPORTED ......................................... 24
- oOo -
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 3 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
1. Introduction This guide explains how to generate custom XML file containing Microsoft Software Licenses information from the MVLS portal so that it can be imported then in Asset Intelligence Catalog through the “Import Software Licenses” wizard of Configuration Manager 2007.
This guide will describes each operation required on SCCM Site Servers and on a workstation. Following operation have been validated on System Center Configuration Manager 2007 Service Pack 1 R2 English version with the International Client Pack 2 installed (version 4.00.6221.1000) and on Microsoft Office Professional Plus 2010 (version 14.0.4536.1000 64-bit).
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 4 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
2. Generate Microsoft Software Licenses custom XML file The first step will be to generate the custom XML file containing Microsoft Software Licenses Information.
Prerequisites - User Account with access to Software Licenses Information on MVLS web site - Desktop computer with access to Internet and with Microsoft Office Professional Plus 2010 (especially Excel Professional Plus 2010). - Required Site Systems for Asset Intelligence module already installed and configured.
1. Open Microsoft Excel 2010.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 5 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 2. Rename “Sheet 1” to “License Summary”. Rename “Sheet 2” to “License Data”. Finally, delete “Sheet 3”.
3. Navigate to the “License Data” worksheet, select the “Data” tab in the ribbon, and then click on the “From Web” button.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 6 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 4. In the “New Web Query” window, enter the following URL in the Address bar and click on the “Go” button. https://www.microsoft.com/licensing/servicecenter/
5. At the top right of the Window, click on “Sign In” button, and then enter your credentials. This user account must be allowed to access Microsoft License information on the MVLS web site and must be a Windows Live ID passport.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 7 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 6. On the “Volume Licensing Service Center” web page, select the “View the new License Summary” option in the middle of the page.
7. The “License Summary” table is shown, with detailed information about Products, License Product Family, License Version, Effective Quantity, Quantity Unresolved, Quantity Active and SA Quantity. On the top left corner of this table, you will able to select the entire table, just clicking on the table border (one click select the table, a second click deselect it). An information message indicates you if you are selecting or deselecting the table.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 8 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 8. Once you have selected the table, click on the “Import” button of the In “New Web Query” window and then click on “OK”. Be sure that the “Import Data” dialog box is configured to import date in the “Existing Worksheet” in the “$A$1” cell. Then Microsoft License Information data are inserted in the “License Data” worksheet (this process can take 1 or 2 minutes).
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 9 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
9. Delete the Column “A” of the “License Data” worksheet. You will have the following column in the “License Data” worksheet : - Product Pool - License Product Family - License Version - Effective Quantity - Unresolved Quantity - Active SA Quantity Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 10 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 10. Then, Select the “License Summary” worksheet, select the “A1” cell, go to “Insert” section in the ribbon, and click on the “PivotTable” icon.
11. In the “Create PivotTable” dialog box, select the “Select a table or range” option and then click on the “ ” button to select required cells range. Go to the “License Data” worksheet and select all columns and lines containing Microsoft License Information data, including columns header. Then click again on the “ ” button. Check that the “Existing Worksheet” option is selected in the “Choose where you want the PivotTable report to be placed” section and click on the “OK” button on the “Create PivotTable” dialog box. PivotTable is inserted in the “License Summary” worksheet.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 11 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
12. In the “PivotTable Field List” window, at the top right corner of the Excel worksheet, select the 6 following fields: “Product Pool”, “License Product Family”, “License Version”, “Effective Quantity”, “Unresolved Quantity”, “Active SA Quantity”. Data are automatically added in the “License Summary” worksheet during field selection process.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 12 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
13. At the bottom of the “PivotTable Field List” window, in the “Drag fields between areas below” section, drag-and-drop fields listed in the “Values” section to the “Row Labels” section. Before After
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 13 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 14. In the “Row Labels” section, click on a field and select “Fields Settings” option from the contextual menu.
15. In the “Field Settings” dialog box, on the “Subtotals & Filters” tab, select the “None” option from the “Subtotals” section. In the “Field Settings” dialog box, on the “Layout & Print” tab, select the “Show item labels in tabular form” option from the “Layout” section.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 14 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 16. Perform the previous operations (Cf. step 14 and 15) for each field listed in the “Row Labels” section. 17. Now, the “License Summary” worksheet looks like this.
18. On the “PivotTable Tools” section of the ribbon, select the “PivotTable Option” drop down list.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 15 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 19. In the “PivotTable options” dialog box, on the “Totals & Filters” tab deselect the “Show grand totals for rows” and “Show grand totals for columns” options.
20. In the “PivotTable options” dialog box, on the “Display” tab select the “Classic PivotTable layout (enables dragging or field in the grid)” option. And then click “OK”.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 16 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 21. On the “License Data” worksheet, modify each numeric only valued in the “Product Version” column to be preceded with a ' character. Before
After
22. Finally, save the file as an .xlsx file so that you can use it the next time you want to import Microsoft License Information. You will have to perform only steps 3 to 9 and then 23.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 17 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 23. Save the file as an “XML Spreadsheet 2003 (*.xml)” file so that you can use this file to import data in Asset Intelligence Catalog on your SCCM Primary Site Server. In the informational message dialog box, click “YES” to save the file without incompatible features. Then close the Excel Workbook.
While you have performed all these operations you will have a Microsoft Software Licenses xml file like the following one.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 18 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
3. Import Microsoft Software Licenses Data into Asset Intelligence Catalog Once you have created your Microsoft Software Licenses Custom XML file, you’re able to import it in Configuration Manager 2007 and especially in Asset Intelligence Catalog. To perform this action you need access on your Configuration Manager 2007 Primary Site server, with required security rights to manage Asset Intelligence and import data in ConfigMgr Database.
Prerequisites - User Account with access to ConfigMgr Admin console and Asset Intelligence module - A Microsoft Software Licenses custom xml file copied on a shared folder on which the SCCM Primary Site server has full control.
1. Open the ConfigMgr Admin Console on your Primary SCCM Site server and navigate to the “Asset Intelligence” node
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 19 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 2. In the “Actions” panel on the right, select the “Import Software Licenses” option.
3.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
In the “Welcome” screen of the “Import Software Licenses” wizard, click on “Next”.
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 20 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 4. In the “Import” screen of the “Import Software Licenses” wizard, click on “Browse” button and navigate to the shared folder containing the Microsoft Software Licenses XML file. Select the XML file and then click on “Open”. Click on “Next”.
5. In the “Summary” screen of the “Import Software Licenses” wizard, verify details configuration and then click on “Next”.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 21 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 6. Import Licensing Statement into Asset Intelligence process is in progress.
7. Once the import process is done, you will obtain the following message. Finally you can close the Wizard.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 22 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
To import the XML file on the ConfigMgr Server, you can also do this using command line option of the mvlsimport tool located in the [ConfigMgrInstallDir]\bin\i386 folder and running the following command:
mvlsimport /file \\\\
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 23 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog
4. Verify that the licensing information has been successfully imported Once you have imported your Microsoft Software Licenses data in Asset Intelligence Catalog you have to check that these data are available in Configuration Manager Database and can be queried for exploitation operation. To perform this action you need access on your Configuration Manager 2007 Primary Site server, with required security rights to manage Asset Intelligence and import data in ConfigMgr Database.
Prerequisites - User Account with access to ConfigMgr Admin console and Asset Intelligence module (http://technet.microsoft.com/en-us/library/cc431400.aspx) - Microsoft Software Licenses data already imported in Asset Intelligence Catalog. - A functional Reporting Point site system
These data could be queried through the Reporting functionality of Configuration Manager and especially through Asset Intelligence Reports.
1. Open the ConfigMgr Admin Console on your Primary SCCM Site server and navigate to the “Asset Intelligence” node, and then select the “Asset Intelligence Reports”.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 24 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 2. In the central pane, among the Asset Intelligence Reports list, find the “License 14A – Microsoft Volume Licensing Reconciliation Report” report. Right-click on it and select the “Run” option from the contextual menu.
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 25 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 3. The targeted Report is launched in the ConfigMgr Administrator Console (or in Internet Explorer depending on your Reporting configuration). In the “Collection” field, select a collection object (using “Values” button or seize the Collection ID).
Then click on
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 26 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog 4. Finally the “License 14A – Microsoft Volume Licensing Reconciliation Report” report will show you Microsoft Volume Licensing Information as shown in the following exhibit.
In the previous Report you will find some information that must be explained. You will find just below some description about columns definition.
License Summary The License Summary shows the estimated Volume License entitlements per each Microsoft product family and version across all active and inactive Licensing IDs in your permission set. The License Summary is a real-time calculation that: - Applies all upgrade and maintenance-type licenses to full licenses acquired per Volume License programs, including Enterprise, Select, Select Plus, Open Value, and Open License programs. - Uses licensing rules and product release dates to produce the most favorable License Summary for the customer.
Effective Quantity The effective quantity is the number of license entitlements per product and version after upgrades have been applied. The effective quantity value allows you to determine whether your organization has license shortfalls and/or surpluses by product and version.
Unresolved Quantity An unresolved quantity appears when the number of upgrade licenses is greater than the underlying qualifying full licenses. An unresolved quantity can occur when information concerning licensing entitlements is incomplete. Common reasons for an unresolved quantity include: Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 27 sur 28 ID: WP1004-001
WHITEPAPER - CONFIGMGR2007 How to import Microsoft Software Licenses Data in Asset Intelligence Catalog - OEM or retail purchases: Full licenses acquired through OEM or retail purchases are not visible to Microsoft. - Incomplete list of Licensing IDs in Relationship Summary: Full licenses acquired per Licensing IDs that are missing from your Relationship Summary will not be included in your License Summary. -
Unused coverage: Coverage-type licenses (e.g., Maintenance, Upgrade Advantage, and Software Assurance) that are unused may be unresolved in terms of your full license quantity.
Active SA (Software Assurance) Quantity The active SA quantity is the number of licenses covered by Software Assurance (version upgrade protection) across all Microsoft Volume License programs, including Enterprise, Select, Select Plus, Open Value, and Open License programs. The active SA quantity includes all types of Software Assurance, including: - License and Software Assurance (L&SA) - Software Assurance (SA)
*** End of the document ***
Version 1.0 – Validated lundi 3 mai 2010 Diffusion : Free
© Copyright vNext - This document is exclusive property of vNext. This document, or any part thereof, must not be reproduced without the permission of vNext. 118-120, avenue de France - F75013 Paris - Tél : 01.46.46.14.86 - Fax : 01.46.46.10.00
Page 28 sur 28 ID: WP1004-001
