SCCM – Last logged on user query – All Systems

SCCM – Last logged on user query – All Systems

If you are looking for a query that will display all machines and their last logged on user, the below will do this for you without any prompts. This allows you to search on the data to find what you would like across the information provided by the query. The query below is the full […]

SCCM Query to create collection for x86 & x64 machines

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 […]

Prompt for Computer Name during SCCM OSD

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. […]

SCCM Asset Intelligence & Software Licensing Usage

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 […]

SCCM Management Points not working – SMS Agent Host Service

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 […]

SCCM – SQL Query for showing number of different Operating Systems

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 […]

Run Packages and Task Sequences directly from Distribution Point in SCCM

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 […]

Free Anti-Virus Software

Free Anti-Virus Software

One of the perils of working in IT is that I am constantly asked by friends and family the age old question; What is the best free anti-virus software? Well, there’s plenty of free anti-virus software out there and there is not really an answer to this question – there is no “best” anti-virus software, only […]

Renew a Self Signed Certificate on an Exchange Server 2007

Renew a Self Signed Certificate on an Exchange Server 2007

If you are using an Exchange system and have self signed certificates, every year you will have to renew the certificate. An expired certificate may cause problems such as connectivity to web services, SMTP transport and Outlook prompting certificate security warnings which is extremely annoying for users and also can cause problems with Out of Office settings. To do this is very […]

Windows XP Sysprep ready for SCCM OSD Capture Guide

Windows XP Sysprep ready for SCCM OSD Capture Guide

This guide will show you what you need to do to capture a Windows XP Service Pack 3 image, which you can then capture and deploy using Configuration Manager.First of all, you need to create a full  image that is ready to be captured. This is usually best to install on a virtual machine using […]

Scroll to top