Skip to content

Instantly share code, notes, and snippets.

@Spartan-196

Spartan-196/O365Channel.md

Last active March 25, 2024 17:30
Show Gist options
  • Save Spartan-196/1cff63d248d72beefad9743a0e3c496f to your computer and use it in GitHub Desktop.
Save Spartan-196/1cff63d248d72beefad9743a0e3c496f to your computer and use it in GitHub Desktop.
Download ZIP
O365 Channel SCCM Collection Query
Raw
O365Channel.md

Query language for SCCM machine collections based on what O365 Channel is configured on a PC.

Supplemental to the pretty graphs shown in managment console Software Library > Overview >Office 365 Client Management As SCCM's Office overview shows lovely graphs of how many of each channel you have installed but not actually which machines those are these querys can be used to make a collection to do that.

Monthly Channel

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_OFFICE365PROPLUSCONFIGURATIONS on SMS_R_System.ResourceID = SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID where SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.CDNBaseUrl = 'http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60'

Semi-Annual Channel

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_OFFICE365PROPLUSCONFIGURATIONS on SMS_R_System.ResourceID = SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID where SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.CDNBaseUrl = 'http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114'

Monthly Channel (Targeted)

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_OFFICE365PROPLUSCONFIGURATIONS on SMS_R_System.ResourceID = SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID where SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.CDNBaseUrl = 'http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be'

Semi-Annual Channel (Targeted)

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_OFFICE365PROPLUSCONFIGURATIONS on SMS_R_System.ResourceID = SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID where SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.CDNBaseUrl = 'http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf'

CDN URLs from MS Documentation https://docs.microsoft.com/en-us/sccm/sum/deploy-use/manage-office-365-proplus-updates#change-the-update-channel-after-you-enable-office-365-clients-to-receive-updates-from-configuration-manager

How to swtich from Semi-Annual to Monthly Chanels (really can go to any channel they just want you on monthly) https://support.microsoft.com/en-us/help/3185078/how-to-switch-from-semi-annual-channel-to-monthly-channel

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment