sccm logo 600x400

SCCM Collection based on Active Directory Organisation Unit (OU) Membership

You may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL code and then simply amend the last part to be the Organisation Unit that you want to base the Collection on: SELECT SMS_R_USER.ResourceID, SMS_R_USER.ResourceType, SMS_R_USER.Name, SMS_R_USER.UniqueUserName, SMS_R_USER.WindowsNTDomain FROM SMS_R_User WHERE…

Read More
System Center Configuration Manager SCCM

System Center Technical Preview VHD Downloads Available

Microsoft have recently released the System Center Technical Preview Evaluation VHD’s for you to to take a look at and launch using your Hyper-V environment. DOWNLOADS You can download the VHD’s using the links below for the following products: Data Protection Manager Evaluation VHD Operations Manager Evaluation VHD Orchestrator Evaluation VHD Service Manager Evaluation VHD…

Read More
sccm logo

SCCM Query – Report on Distribution Point Statuses

In Configuration Manager 2012, there is a section under the Monitoring ribbon called Distribution Status. This will give you a lot of information about your distributions and your distribution points. If you look at Distribution Point Configuration Status, this gives you a good understanding of whether your drivers, packages, applications and images have deployed correctly…

Read More
sql2016

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

We have had a report that one of our WQL queries has not been working correctly, this is the one for devices that have Configuration Manager client installed but do not have System Center Endpoint Protection installed on them. The original post is here: WQL Query for Devices without Endpoint Installed So, we have looked…

Read More