Update Rollup 1 for System Center Configuration Manager current branch, version 1606 available

Hello!

Our folks of ConfigMgr Product Team relased an Update Rollup for the 1606 version of Current Branch.

Here is the announcement:

https://blogs.technet.microsoft.com/configurationmgr/2016/09/07/update-rollup-1-for-system-center-configuration-manager-current-branch-version-1606-is-now-available/

And here the specifications of what improve/fix:

https://support.microsoft.com/en-us/kb/3186654

Regards!

Anuncios

Federation with ADFS 3.0 and SNI Support

Hello!!

Some times I found problems with mobile devices trying to authenticate to ADFS when these are managed by Intune+ConfigMgr.

The problem is that exists a problem with the SNI.

Below I put a link where is well explained.

https://newsignature.com/articles/federation-adfs-3-0-sni-support

https://blogs.technet.microsoft.com/applicationproxyblog/2014/06/19/how-to-support-non-sni-capable-clients-with-web-application-proxy-and-ad-fs-2012-r2/

Regards

Available Update 1606 for System Center Configuration Manager

Hi!

Good news! yesterday was announced the availability of ConfigMgr Current Branch 1606. This is not a minor update and comes with a lot of improvements focused on Security, Device Management, ConfigMgr Monitoring, Service and Updates Node options, Application management, etc…

https://blogs.technet.microsoft.com/enterprisemobility/2016/07/22/now-available-update-1606-for-system-center-configuration-manager/

https://technet.microsoft.com/en-US/library/mt752488.aspx

Some of new features are:

  • Windows Information Protection (formerly EDP) features allow you to create and deploy information protection policy, including the ability to choose your protected apps and define your EDP-protection level.

 

  • Windows Defender Advanced Threat Protection features enable the ability to on-board and off-board Windows 10 clients to the cloud service and view agent health in the monitoring dashboard (requires a Windows Defender ATP tenant in Azure).

 

  • Windows Store for Business Integration allows you to manage and deploy applications purchased through the Windows Store for Business portal for both online and offline licensed apps.

 

  • Windows Hello for Business policies for domain-joined Windows 10 devices managed by the Configuration Manager client.

 

More info about Current Branch:

https://technet.microsoft.com/en-us/library/mt622084.aspx

https://blogs.technet.microsoft.com/enterprisemobility/2016/06/30/the-fastest-customer-upgrade-to-configmgr-ever/

Regards!

SCCM query to populate Device collection

Hi!

In SCCM if you want to build a Device Query based on their OS version you can apply the following query:

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   where    SMS_R_System.OperatingSystemNameandVersion like “%workstation%”   and SMS_R_System.OperatingSystemNameandVersion like “%6.2%” and SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

Where %workstation% is to populate only workstations but if you prefeer servers change it for %server%

Where %6.2% is the OS version. In the below link you will find the OS version that you are loooking for, change it on the query 🙂

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724832(v=vs.85).aspx

And also, if you need to know the architecture, you can indicate if 64 or 32 bits indicating “x86-based PC” or “x64-based PC” 

Regards!

 

Creating Device Query based on Language ID in SCCM

Hi!

To create a collection populated with computers based on their language ID use the following query:

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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.OSLanguage = 3082

Where 3082 is the language ID that you are interested.

In the following link you can find all language IDs

https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

Regards!

SCCM Colections based on computer arquitecture

Hello,

In SCCM we can do querys based on computer arquitecture. If we need to make a colection that shows all x86 OS versions or x64 we can do the following query:

x86:

select distinct 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
inner join
SMS_G_System_COMPUTER_SYSTEM
on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

x64:

select distinct 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
inner join
SMS_G_System_COMPUTER_SYSTEM
on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC”

Regards!