csvClearOwner.py

#!/usr/bin/env python3

####################################################################################################
#
# Copyright (c) 2021, JAMF Software, LLC.  All rights reserved.
#
#       Redistribution and use in source and binary forms, with or without
#       modification, are permitted provided that the following conditions are met:
#               * Redistributions of source code must retain the above copyright
#                 notice, this list of conditions and the following disclaimer.
#               * Redistributions in binary form must reproduce the above copyright
#                 notice, this list of conditions and the following disclaimer in the
#                 documentation and/or other materials provided with the distribution.
#               * Neither the name of the JAMF Software, LLC nor the
#                 names of its contributors may be used to endorse or promote products
#                 derived from this software without specific prior written permission.
#
#       THIS SOFTWARE IS PROVIDED BY JAMF SOFTWARE, LLC "AS IS" AND ANY
#       EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
#       WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
#       DISCLAIMED. IN NO EVENT SHALL JAMF SOFTWARE, LLC BE LIABLE FOR ANY
#       DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
#       (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
#       LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
#       ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
#       (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
#       SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
####################################################################################################

import csv
import json
import requests

# This script takes a CSV of serial numbers and optional identifiers and removes their owner. 
# To use set the networkId, apiKey, and baseURL variables to match your Jamf School instance.

## CSV FORMAT:
# header row - ignored
# serial number , identifier (optional)

#Example:
# SERIAL_NO, DEVICE_TYPE
# CO3JM3422KL3,MAC
# DMQ88JX83LD0,iPad

### User defined varibles

networkId=''

apiKey=''

baseURL='https://url.jamfcloud.com/api'

# Optionally add a CSV path, otherwise you will be prompted for a path when the script runs
csvPath=''

### End user defined variables

if not csvPath:
    print('Enter CSV path or drag and drop: ', end="")
    csvPath = input()



r1=requests.get(baseURL +"/devices", auth=(networkId,apiKey))
devicesJson = json.loads(r1.text)['devices']

udidBySerial = dict()
for entry in devicesJson:
    udidBySerial[entry['serialNumber']] = entry['UDID']
    
serialNumbers = []
with open(csvPath,newline='') as csvfile:
    snReader = csv.reader(csvfile, delimiter=',', quotechar='|')
    next(snReader)
    for row in snReader:
        serialNumbers.append(row[0])


json = dict(user=0)
for sn in serialNumbers:
    r2=requests.put(baseURL + "/devices/{udid}/owner".format(udid=udidBySerial.get(sn)),auth=(networkId,apiKey),json=json)
    print(r2.text)