How to export Autopilot devices from Intune or Entra ID which shows its part of Autopilot with separate column in report as I am not able to see it in Intune and Entra ID as well?

@Vinod Survase,Thanks for posting in Q&A.

From your description, I know that you want to export Autopilot devices from Intune.

Based on my research, if you enroll a device into Intune using Autopilot, the device join type will finally show Microsoft Entra joined instead of Autopilot in Intune portal, therefore, you cannot distinguish which device is Autopilot.

However, you can find Autopilot devices in Intune portal > Devices > Windows > Windows enrollment > Windows Autopilot Deployment Program > Devices and you can check there which devices has been enrolled in Intune.

You can export Autopilot devices information with Serial number, Manufacturer, Model, Group Tag, Profile status, Purchase order.

Hope this can be helpful.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

There is one way to do this. You need to create an Azure AD Dynamic Group based on the below query:

• To create a group that includes all of your Autopilot devices, enter: (device.devicePhysicalIDs -any (_ -contains "[ZTDID]")).

Once the group is created, In around a couple of hours, you will have all autopilot devices in this group. You can easily export this list of Autopilot devices from entra admin center.

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