SCCM – SQL Query for showing number of different Operating Systems

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 7’ WHEN Caption0 LIKE ‘%Server …

SCCM – SQL Query for showing number of different Operating Systems Read More

Run Packages and Task Sequences directly from Distribution Point in SCCM

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 …

Run Packages and Task Sequences directly from Distribution Point in SCCM Read More

Office 2010 Language Pack Deployment in the Software Catalog for SCCM 2012

If you have a requirement to add any Office 2010 language packs to your SCCM 2012 Software Catalog then you may find that it is not the simplest of tasks. I’ve spent some time working on different methods of doing this and although creating the packs as an application and pushing them out is fairly simple, to offer them through …

Office 2010 Language Pack Deployment in the Software Catalog for SCCM 2012 Read More

Adobe Updates via Windows Updates

As you may have seen on some of my previous posts, you can update Adobe Flash Player and Adobe Reader X via Windows Updates using SCUP through WSUS/SCCM.  This stops the annoying pop-ups for users especially when they can’t install updates if they have not got local admin rights – just like standard Windows Updates, this process will take care of …

Adobe Updates via Windows Updates Read More

Install drivers by computer model using WMI query during SCCM OSD Task Sequence

You can install drivers by computer model using a WMI script during the SCCM OSD task sequence. This means that when you deploy an image, the target machine will always get the full and correct drivers for the model, rather than getting mismatched drivers. This also speeds up the deployment process. To do this is very easy and all you need …

Install drivers by computer model using WMI query during SCCM OSD Task Sequence Read More

Setting Computer Name automatically during OSD Process using SCCM and MDT

We have been looking into getting our OSD process to automatically change the computer name to what we want it to be for a while now but never really had much luck with it. Reading various forums and blogs, many people have said to use WSNAME and many others saying use scripts, all of which never seemed to quite work …

Setting Computer Name automatically during OSD Process using SCCM and MDT Read More

SCCM Task Sequence failed due to package associated to the task sequence cannot be found

If you get an issue when trying to load a task sequence and you get the message that a package associated to the task sequence cannot be found, even when it looks like all packages are fully distributed, then you need to check out the SMSTSLog.log file that is on the machine that you are trying to deploy the task …

SCCM Task Sequence failed due to package associated to the task sequence cannot be found Read More