SCCM | Alex Ø. T. Hansen

Alex Ø. T. Hansen

05/07/2018

SCCM – Create Device Collections Based On Security Groups

I’m back again, with a quick how-to on SCCM.

Have you ever needed to create device collections based on security groups (user accounts) in Active Directory? -Well look no further!
You can use the following WQL in a collection.
Only thing you need to change is the SMS_R_User.UserGroupName=”CONTOSO\\mysecuritygroup”.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
from SMS_R_System
JOIN SMS_UserMachineRelationship ON  SMS_R_System.Name=SMS_UserMachineRelationship.ResourceName
JOIN SMS_R_User ON  SMS_UserMachineRelationship.UniqueUserName = SMS_R_User.UniqueUserName
WHERE   SMS_UserMachineRelationship.Types=1  AND   SMS_R_User.UserGroupName="CONTOSO\\mysecuritygroup"

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client

from SMS_R_System

JOIN SMS_UserMachineRelationship ON SMS_R_System.Name=SMS_UserMachineRelationship.ResourceName

JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName = SMS_R_User.UniqueUserName

WHERE SMS_UserMachineRelationship.Types=1 AND SMS_R_User.UserGroupName="CONTOSO\\mysecuritygroup"

Alex Ø. T. Hansen

18/06/2018

SCCM – Cloud Management Gateway and Cloud Distribution Point

The cloud management gateway (CMG) provides a simple way to manage Configuration Manager clients on the internet. By deploying the CMG as a cloud service in Microsoft Azure, you can manage traditional clients that roam on the internet without additional infrastructure. You also don’t need to expose your on-premises infrastructure to the internet.

A cloud-based distribution point is a System Center Configuration Manager distribution point that is hosted in Microsoft Azure. The following information is intended to help you learn about configurations and limitations for using a cloud-based distribution point.

In this step-by-step guide, I will demonstrate how to configure and establish a Cloud Management Gateway (CMG) and Cloud Distribution Point (CDP) in SCCM and Azure.

In order to walk you through the entire process of setting up the Cloud Management Gateway and Cloud Distribution Point features, I am going to break this down into 6 parts.

Overview
Certificates
Azure Service
Cloud Management Gateway
Cloud Distribution Point
Log Files

Alex Ø. T. Hansen

29/02/2016

SCCM – Image Capture – Error 0x00004005

I had to capture a Windows 7 image in SCCM. When I tried to capture the image, i was getting the following error.

Task Sequence: Image Capture Wizard has failed with the error code (0x00004005)

The solution was pretty easy. It turned out that it was the product key that couldn’t be activated.

Alex Ø. T. Hansen

04/02/2016

SCCM – Task Sequence – Error: 0x80070490

Recently I have been doing a lot of SCCM work and deploying tests.
Some of the clients I tried to run a task sequence to, gave me the following error 0x80070490.

Alex Ø. T. Hansen

21/01/2016

SCCM 2012 R2 – Where are the client log files?

Lately I have been testing a new deployment sequence of Windows 10 from the System Center Configuration Manager (SCCM) 2012 R2.
There was a lot of new things to try, and therefor potential for errors.

Under each deployment failure I needed to look in the client logs, to investigate the problem.