Extending OMS with SCCM Information

Brad Watts here to talk with you today about extending OMS with SCCM information. Microsoft Operations Management Suite (OMS) is a very powerful cloud based tool. There are bunch of out of the box solutions like Alert Management, Active Directory Assessment, SQL Assessment, Update Compliance, etc.. We’re not going into details of what OMS is…


Windows 10 1511 がソフトウェア更新プログラムのスキャンに失敗する

こんにちは。System Center Configuration Manager サポート チームです。   System Center Configuration Manager  (以下、SCCM ) クライアントがWindows 10 バージョン 1511 である場合、接続先となるソフトウェアの更新ポイント (WSUS) サーバーにおいて、”Upgrades” を同期対象にしていると、更新プログラムのスキャンに失敗するという既知の問題があります。   本事象が発生すると、スキャンが失敗しクライアントに最新のソフトウェア更新プログラムが展開されませんので該当するクライアントがある場合は注意が必要です。   発生する条件は、以下のとおりです。 ・クライアントが Windows 10 バージョン 1511 であること ・ソフトウェア更新ポイント (WSUS サーバー) が製品: Windows 10 , 分類: Upgrades を同期していること   上記の条件に該当する場合は、本事象が発生している可能性がありますので、下記の概要および回避策の内容をご確認ください。   概要 Windows 10 バージョン 1511 のクライアントが、ソフトウェア更新プログラムのスキャンに失敗します。 本問題が発生した場合、クライアントの WUAHandler.log (C:WindowsCCMLogs に存在します)には、以下のログが記録されます。  …


Disable Bluetooth in Windows 10 [Updated]

I’m providing a revision to Jeff Stokes’ original post for disabling Bluetooth in Windows 10.  I found that the removal portion of the original script no longer works on the Creators Update (1703).  The script should work on domain joined, AAD joined, ConfigMgr or Intune managed systems. # Must be ran as the System account…


Email Notifications for ConfigMgr Application Requests via PowerShell

A common conversation I have with customers is around the lack of a notification channel for application requests in ConfigMgr. I realize there are already a handful of solutions on the web that provide various ways of doing this. So, I figured why not share mine. It’s rather basic, just a PowerShell script that queries…


SQL Tip: Creating a Grand Total (and additional subtotals)

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…


SQL Tip: Creating a PIVOT table (Part 2)

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…


SQL Tip: Creating a Pivot table via T-SQL

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…


SQL Tip: The DENSE and DENSE_RANK Functions

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…


Modern Management of Internet Clients

The release of ConfigMgr Tech Preview – 1705 introduced new cloud based client management capabilities like on-boarding Azure AD users and deploying ConfigMgr client over Internet. Common scenarios like BYOD or Un-Managed/Workgroup devices in the field can now join Azure-AD which gets enrolled into Intune & automatically pushes the ConfigMgr agent for full management. The…


Moving the ConfigMgr site database to an Always On Availability Group

Back in 2012 I really wanted to be able to have the ConfigMgr database in an Always On Availability Group (I’ll refer to this as an “Availability Group” or an “AG” from now on). So, a coworker and I made that happen – sure, it wasn’t supported and auto-failover didn’t work but nevertheless we had…