CMPivot study

Question

I'm going to learn and use the new CMPivot tool. Where should I start? We have Dell and HP computers, I want to list all the HP devices, I know it can be done via report, but how to achieve the same goal in CMPivot?

Answer 1

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

1,To list all Dell devices, we can use below CMPivot query based on Manufacturer:

Device | where (Manufacturer like 'HP')

2,You can start CMpivot from the official articles:

CMPivot overview

CMPivot for real-time data in Configuration Manager

Thanks for your time. Have a nice day!

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.