User State Migration Tool (USMT) during OSD Task Sequence SCCM 2012 SP1

I’ve been using ConfigMgr for many years now and I’ve used OSD in every version I’ve been involved with, however, for some reason, I’ve never used USMT before. In most cases this is simply because I didn’t need to use it as my only need was for bare metal deployments but, our environment is changing and I need to deploy …

User State Migration Tool (USMT) during OSD Task Sequence SCCM 2012 SP1 Read More

How to upgrade System Center Configuration Manager 2012 to SP1

This is a guide on upgrading System Center Configuration Manager 2012 to Service Pack 1 in a lab environment. Your setup may be slightly different so remember this is a guide, so if you have any questions, please feel free to leave a comment at the bottom of this post. Note that I am using the following setup: Domain Controller …

How to upgrade System Center Configuration Manager 2012 to SP1 Read More

SCCM – SQL Query for newly discovered devices in last 24 hours

This query for SCCM will tell you the devices that have been discovered by Configuration Manager in the last 24 hours. This query can be amended to change the amount of days you wish to look back at for newly discovered devices by changing the last digit in the code. SQL Query More Queries Our full range of SQL and …

SCCM – SQL Query for newly discovered devices in last 24 hours Read More

Find last logged on user by NetBIOS name – SCCM Query

I’ve been asked a lot of questions about the various ways of using queries and there are almost no limits to what you can do with a query and of course, you can then go on and use these queries for creating collections or just to supply you with the information you require. I have created some very basic queries …

Find last logged on user by NetBIOS name – SCCM Query Read More

SCCM Query to create collection for x86 & x64 machines

We have been asked on a number of occasions how to create Configuration Manager Collections for machines on x86 or x64 Windows Operating Systems. To do this, you should use the two collection queries as below: Instructions Query to create collection for x86 machines Query to create collection for x64 machines More Queries Our full range of SQL and WQL …

SCCM Query to create collection for x86 & x64 machines Read More

Prompt for Computer Name during SCCM OSD

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 …

Prompt for Computer Name during SCCM OSD Read More

SCCM Asset Intelligence & Software Licensing Usage

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. Instructions Open the Configuration Manager console. Go into the Asset and Compliance Workspace …

SCCM Asset Intelligence & Software Licensing Usage Read More

SCCM Management Points not working – SMS Agent Host Service

UPDATE 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 …

SCCM Management Points not working – SMS Agent Host Service Read More

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