none
Autopilot csv from sccm report RRS feed

  • Question

  • Hi all,

    If I try to import the autopilot csv file extracted from the specific sccm report I have an error.

    Is there a simple way to format correctly the exported file from the report?

    Thanks

    Monday, September 16, 2019 7:56 AM

Answers

  • It looks like the report from SCCM exports with a header from the report viewer as well as a row that sort of describes each of the columns. Columns A, B, and C are going to be the same on all rows. That is actually what you need to have as your headers for Columns D, E, and F.

    I opened it in Excel to make it easier. 

    Once in Excel, I deleted rows 1-3 and cleared the values from the new row 1 (formerly row 4).

    Copy the values of A2, B2, and C2. Paste them to D1, E1, and F1 respectively. Then delete columns A, B, and C.

    Save that and you should be able to upload it to Intune without issue.

    • Proposed as answer by Socratio Tuesday, November 19, 2019 8:45 PM
    • Marked as answer by zolabus Wednesday, November 20, 2019 8:18 AM
    Tuesday, November 19, 2019 8:45 PM

All replies

  • The CSV file should list the serial numbers, Windows product IDs, hardware hashes, optional group tags, and optional assigned user. You can have up to 500 rows in the list. Use the header and line format shown below:

    Device Serial Number,Windows Product ID,Hardware Hash,Group Tag,Assigned User
    <serialNumber>,<ProductID>,<hardwareHash>,<optionalGroupTag>,<optionalAssignedUser>

    Also, when you use CSV upload to assign a user, make sure that you assign valid UPNs. If you assign an invalid UPN (incorrect username), your device may be inaccessible until you remove the invalid assignment. During CSV upload the only validation we perform on the Assigned User column is to check that the domain name is valid. We're unable to perform individual UPN validation to ensure that you're assigning an existing or correct user.

    Reference: https://docs.microsoft.com/en-us/intune/enrollment-autopilot    

    Best regards,
    Cici Wu

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.



    Monday, September 16, 2019 9:27 AM
  • everything clear but is there any method to format correctly the csv exported by the sccm report?
    Monday, September 16, 2019 12:01 PM
  • You can run the script to put the necessary information into a CSV can be found here on the PowerShell Gallery repository. Upload this CSV using the Azure Portal or Store for Business.

    #Gather a computer's AutoPilot info:
    Set-Location -Path C:\Sources
    Save-Script -Name Get-WindowsAutoPilotInfo -Path .\
    Install-Script -Name Get-WindowsAutoPilotInfo
    .\Get-WindowsAutoPilotInfo.ps1 -ComputerName 'LOCALHOST' -OutputFile .\MyComputer.csv -Append
    Import-Csv -Path .\MyComputer.csv

    If you already have the machine running on your network, you can simply run the script at any time to collect the data. Starting with SCCM build 1706, you now have the ability to create and run PowerShell scripts from the Configuration Manager console.

    And if you have SCCM build 1802, there is a report which contains the same information in bulk, gathered from the devices in your site. The data could then be pre-staged into AutoPilot, ready for use the next time a given machine is reimaged or factory reset.

    More information: https://www.swc.com/blog/cloud/windows-autopilot-scenarios-modernizing-windows-deployment-part-1

    Best regards,

    Cici Wu


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, September 17, 2019 7:21 AM
  • Hi my question is if from the csv export created from the sccm report (that is not good for the intune upload) is there any way to create the correct one.

    Thanks

    Friday, September 20, 2019 12:55 PM
  • It looks like the report from SCCM exports with a header from the report viewer as well as a row that sort of describes each of the columns. Columns A, B, and C are going to be the same on all rows. That is actually what you need to have as your headers for Columns D, E, and F.

    I opened it in Excel to make it easier. 

    Once in Excel, I deleted rows 1-3 and cleared the values from the new row 1 (formerly row 4).

    Copy the values of A2, B2, and C2. Paste them to D1, E1, and F1 respectively. Then delete columns A, B, and C.

    Save that and you should be able to upload it to Intune without issue.

    • Proposed as answer by Socratio Tuesday, November 19, 2019 8:45 PM
    • Marked as answer by zolabus Wednesday, November 20, 2019 8:18 AM
    Tuesday, November 19, 2019 8:45 PM
  • You wrote:  "And if you have SCCM build 1802, there is a report which contains the same information in bulk, gathered from the devices in your site. The data could then be pre-staged into AutoPilot, ready for use the next time a given machine is reimaged or factory reset."

    If you run this SCCM report and then import that into your Intune Portal won't all of those machines be available and active in Autopilot immediately?  Why would you have to re-image or factory reset them?   


    mqh7

    Tuesday, March 17, 2020 8:00 PM
  • They will only go through the Autopilot OOBE when the device is reset, or reimaged (assuming they have an Autopilot deployment profile assigned to them)
    Tuesday, March 17, 2020 9:46 PM
  • I'm new to Autopilot so bare with me.   I thought that once the HASH has been uploaded to Intune you can then push policies to that machine?  Or you can push software to that machine.   Is that correct? 

    Thank you.  


    mqh7

    Tuesday, March 17, 2020 9:53 PM
  • No, that is just registering the device in Autopilot so that you can assign an Autopilot profile, so that next time the device is reimaged or reset, it will go through the Autopilot OOBE. As part of using Autopilot, the device can then enroll into Intune so it can get policies and apps.

    To push out software and policies to a device, a device  needs to be enrolled into Intune. Autopilot is one way to get Windows 10 enrolled into Intune, other ways are GPO's, co-management, adding work or school account etc.  See  https://docs.microsoft.com/en-us/mem/intune/enrollment/windows-enrollment-methods


    Tuesday, March 17, 2020 10:05 PM