Windows 10 - SCCM SQL Query for AirWatch Batch Import

In order to silently onboard Windows 10 devices into AirWatch and have them automatically assigned to the primary user, you will have to first preregister devices via a batch import. You can use the attached SQL queries to generate the CSV file needed to perform a batch import in AirWatch. 

This Sample has been Productized as VMware Workspace ONE AirLift

VMWare recommends customers implement Workspace ONE AirLift to achieve the functionality in this sample

The main purpose and goal of VMware {code} is to share code samples and collaborate with our development community. We actively watch and listen to customer feedback and sometimes take some of the open-source projects and convert them into fully supported versions. We have recently released Workspace ONE AirLift, a server-side connector that simplifies and speeds the customers journey to modern management. Workspace ONE AirLift bridges administrative frameworks between Microsoft System Center Configuration Manager (SCCM) and Workspace ONE UEM.

SCCM SQL Query for AirWatch Batch Import

Overview

  • Author: Brooks Peppin & Josue Negron
  • Email: jnegron@vmware.com
  • Date Created: 12/1/2017
  • Updated: 9/13/2018
  • Tested on: SCCM 1706/1710 with SQL Server 2012

SYNOPSIS

In order to silently onboard Windows 10 devices into AirWatch and have them automatically assigned to the primary user, you will have to first preregister devices via a batch import. You can use the attached SQL queries to generate the CSV file needed to perform a batch import in AirWatch.

Detailed instructions can be found at http://www.brookspeppin.com

Batch Import from SCCM to Workspace ONE

Modifications Required

Update the following attributes before executing the script:

  • YourGroupID - Group ID of your OG
  • YourDeviceGroupID - Enrollment OG for the Device
  • YourCollectionID - Device Collection ID for the collection you want to export
  • You might also want to remove anything after the WHERE statement to pull a larger group of devices, or to pull in device serial numbers which are virtual machines (VMs).
  • For fresh installs of System Center ConfigMgr, the givenName and sn AD attributes are not automatically synced, thus the SQL script will fail to pull these values in until you sync these attributes over. Production environments should already have these attributes syncing.

There are two version Simple and Advanced, all that is required is simple however some will want to add additional attributes ahead of time so they are imported with the device records.

Resources

##Change Log -2/5/2018 - Updated Email Address AD Attribute from "vru.User_Principal_Name0" to "vru.Mail0" -9/13/2018 - Added AirLift reference to README


Sign in to be able to add comments.

Comments 0


;