Run CMPivot Queries from Intune Admin Center (Tenant Attach)

In this post, you’ll learn how to run CMPivot queries from Intune admin center. Microsoft Intune makes it easy to run CMPivot queries on tenant-attached devices and assess the state of devices in your environment.

To run the CMPivot query on a device in Intune, you must first enable the tenant to attach. Tenant attach connects your Intune tenant to your on-premises SCCM environment. Once you have configured the tenant attachment, you view and manage devices directly from the Intune Admin Center. Take a look at the guide on enabling SCCM tenants attach.

With Configuration Manager, CMPivot query can query the data in real-time on all currently connected devices in the selected collection. Microsoft has extended the CMPivot feature to Intune, where you can run the CMPivot queries on the tenant-attached devices. For example, your Helpdesk team can launch real-time cloud queries against a single ConfigMgr-managed device and return the results to the Intune admin center.

In this post, we’ll review the prerequisites and permissions needed to run CMPivot queries from the Intune portal. If the prerequisites and account permissions are not in place, you will receive error 401 or 403 when running CMPivot queries from the Intune portal.


http://forum.analysisclub.ru/index.php/topic,34432.0.html

http://forum.analysisclub.ru/index.php/topic,63007.0.html

https://www.dragon1616.com/index.php?topic=468.0

https://www.dragon1616.com/index.php?topic=104.0

https://www.dragon1616.com/index.php?topic=2123.0

https://forum-anunturi.apiardeal.ro/index.php?topic=6094.0

https://forum-anunturi.apiardeal.ro/index.php?topic=6129.0

https://forum-anunturi.apiardeal.ro/index.php?topic=147.0

https://www.iwantbots.com/viewtopic.php?t=36900

https://www.iwantbots.com/viewtopic.php?t=36105

https://iwantbots.com/viewtopic.php?t=133

https://goazzure.com/forum/viewtopic.php?t=4952

https://goazzure.com/forum/viewtopic.php?t=5093

http://www.skillcoach.org/forums/topic/385786/oppenheimer-2023-online-pl

http://www.skillcoach.org/forums/topic/384976/how-to-get-free-vcoin-on-imvu-2023

https://forum-old.soria2.pl/index.php?/topic/5848-ijwmyib-cmzice/

https://expectingtheunexpected.com/showthread.php?tid=1444

https://www.truecrimecollectors.com/showthread.php?tid=3935

https://www.mcmon.ru/showthread.php?tid=13675


Prerequisites


To run the CMPivot query from the Intune Portal on tenant-attached devices, you will need the following prerequisites:


  • All the prerequisites for the Tenant attach: ConfigMgr client details
  • Configuration Manager 2006 or higher version.
  • Configuration Manager clients must be upgraded to the latest version.
  • Target clients require a minimum of PowerShell version 5.
  • Microsoft Edge, version 77, and later. Google Chrome (latest version).
  • The Intune tenant-attached devices must be online in order to run the CMPivot queries.


Permissions


The user account needs the following permissions to successfully run the CMPivot query from Intune Portal:


  • The Read permission for the device’s Collection in Configuration Manager.
  • The Run CMPivot permission on the Collection in Configuration Manager.
  • An Intune role is assigned to the user.
  • The user account needs to be a synced user object in Azure AD (hybrid identity). This means that the user is synced to Azure Active Directory from Active Directory.

http://forums.worldsamba.org/showthread.php?tid=329343

https://www.revolutionmall.co.uk/forum/showthread.php?tid=52931

https://test.tcz.x10.mx/mybb/showthread.php?tid=63939

http://mystrotain.free.fr/forum/showthread.php?tid=68844

http://www.linuxmint-hispano.com/foro/index.php?topic=77577.0

http://www.linuxmint-hispano.com/foro/index.php?topic=81697.0

http://forumgobelin.free.fr/viewtopic.php?p=829

http://forumgobelin.free.fr/viewtopic.php?p=637

http://forum2.extremum.org/viewtopic.php?f=5&t=114420

http://forum2.extremum.org/viewtopic.php?f=5&t=75724

http://forum2.extremum.org/viewtopic.php?f=5&t=90282

http://www.gumigosoae.com/bbs/board.php?bo_table=notice&wr_id=9

https://www.uniforos.com/viewtopic.php?t=2684


Launch CMPivot from Intune Admin Center


To start the CMPivot from the Intune admin center, follow the steps below.


  • Sign in to Microsoft Intune Admin Center.
  • Go to Devices, then select All Devices.
  • Select a device that is synced from Configuration Manager via tenant attach.
  • In the left pane, choose CMPivot to launch it.


The CMPivot launches now display all the built-in queries. On the right, there is a section dedicated to running the CMPivot query.


Run CMPivot Queries from Intune Portal


In the above step, we saw how to launch the CMPivot from Intune portal. Now we will look at the steps to run CMPivot queries from Intune portal.

From the CMPivot query window, you can run either a built-in query or a custom query. If you’re using a custom query, make sure the query is working. You can use any of the CMPivot queries published on this blog.

