csvClearOwnerAndMove.py

#!/usr/bin/env python3

import csv
import json
import requests

## CSV FORMAT:
# header row - ignored (but should exist)
# serial number 

#Example:
# SERIAL_NO
# CO3JM3422KL3
# DMQ88JX83LD0


####### User Defined Variables #######

# set network ID from https://url.jamfcloud.com/devices/enroll.html -> On device enrollment -> Network ID
networkId='networkidhere'

# set api key from https://url.jamfcloud.com/configuration/api
apiKey='apikeyhere'

# set base url for instance'
baseURL='https://yoururl.jamfcloud.com/api'

# id of location to move devices to. 0 is the district location.
locationId=0

####### End User Defined Variables #######

# csv path can be hardcoded
csvPath=''

# get user input for csv path
if not csvPath:
    print('Enter CSV path or drag and drop: ', end=None)
    csvPath = input().replace("'", "")

# read in serial numbers from csv
serialNumbers = []
with open(csvPath,newline='') as csvfile:
    snReader = csv.reader(csvfile, delimiter=',', quotechar='|')
    next(snReader)
    for row in snReader:
        serialNumbers.append(row[0].upper())

# make request to get all devices and check for success
devicesRequest=requests.get(baseURL +"/devices", auth=(networkId,apiKey))
if (devicesRequest.status_code != 200):
    print("There was an issue with the request, status code: " + str(devicesRequest.status_code) + " terminating" )
    exit()

# parse device response into dict serial by udid
devicesJson = json.loads(devicesRequest.text)['devices']
udidBySerial = dict()
for entry in devicesJson:
    udidBySerial[entry['serialNumber'].upper()] = entry['UDID']

# iterate through serial numbers and look up each udid then send a request to remove user then move locations
deviceOwnerJson = dict(user=0)
migrateJson = dict(locationId=locationId)
skipped=[]
failed=[]
migrated=[]
for sn in serialNumbers:
    # check that the serial number was found and if not add to skipped
    udid = udidBySerial.get(sn)
    if (udid == None):
        print("serial number: " + sn + " could not be found. Skipping")
        skipped.append(sn)
        continue

    # check status codes to make sure devices cleared owner and moved, if not then add to failed
    removeOwnerRequest=requests.put(baseURL + "/devices/{udid}/owner".format(udid=udid),auth=(networkId,apiKey),json=deviceOwnerJson)
    if (removeOwnerRequest.status_code != 200):
        print("{sn} failed to remove owner")
        failed.append(udid)
        continue
    migrateDeviceRequest=requests.put(baseURL + "/devices/{udid}/migrate".format(udid=udid),auth=(networkId,apiKey),json=migrateJson)
    if (devicesRequest.status_code != 200):
        print("{sn} failed to migrate")
        failed.append(udid)
        continue
    print("Finished clearing owner and moving {sn}".format(sn=sn))
    migrated.append(sn)

# print out any skipped or failed devices
if skipped:
    print("The following device serial number's udid's could not be found and were skipped")
    print(skipped)
if failed:
    print("The following devices failed to clear owner or move")
    for device in failed:
        print("{baseURL}/devices/details/{udid}/device-list.html".format(baseURL=baseURL,udid=device))