Let’s understand the process of deploying & installing the CMPivot standalone app on Windows 10 and Windows 11 PCs. Configuration Manager CMPivot tool allows us to assess the state of online devices quickly. In this example, the CMPivot standalone version is installed on a Windows 10 device where the SCCM console is installed.
When we run a query against a device collection, the CMPivot shall run a query in real-time on all currently connected (online) devices in the selected collection. The following post includes CMPivot architecture and communication details as well. 👉SCCM CMPivot Architecture Fast Channel Making | ConfigMgr.
What is SCCM CMPivot Standalone App
The SCCM CMPivot standalone application is a tool that can be installed on a Windows 10 or Windows 11 PC. You can run the CMPivot within the SCCM console; however, there many advantages to using CMPivot as a standalone application.
The CMPivot standalone app can be run outside the SCCM console to get the real-time state of devices in your environment.
Sample CMPivot Queries
- CMPivot Query to Find Windows 10 Devices
- How to Collect Intune Error Details using CMPivot
- How to Collect Windows Update Logs using CMPivot
- ConfigMgr CMPivot Favorite Query
- CMPivot Query to Fetch WSUS Server Details
- ConfigMgr CMPivot Logs | Background Process Guide
- CMPivot Query to Find Clients not Part of Any Boundary Groups
- Run CMPivot Queries from Intune Portal
- Analyze SCCM Client Logs Using CMPivot
Source Files for CMPivot
Let’s copy the source files of CMPivot from the site server to the package source location.
- Copy Source File – \Cmmemcm\f$\Program Files\Microsoft Configuration Manager\tools
- Destination Folder – \CMMEMCM\Sources\Package Sources\CMPivot
Create CMPivot Standalone Application
Launch ConfigMgr console.
Navigate via Software Library – Application Management – Applications
Right-click on applications not and select Create Application option
Import CMPivot MSI to SCCM
Click on the Browse button to select the application source files.
This helps to Automatically detect information about this application from the install file of CMPivot (CMPivot.msi).
Browse to the package source folder as mentioned above.
Select the cmpivot.msi and click on the OPEN button.
Let’s check the location is populated with the package source path as shown below.
- Click NEXT & NEXT to continue to the next screen
- Following is the imported information.
Application name: CMPivot
Publisher:
Software version:
Deployment type name: CMPivot - Windows Installer (*.msi file)
Product Code: {60F9F9C2-04F4-470C-810E-BEF7C960F970}
Installation behavior: Install for system
Content location: \CMMEMCM\Sources\Package Sources\CMPivot\
Number of files: 1
Content files:
cmpivot.msi
General Information about CMPivot.MSI
Enter the Name of the Application – CMPivot
Enter the Publisher Name – Microsoft
Installation Command – msiexec /i “cmpivot.msi” /q
Installation Behaviour – Install for System
Click on NEXT to continue
Let’s confirm the application details from the below details and click NEXT to continue.
General Information:
• Application name: CMPivot
• Administrator comments:
• Publisher: Microsoft
• Software version:
• Optional reference:
Categories:
Deployment type name: CMPivot - Windows Installer (*.msi file)
Requirement rules:
Content:
• Content location: \CMMEMCM\Sources\Package Sources\CMPivot\
• Installation program: msiexec /i "cmpivot.msi" /q
Detection Method:
• Product code: {60F9F9C2-04F4-470C-810E-BEF7C960F970}
User Experience:
• Installation behavior: Install for system
Click on NEXT, NEXT, and Close to complete the Application Creation Wizard.
CMPivot Standalone App Deployment Types
Let’s check the CMPivot deployment type that we created in the above section.
- Priority – 1
- Name – CMPivot – Windows Installer (*.msi file)
- Dependencies – No
- Technology Title – Windows Installer (*.msi file)
Distribute & Deploy CMPivot
- Right-click on the CMPivot application and
- Select the option called Deploy
Click on Browse
Select the device collection to deploy CMPivot standalone application.
Add Distribution Points
- Now, let’s add the distribution point.
- Click the Add button from an additional distribution point.
- Select the option Distribution Point.
Select the Distribution Points where you want to distribute the package.
Click OK and Next to continue.
Deployment Settings
- Select Action as Install
- Select Purpose as Available
Specify the schedule for this deployment
Click on the Next button from the User experience wizard page by selecting the default settings.
Click on the Next button from the Alert wizard page by selecting the default settings.
Click on the Next button from the Summary Page.
General (Summary of the deployment) • Software: CMPivot • Collection: HTMD Collection (Member Count: 1) • Use default distribution point groups associated to this collection: Disabled • Automatically distribute content for dependencies: Enabled Deployment Settings • Action: Install • Purpose: Available • Allow end users to attempt to repair this application: Disabled • Allow clients to use a metered Internet connection to download content: Disabled Application Settings (retrieved from application in software library) • Application Name: CMPivot • Application Version: • Application Deployment Types: Windows Installer (*.msi file) Scheduling • Time based on: UTC • Available Time: As soon as possible • Deadline Time: Disabled • Delayed enforcement on deployment: Disabled User Experience • User notifications: Display in Software Center, and only show notifications for computer restarts • Ignore Maintenance Windows: Disabled • System restart (if required to complete the installation): Disabled • Commit changes at deadline or during a maintenance window (requires restarts): Enabled Alerts • Enable System Center Operations Manager maintenance mode: Disabled • Generate System Center Operations Manager alert when a software installation fails: Disabled • Create a deployment alert when the threshold is lower than the following: Disabled • Create a deployment alert when the threshold is higher than the following: Disabled Content (2): • CMMEMCM.MEMCM.COM • MEMCMSECONDARY.MEMCM.COM
Click on the Next and Close button to complete the wizard.
Results
I have deployed the CMPivot standalone version to the Windows 10 device that already has ConfigMgr Console installed.
Related post – Install SCCM Console on Remote Windows 10 Devices | ConfigMgr
- Once the deployment is created, you can see the below.
Let’s check the content status.
Check the Software Center from Windows 10 client
Shortcut of CMPivot got created on Windows 10 device.
Successfully Launched CMPivot
Resources
- SCCM CMPivot Query Patches Installed in Last 90 Days | ConfigMgr
- SCCM CMPivot Architecture Fast Channel Making | ConfigMgr