We will run a sample query that will list all the local administrators present on the device. To run the CMPivot query from the Intune admin center, copy the below query and paste it to the query input box and select Run.

The CMPivot query will now list all the local administrators on the co-managed device.

In the next example, we’ll run the following CMPivot query to list the recently used applications on the tenant-attached device.

If your CMPivot query output is empty, you must start troubleshooting the issue by reviewing the logs. CMPivot queries initiated from the Intune portal are logged in CMGatewayNotificationWorker.log & AdminService.log. You can find these logs on the Configuration Manager site server.


Export CMPivot Query Results in Intune


CMPivot query results can be exported to an a.csv file in Intune with a single click. When you run CMPivot queries in Intune, you may receive lengthy output that is difficult to analyze. The best thing you can do is export the query output to a .csv file and analyze the data later using the Excel application.


Here’s how you can export the CMPivot query results to a .csv file in Intune:


  • After the CMPivot query has been executed, click on the Export option.
  • On the Export CMPivot query results box, select the Download button.
  • The CMPivot query results are now exported to a .csv file and this file is downloaded to your computer.

https://www.uniforos.com/viewtopic.php?t=2516

https://www.uniforos.com/viewtopic.php?t=2739

http://marcelli.free.fr/forum/viewtopic.php?p=4267

http://marcelli.free.fr/forum/viewtopic.php?p=1547

http://marcelli.free.fr/forum/viewtopic.php?p=496

http://www.duomaomao.com/forum.php?mod=viewthread&tid=193460

http://www.duomaomao.com/forum.php?mod=viewthread&tid=191412

http://www.duomaomao.com/forum.php?mod=viewthread&tid=188161

https://www.wolala.love/thread-44007-1-1.html

https://63game.top/thread-19195-1-1.html

https://www.63game.top/thread-12174-1-1.html

https://63game.top/thread-42040-1-1.html


Save CMPivot queries to favorites


In Microsoft Intune, to keep all of your frequently used queries in one place, you can save your CMPivot queries to your favorites folder. You can also add tags to your queries to aid in search and discovery.

The functionality is similar to that which is already available in the Configuration Manager console. The queries saved in the Configuration Manager console will not be added to your Favorites folder automatically. You must create new queries and manually save them in this folder.

To save your query, select the Save option after typing in your query. You can customize the name and tags for your query and click Save.

You can view all your saved favorite queries, under the “Favorites” folder on the left panel, along with all other CMPivot entities.


Comments

Post a Comment

Popular posts from this blog

Display Lock Screen Message for MacOS Users using Intune

In this post, you’ll learn how to display a lock screen message for macOS users using Intune. Using Intune Policy, you can configure a message to appear on the Mac login window for users. The message could be, for example, a welcome, a warning, or your organization’s lost and found contact information. After you enroll macOS devices in Intune, you can use Configuration Profiles to configure the settings for mac. The login window configuration settings allow admins to configure the appearance of the macOS login screen and the functions that are available to users before and after they log in. For Windows devices, you can configure the interactive logon message for users with Intune. An interactive logon message is useful to personalize the logon process, provide news or information, and for other similar purposes. You can also show lock screen message for iOS/iPadOS devices using Intune. The macOS lock screen message in Intune can be a welcome message, your organization’s lost and found
Read more

Fix Intune Win32 App Deployment Error 0x87D1041C

In this post, we will go over the steps to resolve Intune Win32 app deployment error 0x87D1041C. The error 0x87D1041C is seen when the Win32 app installs correctly on the device but is not detected by the company portal app. One of the customers reported an issue with the deployment of Win32 apps in Intune. Users installed a newly packaged Win32 app, but they noticed something strange. The application was successfully installed, but the company portal indicated that it was not installed, resulting in error code 0x87D1041C. The Win32 application in the previous query was a business app used exclusively within the company. After I fixed the error 0x87D1041C, I recreated it in my lab using an instance of the Adobe Reader Win32 program. In your case, it could be another application, however the resolution covered in this post will work. See how to package and deploy Win32 apps in Intune. Also Read: Fix: MDM Logs Collection Error 0x800700a1 | Windows Autopilot https://www.tdedchangair.com/w
Read more

The most effective method to Install Games on Your Computer

Tired of utilizing your PC for all work and no play? The games that come preloaded on PCs are nice brief period squanderers, however you'll most likely need to in a little while. Continue perusing to figure out how to introduce games on a PC. We'll cover three significant approaches to introduce games: introducing through physical media (like an establishment DVD that you purchased from a store), introducing direct from the distributer, or downloading through a computerized store (like Steam or GOG). Step by step instructions to Install a Game from Physical Media  On the off chance that you get a PC game where you get a genuine physical introduce circle, establishment is really basic. Here's the manner by which you go about it. Supplement the establishment plate into the best possible drive on your PC. Visit here for more details:  webroot safe By and large, plates will consequently run. On the off chance that your PC prompts you to affirm it's protected
Read more