Migrate a System Center Orchestrator database to a different SQL Server

We were running through our list of servers and looking at what each one was doing in terms of Domain Controllers, Exchange servers, SQL servers, System Center servers etc when we noticed that we had quite a few servers that were using pretty small databases but had a large amount of host resource allocated to it. We also noticed that …

Migrate a System Center Orchestrator database to a different SQL Server Read More

SQL Query to find members of an Active Directory Security Group

We recently helped out with a data migration which included creating a completely new set of Active Directory security groups. They wanted all the members to have the same level of access but wanted all the new security groups to have a matching standard. So we needed to create all the new security groups and then add all the existing …

SQL Query to find members of an Active Directory Security Group Read More

Creating Current User Registry Keys in a SCCM Package

We were asked recently about how to use a SCCM package to amend current user registry keys (HCU). To be honest, we didn’t really know, HCU registry changes have always been a bit of a nightmare to manage. However, we started to have a look around and found an excellent guide on how to carry this out using a mixture …

Creating Current User Registry Keys in a SCCM Package Read More

CMTrace Bundled with Configuration Manager Client Install

CMTrace is an awesome tool and I have been copying it onto an end users machine using a batch file during the OSD process for years. But finally, Microsoft have added it into the Configuration Manager Client installation. So, once you have an up to date client installed on a users machine, you can browse to the following location: %windir%ccmcmtrace.exe …

CMTrace Bundled with Configuration Manager Client Install Read More

How to create a MDT Package within SCCM

As a SCCM administrator you are probably fully aware that you have a lot of power available to you when carrying out deployments using task sequences. But you can add even more options to SCCM task sequences by adding Microsoft Deployment Toolkit (MDT) integration. This gives you a load more options during a task sequence including a large number of …

How to create a MDT Package within SCCM Read More

SCCM – Full list of web security proxy exceptions

When using Configuration Manager, you may find that some things may not work fully if you are also behind a web security proxy service. We came across this problem recently where the Asset Intelligence Point was being blocked from contacting the internet due to web security. This caused this error in our Configuration Manager Console: So we started to investigate …

SCCM – Full list of web security proxy exceptions Read More

SCCM – User Experience During Application Installation

If you want your end user experience to show them the progress of an installation from your Software Center, then you will need to ensure that you have your command lines and user experience tab setup correctly. We have seen many people follow the “install in the background and don’t tell anyone the progress” method time and time again, however, …

SCCM – User Experience During Application Installation Read More

SCCM – 1802 Upgrade Released & How to get it now!

So Microsoft have today released version 1802 of Current Branch for Configuration Manager. This is great and there are some features in this upgrade that we are looking forward to trying out. But, on the slow ring, it could be a few days or weeks until it drops into your Configuration Manager Console. That’s bad. So, what can you do …

SCCM – 1802 Upgrade Released & How to get it now! Read More

SCCM – Active Directory Security Group Query for User Collection

If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. WQL Script To set this up, create a new collection and copy and paste this as its query: Variables You can add or remove any of the SMS_R_USER columns from …

SCCM – Active Directory Security Group Query for User Collection Read More

SCCM – Create user collections based on Active Directory department attribute with Powershell

We recently built a new Configuration Manager system for a client who wanted user collections for all departments and companies within their corporate group. We were going to set these up manually which is a fairly simple, but time consuming, job to do. But this was a time restricted installation so we had a quick Google and found an awesome …

SCCM – Create user collections based on Active Directory department attribute with Powershell Read More