System Center

Migrate a System Center Orchestrator database to a different SQL Server

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

SQL Query to find members of an Active Directory Security Group

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

Creating Current User Registry Keys in a SCCM Package

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

CMTrace Bundled with Configuration Manager Client Install

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

SCCM OSD Stuck on “Just a moment…”

SCCM OSD Stuck on “Just a moment…”

We came across a problem with our SCCM OSD recently where it was getting through approximately half the build process and then seemingly getting stuck on “Just a moment…” before timing out and not completing the build. This was a bit of a head scratcher as there did not seem to be any crash or […]

How to create a MDT Package within SCCM

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

SCCM – Full list of web security proxy exceptions

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

SCCM – User Experience During Application Installation

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

SCCM – Active Directory Security Group Query for User Collection

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

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

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

SCCM – Create a device collection based on Exchange Server role

SCCM – Create a device collection based on Exchange Server role

Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new device collection and then use this query: select * from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name like “Microsoft Exchange%” Save the […]

Scroll to top