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. Instructions Open the Configuration Manager console. Go into … Read more

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

SCCM Collection Queries

sccm logo

We have been building a number of collections within SCCM lately so we thought we would start to build up a reference here of various collections, some simple, some more complex. We will be adding to this when we can so make sure you come back and check for updates. Computers with certain prefixes – … Read more

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

sccm logo

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 … Read more

Orchestrator Runbook for Email Notification for ConfigMgr Software Catalog Requests

A futuristic IT automation concept featuring a digital workflow diagram on a high-tech screen. The screen should display interconnected nodes representing an Orchestrator Runbook process, wit

I’ve had a number of requests about how I created our email notification for requests for software made via our ConfigMgr software catalog. The solution is very simple and very basic, but until I get our Service Manager up and running (which does the job much better..), this is working for us so hopefully will … Read more