SQL Tip: Return only latest record by date

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: Create comma seperated string from values in a column (& COALESCE)

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 edited…


Hardware Inventory – View to Class/Property Info

Over the past several years I’ve gotten a lot of questions from people about what WMI class is the source of data for a particular hardware inventory view (“v_GS_…”). This past week I created a couple queries to provide a team who has generally been the source of 95% of these questions and I figured…


Como identificar objetos excluídos da Console do Configuration Manager

Com base em informações do blog How to determine who deleted what objects in the ConfigMgr 2012 console – https://blogs.technet.microsoft.com/configurationmgr/2014/08/26/how-to-determine-who-deleted-what-objects-in-the-configmgr-2012-console/ vou detalhar um pouco mais esse cenário de quando um objeto de computador é excluído da console do Configuration Manager. Cenário 1: Botão direito no objeto de computador e Delete Atenção sobre a informação da remoção das…


Eski Office Sürümlerinin Tamamen Temizlenmesi

Bilgisayarda yüklü olan office uygulamalarının kaldırılması çoğunlukla yeni office uygulamalarının yüklenmesi sırasında gerçekleştirilir. Ancak bu işlemle bile bazı referans bağlantılar kalabilir veya bazı registry alanları temizlenmeyebilir. Var olan herhangi bir Office kurulumunun programsal olarak temizlenmesi için Office yaygınlaştırma ekiplerinin geliştirdiği Offscrub isimli bir paket bulunmaktadır. Bu paket içerisinde farklı Office versiyonları için kullanılabilecek VBScript dosyaları…


Windows 10 Compatibility Scan with Configuration Manager

Before deploying Windows 10, it’s a good idea to check the readiness of your existing machines running Windows 7, 8/8.1, Or even Windows 10. In this blog post I will use setup.exe with /compat scanonly switch to check the compatibility without performing the upgrade. The reason for not choosing the Upgrade task sequence for this…


SCCM Client for LINUX on FIPS Enabled Systems

Many organizations in the Public Sector as well as businesses that interact with Public Sector entities are required to adhere to the U.S. Government Federal Information Processing Standard (FIPS) Publication 140 for cryptographic systems and modules.  See https://www.microsoft.com/en-us/TrustCenter/Compliance/FIPS The compliance applies to hardware, firmware and software that use cryptographic-based security systems.  Operating systems protect and…


Feature Updates for Windows 10 via CMG

In my last blog post, I highlighted the option to install the ConfigMgr client over Internet for Windows 10 AAD joined machine, the next challenge is to perform Windows 10 Servicing to ensure the managed device is running a supported OS. A similar challenge is for Domain-Joined Windows 10 clients who are rarely on the…


Optimizing Operating Systems Upgrades for Remotely Connected Clients

Hi everyone. My name is Kacey Krehbiel. I’m a service engineer responsible for application and operating system upgrade deployments within Microsoft. Today I’d like to focus on one small aspect of our operating system upgrade process. Over the past couple of operating system upgrade cycles we have seen a huge increase in the numbers of…

12

Automating the Collection of Configuration Manager Client Logs

Hello everyone! Seth Price here to talk with you today about automating the collection of Configuration Manager client logs. Configuration Manager client logs are useful in troubleshooting many types of client issues including client installation, client health, software update installation, hardware inventory, and client policy. In many cases the administrator assisting with troubleshooting client issues…