SCCM 2019 How to create a device collection for specific application

KB2030 1 Reputation point
2021-06-13T18:26:13.32+00:00

Hi all,

How to create a device collection to know how many workstations have an application called CBT.exe regardless of the version?

Thanks

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
481 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HanyunZhu-MSFT 1,846 Reputation points Microsoft Vendor
    2021-06-14T07:43:05.51+00:00

    Hi @KB2030 ,

    Thanks for posting in Microsoft Q&A forum.

    We could use CMPivot to query the device and create the device collection, please refer to the following steps:

    1. Open the CMPivot.exe through the path: C:\Program Files (x86)\Microsoft Endpoint Manager\AdminConsole\bin\CMPivot.exe
    2. Enter the query language in Query box:
      File('%Windir%\CBT\CBT.exe')
    3. Click the Create Collection and finish the Create Device Collection Wizard.
      Then we can view the device collection in the CM console

    Below is the screenshot for reference:
    105267-query.png
    (Note: I tested it with minor change to suit my lab environment)

    Hope the above information is helpful to you.


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.