In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
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 … Read more
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 … Read more
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 … Read more
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. … Read more
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
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 … Read more
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
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 … Read more
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
If you need to find a machine for a particular user in your business using SCCM, one way you can do it is to use a custom query to find the machine that relates to the last logged on user. This means that you can run this query, it’ll prompt for a username, enter the … Read more
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
UPDATE : Get WMI Query v1.6 Now Released You can use WMI for various things but one of its uses is for identifying the model name of a machine so that it can be later used for Configuration Manager OSD or maybe even for Group Policy WMI security. To find out the model name of a … Read more