Prompt for Computer Name during SCCM OSD

System Center Configuration Manager SCCM

In previous blog posts I’ve put together a guide to automatically create the computer name in your OSD task sequences using MDT (see the link below..):

Automatically generate computer name during SCCM OSD

However, there is also a slightly more manual way of inputting your computer name during an OSD TS using a pop-up prompt.

To do this, complete the following steps, if you need any assistance, just post a comment at the bottom of this post.

Open your Configuration Manager console and go to the Assets and Compliance Workspace and then click on Device Collections.

Prompt for Computer Name during SCCM OSD 1

Right click on the collection you want to deploy the OS to then click Properties (for this guide I’m using All Unknown Computers). You then need to click on the Collection Variables tab.

Prompt for Computer Name during SCCM OSD 2

Click on the new button as circled below:

Prompt for Computer Name during SCCM OSD 3

In the variable name type OSDCOMPUTERNAME and leave the value areas blank and then click ok.

Prompt for Computer Name during SCCM OSD 4

Once you have this collection variable in your collection property settings, you can then deploy your OSD task sequence to this collection and you will be prompted to enter your computer name.

SCCM Asset Intelligence & Software Licensing Usage

microsoft black logo

This guide details how to add Products into the General Licence Statement to match up licence usages using Asset Intelligence.

What this means is that you can then use Asset Intelligence reports to see what your corporate software licence usages are against what you actually have purchased.


Open the Configuration Manager console. Go into the Asset and Compliance Workspace and then browse to Asset Intelligence > Inventoried Software:

SCCM Asset Intelligence & Software Licensing Usage 5

On the right side window, you should now see all the software that has been inventoried and are in the SCCM database. To use this information to produce software licensing reports, you have to ensure that you use the exact Product Name that is in this Inventoried Software location.

As an example, if you wanted to add Microsoft Project 2013 to your Software Licencing usage reporting, you need to do the following:

You can type in the search area under Inventoried Software the product that you are looking for, so in this case, we type “project”. As you can see below, this brings down the number of software titles to look through to find the right one, keep scrolling down until you find the software title you are looking for:

SCCM Asset Intelligence & Software Licensing Usage 6

Once you have found the software title, double click it to bring up a box that should be similar to the one below:

SCCM Asset Intelligence & Software Licensing Usage 7

There are three parts that you are interested in, the rest of just categories that are not important at this time. What you are looking for are:

  • Product Name
  • Vendor
  • Version

GLS Spreadsheet

For any reports to work, your import of the GLS spread sheet must match these settings perfectly.
So, once you have noted this information, you should open your GLS spread sheet that you have created. If you have not yet created one, you can download a template from here:

GLS Spread Sheet Template

Also be aware that the spreadsheets are in CSV format and should never be changed from this format.
In this guide, we’ll open up the GLS spreadsheet. When opened, it should look like this:

SCCM Asset Intelligence & Software Licensing Usage 8

Obviously, the more software titles that are added to it, the more rows that will be added.
You should take the next available free row and add in your information. You can fill out all area’s but only the three area’s as stated above are critical for this to work. However, you should correctly complete the EffectiveQuantity as this is the number of available licences to your business.

Once you have added your Project 2013 software title, the spread sheet should look like this (note that Publisher as labelled on the spread sheet is actually the Vendor from the software title):

SCCM Asset Intelligence & Software Licensing Usage 9

Once you have added the software titles that you want to add, you should save this spread sheet (remembering to keep the CSV format) to a network location where your console can access it.

You should then go back into the Configuration Manager console and back to the Asset Intelligence folder. Once there, right click on the Asset Intelligence folder and select Import Software Licenses.

Then click on the General Licence Statement (.csv file) radio button and then enter the network location of where you saved the GLS file to:

SCCM Asset Intelligence & Software Licensing Usage 10

Click next and complete the wizard. If your import has been successful, you should see the below summary page:

SCCM Asset Intelligence & Software Licensing Usage 11

Asset Intellegence

The import of your software titles to the asset intelligence system is now complete. To view this information, the report that you should use is:

Asset Intelligence > License 15A – General license reconciliation report
When you run this report now, it should show you all the information you require to tally up the licences. This information is presented in the report as:

  • Product Name
  • Version
  • Licence Quantity (which is the EffectiveQuantity value entered into the spread sheet)
  • Inventory Count (licences used)
  • Difference (left over/over used licences – calculated as Licence Quantity – Inventory Count)


If you have any questions about this article or any feedback you would like to leave, please leave us a message below in our comments section and we will get back to you as soon as possible.

SCCM Management Points not working – SMS Agent Host Service

sccm logo


Although the below does help, the issue I had was actually with the WCF 3.0 Windows Update. It was this that messed up our MPs, having applied the MS “fix” (or reg hack quick fix as it really is) we have not had an issue since.

I’ve had an issue for the last few days where my clients were not working correctly with the software catalog. Having checked their certificates they were set to none on the clients too.

I removed the management point on my primary server and then re-installed it, which seemed to have fixed it, however, the problem returned the following day. So, I re-installed the MP again, fixed it, but next day, problem returns!
Having looked into it further I found that the problem was with the SMS Agent Host service on the primary server. It kept stopping itself and taking the MP down with it. If I restarted it, everything worked, but every night it stop again.
After going through yet more endless logs I couldn’t really find any problem with the configuration, until I checked our CM2012 servers Endpoint Protection policy. It turned out that I forgotten to add the service and it’s executables to the excluded processes and files. So, I added them and I’ve not had a problem since. Obviously the problem was that Endpoint was stopping the service when the daily scans were happening.
For your reference, the two processes and files you need to exclude to avoid a similar issue are:
Next time, I’ll know where to start looking for any strange issues!

Adobe Reader MSI All Versions Download

Adobe Reader DC version 2001

There is an area on the Adobe website where you can download all versions of all updates in MSI format for Adobe Reader.

This means that you can take these MSI’s and create any version of supersedence using the guide below:

Supersede Guide

The link to the FTP website of Adobe is below:

Adobe Reader FTP Website

If you have any questions or need any help on supersedence, just leave a comment.

SCCM – SQL Query for showing number of different Operating Systems

microsoft black logo

If you would like to create a report to show you the number of different Operating System’s you have, you can use this script below which should provide you with the information for Servers and the various Windows OS’s. Query SELECT CASE WHEN Caption0 LIKE ‘%XP%’ THEN ‘XP’ WHEN Caption0 LIKE ‘%Windows 7%’ THEN ‘Windows … Read more

Run Packages and Task Sequences directly from Distribution Point in SCCM

sccm logo

You may have noticed when setting up task sequence deployments for your OSD‘s or when setting up packages for the Software Catalog that you cannot run the task or program directly from the distribution point as the only option is to download the files and run from the local cache.

Well, there is a setting that you can change to allow you to run your task sequences directly from the local distribution point. To change this, you should ensure that all your packages associated to your task sequence (or just your single package for the software catalog..) have the following box ticked:

Run Packages and Task Sequences directly from Distribution Point in SCCM 12

This will then allow you to change the settings under your deployment options to run from distribution point as well as download and run from the local cache.

Note that this does copy all the files in the package to your distribution points and will take up more space, so think about this before doing it.