Add Non-Microsoft licence information into SCCM 2012

In order to get the most out of your Microsoft System Center 2012 investment you’ll no doubt want to get the Asset Intelligence features of Configuration Manager (SCCM) working. You can add your Microsoft Volume licensing statement into SCCM but what if you want to add in non-Microsoft licences? Now I’m making an assumption here that you’ll already have software inventory enabled on your clients as this is a pre-requisite. If so read on.

  1. Firstly you’ll need to run the SCCM 2012 console and browse to Assets and Compliance>Overview>Asset Intelligence>Inventoried Software.
  2. Now in the main section of the window you should perform a search for the software you wish to add to your licence report.
  3. Once you have found the matching software you should make a note of the Product Name, Vendor and version number – it is important that you copy this exactly.
  4. You now need to create a csv file which looks like this. You must include all the header fields even if you don’t intend to use them.
    Name Publisher Version Language EffectiveQuantity PONumber ResellerName DateOfPurchase SupportPurchased SupportExpirationDate Comments
    MindManager Mindjet 2012 English 100 1234567 01/01/2013 This is just a test

    I have included an example attachment which can be found at the bottom of this post.
    Mandatory fields which must have data entered are as follows:
    Name, Publisher, Version, Language, EffectiveQuantity

  5. If you would like to add multiple versions or multiple products you can simply add another line to your CSV file with the relevant product information, just remember it has to match exactly what is found in inventoried software.
  6. Once you have created your CSV file and are happy with it, save it somewhere accessible by URL from your SCCM console.
  7. Now back in SCCM, browse to Assets and Compliance>Overview>Asset Intelligence. Right click Asset Intelligence and select Import Software Licenses.
  8. Click Next at the Import Software License Statement.
  9. Now choose General Licence Statement (.csv file) and enter your URL. (The exclamation will disappear when you add a valid URL)
  10. At the confirm the setting screen click Next. This will now import your licence information into the SCCM database.
  11. If the import is successful you will see the Completion screen.
  12. Now to ensure your import has worked you should browse to Monitoring>Overview>Reporting>Reports>Asset Intelligence.
  13. Select or search for the ‘License 15A – General license reconciliation’ report. Right click the report and click Run.
  14. Select your values by clicking the blue link and select your desired collection to report on.
  15. Now click the View Report button to see the report. If everything was completed correctly you should see your product name now listed alongside the licensing information for it.
    Licence15A report

Here is the csv file you can use as a template, but due to blog restrictions I have had to upload it as an xls. Simply change the file extension to csv. ManualLicense.xls

2 thoughts on “Add Non-Microsoft licence information into SCCM 2012

  1. Can we add both MVLS and general License into SCCM DB? Technet says “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”


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.