Publish CMPivot Query to the SCCM Community Hub Contributions

Let’s learn how to publish CMPivot Query to the SCCM Community hub contributions. The community hub is the place where SCCM admins can download and start using community and Microsoft curated scripts, CMPivot queries, Custom Reports, etc., directly from the Admin console.

The ConfigMgr community can upload and publish their CMPivot queries to the SCCM Community hub. I have explained the following method to upload the CMPivot query to collect Windows Update logs remotely.

You can also contribute to ConfigMgr Community Hub using the same method explained in this post. You will need to have a Github account. The SCCM 2010 or later with the WebView2 console extension should be installed to get GitHub sign-in.

Mark Silvey, Development lead at Microsoft working on Configuration Manager, helped me to get the contributions published to the community hub. SCCM Community deep links (direct links) are currently only for items in the Community hub node of the console version 2006 or later.

Patch My PC

The SCCM Community deep links for the Community hub are only used from the SCCM console. To open the hub in the console, go to the Community workspace, and select the Community hub node. Launch the Community hub (This requires Microsoft Endpoint Configuration Manager admin console version 2006 or later).

Prepare for SCCM Community Hub Contributions

Let’s prepare for SCCM community hub contributions. In this post, I will take an example of contributing CMPivot query to the community hub. You will need to join the SCCM community hub with a GitHub account.

You can launch the CMPivot from the Start CMPivot option from any device collection to contribute to Community Hub. Or you can use the standalone version of the CMPivot application.

Prepare for SCCM Community Hub Contributions
Prepare for SCCM Community Hub Contributions

Once the CMPivot application is launched, you can click on the Community Hub icon near the * button, as shown below. You will get a sign-in option within the CMPivot application.

Adaptiva
  • Click on Community Hub Icon from CMPivot.
  • Click on GitHub Sign in option to join community hub contributions.
Publish CMPivot Query to the SCCM Community Hub Contributions
Publish CMPivot Query to the SCCM Community Hub Contributions

NOTE! – You will need to enable the two-factor authentication or MFA for your GitHub account before joining the Community Hub contributions.

Sign in to GitHub to continue to ConfigMgr-Hub with GitHub user name and password. It might ask setup MFA if you have not already enabled this.

Publish CMPivot Query to the SCCM Community Hub Contributions
Publish CMPivot Query to the SCCM Community Hub Contributions

You will need to Authorize ConfigMgr-hub public repository with your GitHub account. You will also need to click on the Authorize Cloud button.

Publish CMPivot Query to the SCCM Community Hub Contributions
Publish CMPivot Query to the SCCM Community Hub Contributions

After the authorization mentioned above, click on Publish, as shown in the below screenshot. To contribute to the SCCM community hub, you will need to click on the Join button below.

Publish CMPivot Query to the SCCM Community Hub Contributions 1
Publish CMPivot Query to the SCCM Community Hub Contributions

Here is where you are joining the community hub using the GitHub account to the GitHub repository hosting all the community contributions. Press the Join button below to request to write access. Once approved, you will be to share content from your site with others worldwide.

Publish CMPivot Query to the SCCM Community Hub Contributions 2

Now you will need to wait for Microsoft to approve your membership request. Microsoft will eventually approve your GitHub account. You should have an email from GitHub now that you need to accept to start sharing.

Publish CMPivot Query to the SCCM Community Hub Contributions
Publish CMPivot Query to the SCCM Community Hub Contributions

Publish CMPivot Query to SCCM Community Hub

Once the request is approved by Microsoft and accepted by you, you have new options under Publish. You can enter the name of the contribution in this scenario; it will be CMPivot query contributions. Also, enter a detailed description of your contribution.

  • Enter the Name for the CMPivot Query.
  • Enter the Description for the Description for the CMPivot Query.
  • Click on Publish button to continue.

How To Collect Windows Update Logs From SCCM Client Remotely ConfigMgr CMPivot Query For Event Logs Error HTMD Blog (anoopcnair.com)

Publish CMPivot Query to SCCM Community Hub
Publish CMPivot Query to SCCM Community Hub

Now, you will need to wait for a GitHub notification or email to Complete the Pull request to be visible in the admin console.

ExamplePull request with type [CREATE] for user [AnoopCNair] and object type [CMPivotQuery] – titled [Collect Windows Update Logs] by AnoopCNair · Pull Request #182 · microsoft/configmgr-hub · GitHub

Publish CMPivot Query to SCCM Community Hub
Publish CMPivot Query to SCCM Community Hub

Until the pull request is completed, you will be able to see your contributions only in the Your Hub section. You need to complete your pull request to become “curated.” After you do that, it will show up on all consoles.

Are you struggling to find your contributions in SCCM Community Hub? If so, you are not alone; you will need to complete the following steps.

Publish CMPivot Query to the SCCM Community Hub Contributions 3
Publish CMPivot Query to the SCCM Community Hub Contributions 17

Confirm squash and merge Action in GitHub

To complete the GitHub pull request, you will need to log in to GitHub and check the notification once you are in the GitHub and find the notification of Pull Request.

You will need to click on Squash and Merge button to complete the GitHub Pull Request.

 Confirm squash and merge Action in GitHub - Publish CMPivot Query to the SCCM Community Hub Contributions
Confirm squash and merge Action in GitHub – Publish CMPivot Query to the SCCM Community Hub Contributions

Click on Confirm squash and merge button.

  Confirm squash and merge Action in GitHub
Confirm squash and merge Action in GitHub

You will see the following notification once the GitHub pull request is completed for SCCM Community Hub contributions.

  • Pull request successfully merged and closed.
  • https://github.com/Microsoft/configmgr-hub/commit/c2afc2e2e5cd5b58aa539bec0c40a27ee99b26ce
Publish CMPivot Query to the SCCM Community Hub Contributions 4
Publish CMPivot Query to the SCCM Community Hub Contributions 18

Verification of CMPivot Query to the SCCM Community Hub Contributions

Let’s check and verify CMPivot Query to the SCCM Community Hub Contributions. Once you can click on the Community Hub icon from the CMPivot application and search for “Collect Windows update.”

Verification of CMPivot Query to the SCCM Community Hub Contributions
Verification of CMPivot Query to the SCCM Community Hub Contributions

You can see also check the Community Hub Workspace in the SCCM console. Your contributions will be shown under the Latest Updates section. There is an option to search for items in Community Hub as well.

Or you can use the following direct Community Hub Deeplink (direct link) for your contribution.

https://communityhub.microsoft.com/item/34461

Verification of CMPivot Query to the SCCM Community Hub Contributions
Verification of CMPivot Query to the SCCM Community Hub Contributions

You can download the CMPivot query Collect Windows Update Logs from the Community workspace in the SCCM console, and select the Community Hub node.

Verification of CMPivot Query to the SCCM Community Hub Contributions
Verification of CMPivot Query to the SCCM Community Hub Contributions

Resources

3 thoughts on “Publish CMPivot Query to the SCCM Community Hub Contributions”

  1. A They are already under the CMPivot Query tool, so I don’t see any more reason to download them. I wanted to clean up all of the downloads, to have cleaner look. Thanks for the advice. I think it’s not a critical thing. Thank you for the quick answer. Have a successful day!

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.