In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and … Read more
If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System … Read more
Most users in organisations believe that Google Earth is a great tool for their work and freely install it on their work machines and think nothing of it. Well, Google Earth is NOT free for commercial use and if business users want to use Google Earth for work purposes on work machines, then a licence … Read more
If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. This WQL query can then be used as part of an import function to create a device collection within SCCM. More Queries Our full range of SQL and WQL … Read more
Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just a tutorial for how to gather your OWN PAID FOR serial numbers using SCCM, it seems this is not good enough for NitroPDF or Google. So, we have had to … Read more
If you need to create standalone media for any of your task sequences within SCCM, you may find that you have to use a large capacity memory stick. I have found that when I’ve tried to use a 64GB memory stick or above, the Create Stand Alone Media process always fails. So to get round … Read more
If you have Configuration Manager 2012 and you are using SQL Reporting, you may want to create some custom reports. In your Configuration Manager 2012 Console, you can browse to Monitoring, then into the Reporting module. This will display all the reports that are currently available to you. If you want to create a custom … Read more
I was recently given a tip on how to speed up the MDT Toolkit Package part when running the Operating System Deployments within my SCCM environment. This is a simple yet effective change that slightly speeds things up if you have MDT integration enabled. The change is turning off a built in setting to delay … Read more
I recently have had some issues with machines not PXE booting for me to be able to deploy an image to new machines. I couldn’t quite figure it out as all of our worldwide sites were working perfectly and the office I was working at was also working in one part of the building but … Read more
We recently expanded SCCM Console access to a number of additional users. Before access was granted, each user completed a short training session, and their SCCM permissions were heavily restricted as expected. However, several machines began displaying an error when launching the SCCM Console: Cannot connect to the SCCM database If you’re an SCCM administrator, … Read more
As stated in my previous post, I have been asked recently about installing Endpoint Protection (SCEP) during the SCCM OSD process. This is pretty easy to do and the knock on affect is that you also can have SCEP available to install from your Software Catalog. To prepare the SCEP software for deployment in your … Read more
]I’ve had a few requests recently asking whether it is possible to install System Center Endpoint Protection (SCEP) during the task sequence for an operating system deployment. I’ve also been asked if it is possible to put SCEP into the Software Catalog. Well, the answer to both questions is yes and I’ll be breaking the … Read more