A use case for CMPivot: look for installed software FAST!

A use case for CMPivot: look for installed software FAST!

This is an extensive explanation on how CMPivot can help you pull information from clients in Configuration Manager. Specifically, we'll lookup an MSI Product Code for use with the Detection Method for an Application Deployment Type. But it covers some technical background and hints I hope you'll find useful. TL;DR If you already know about CMPivot and remote PowerShell and WMI, skip ahead to the CMPivot queries. If not, read on! What is CMPivot? If you're on Configuration Manager CB 1806 or later, you have access to the CMPivot feature. If you've never used it, just select a Device Collection in the CM Console and click Start CMPivot in the Actions Ribbon. You can't go wrong playing around with it as it only queries devices for stuff in a read-only fashion. But maybe start with a limited collection to avoid high resource impact. When you open the CMPivot tool, the Welcome message has a good description of what it can be used for: Note that...
Read More