Configuration Manager 2007 and 2012 allows you to import licens information from a CSV file. The data are shown in the License 15A – General License Reconciliation Report. The problem for many is, that it’s often a bit to difficult to create the CSV file in the correct format. Highly inspired by the CM2007 AILW utility we decided to create our own tool and make it work for both Configuration Manager 2007 and the upcoming 2012 version.

You can download the utility here.

Configuring the utility

Once you have downloaded our utility you have to:

  1. Copy CT-AILW.exe to C:\Program Files\Coretech\AILW\ CT-AILW.exe (you need to create the folder manually).
  2. Copy e1db6caa-40cb-49f0-a744-21ca930b419f\e1db6caa-40cb-49f0-a744-21ca930b419f.xml to <D>:\Program Files\Microsoft Configuration Manager\Admin\e1db6caa-40cb-49f0-a744-21ca930b419f\e1db6caa-40cb-49f0-a744-21ca930b419f.xml to <D>:\Program Files\Microsoft Configuration Manager\ Admin Console\XmlStorage\Extensions\Actions\ e1db6caa-40cb-49f0-a744-21ca930b419f\e1db6caa-40cb-49f0-a744-21ca930b419f.xml (notice, you need to create the Actions folder manually).
  3. Restart the Configuration Manager Console.

How it works

Using the tool is pretty easy, all you need to know is the name, vendor and version of the application. Those information can be found in the Resource Explorer.

  1. Restart the Configuration Manager administrator console and navigate to the Asset and Compliance workspace.
  2. Click Edit 3rd Party Licenses on the Ribbon. 
    image
  3. Type the name of the Configuration Manager site server and click Connect to Database.
    image
  4. Make sure you are on the Edit tab. Scroll down to the end and enter a new product:
    image
  5. Select the Commit tab and click Commit to SCCM.

    image

  6. Run the report License 15A – General License Reconciliation Report

    image

Credits goes to Claus Codam, who has been the main developer on this project.