please

You should be able to modify this to fit your needs.

#!/bin/sh

# Name: leaseupdate.sh
# Date: 9 March 2015
# Author: Steve Wood (swood@integer.com) 
# Purpose: used to read in lease data from a CSV file and update the record in the JSS
# The CSV file needs to be saved as a UNIX file with LF, not CR
# Version: 1.0
#
# A good portion of this script is re-purposed from the script posted in the following JAMF Nation article:
#
#  https://jamfnation.jamfsoftware.com/discussion.html?id=13118#respond
#

jssAPIUsername="<apiuser>"
jssAPIPassword="<apipassword>"
jssAddress="https://your.jss.com:8443"
file="<path-to-csv-file>"

#Verify we can read the file
data=`cat $file`
if [[ "$data" == "" ]]; then
    echo "Unable to read the file path specified"
    echo "Ensure there are no spaces and that the path is correct"
    exit 1
fi

#Find how many computers to import
computerqty=`awk -F, 'END {printf "%s
", NR}' $file`
echo "Computerqty= " $computerqty
#Set a counter for the loop
counter="0"

duplicates=[]

id=$((id+1))

#Loop through the CSV and submit data to the API
while [ $counter -lt $computerqty ]
do
    counter=$[$counter+1]
    line=`echo "$data" | head -n $counter | tail -n 1`
    serialNumber=`echo "$line" | awk -F , '{print $1}'`
    leaseExpires=`echo "$line" | awk -F , '{print $2}'`

    echo "Attempting to update lease data for $serialNumber"

    # use serialNumber to locate the ID of the comptuer
    ### Add some logic to test for an empty set coming back from serial number check.
    myOutput=`curl -su ${jssAPIUsername}:${jssAPIPassword} -X GET ${jssAddress}/JSSResource/computers/serialnumber/$serialNumber`
    myResult=`echo $myOutput | xpath /computer/general/id[1] | awk -F'>|<' '/id/{print $3}'`
    myID=`echo $myResult | tail -1`

    echo $serialNumber " " $myID " " $leaseExpires
    apiData="<computer><purchasing><lease_expires>$leaseExpires</lease_expires></purchasing></computer>"
    output=`curl -sS -k -i -u ${jssAPIUsername}:${jssAPIPassword} -X PUT -H "Content-Type: text/xml" -d "<?xml version="1.0" encoding="ISO-8859-1"?>$apiData" ${jssAddress}/JSSResource/computers/id/$myID`

    echo $output
    #Error Checking
    error=""
    error=`echo $output | grep "Conflict"`
    if [[ $error != "" ]]; then
        duplicates+=($serialnumber)
    fi
    #Increment the ID variable for the next user
    id=$((id+1))
done

echo "The following computers could not be created:"
printf -- '%s
' "${duplicates[@]}"

exit 0

The MUT also does this and makes it simple with a nice UI.

Yeah we would love to use the MUT but are not able to because of how our jss is set up. We are a tunnel on another JSS account for a sister IT department... Its really confusing and frustrating as MUT would be the answer to our dilemma.

Is there anyway you can advise me on how to setup your code to rename the ios devices? How do I change lease to device name? I understand CSV loop however this is confusing. If our devices are already in DEP do I need to locate them by serial number?

Remember you could also use variables to set the name of a device. Anytime the device checks-in, the name will change back.

http://krypted.com/mac-security/using-payload-variables-in-profile-manager/

Yes! However I am getting a little bit of a crash course on some of this coding... (I am a junior in college and know enough to be dangerous lol) any help anyone can contribute would be of great appreciation... I am learning a lot through forums like these that is for sure.

@jay216 Ey! I'm a young'n also (21). Basically change the variable name in line where it it says leaseExpires=echo "$line" | awk -F , '{print $2}'
so change it to name or something like that. If you do your csv's in excel like i do then column 1 is your device serial number and column 2 is the name for it. The other thing you have to do is modify the xml portion. Where it says apiData="<computer><purchasing><lease_expires>$leaseExpires</lease_expires></purchasing></computer>" you need to change it to the xml format for the ios devices. I don't know it because we only do mac's here. Basically go to yourjss.com:8443/api and the should be an IOS get command somewhere. use it to get the XML structure you need for you "put" in the API. You don't need all the data. Just the data that's being changed. So the hierarchy is computer>purchasing>lease expires and then closing brackets for that respectively. Yours would be something like mobiledevices>name or something along those lines. Make sure when you change any variables in one place of the script you change them in any others. Find and replace all will be your friend for that but be careful to not changing something you don't want to.

ahhhh you have shown me the light... I am busting notepad out now and will keep you updated.

Okay I have everything except the API data. I am unsure of where to find it. I do not see anything that says IOS in the API let alone rename.

It would have to be under mobile devices I am sure

anything look like api data?

That's the right information. I think you would put your ${name} Variable inside of <device_name> so it would be <mobile_device><device_name>${namevariable}</device_name></mobile_device>

You also need to change the myoutput variable and the output variable tot he correct api call. so your myoutput ending should be something like GET /mobiledevices/serialnumber/$serialnumber

and your output ending would be something like /mobiledevices/id/${myid}

Anyone interested in taking a call on this and discussing how this worked for you. Let me know

When I set mine up I couldn't get the xml method to work, It would update JAMF Pro but the name would not stick We wound up using the rename command in the code below and this has worked well for us. Please ignore the bad formatting and underlining. Regards Graeme

Preamble

import urllib.parse import urllib.request import urllib.response import urllib import pypyodbc import sys import csv import codecs import xml.etree.cElementTree as etree import getpass from urllib.request import urlopen import time import datetime from time import strftime from datetime import datetime from datetime import date from operator import itemgetter, attrgetter import mysql.connector

global set to not verify ssl certificate. Bad practice but works here.

import ssl ssl._create_default_https_context = ssl._create_unverified_context userName=input('Username: ') passWord=getpass.getpass('Password: ') top_level_url = "https://mdm.ourschool.edu.au:8443/JSSResource" #create an authorization handler and add to all requests p = urllib.request.HTTPPasswordMgrWithDefaultRealm() p.add_password(None, top_level_url, userName, passWord); auth_handler = urllib.request.HTTPBasicAuthHandler(p) opener = urllib.request.build_opener(auth_handler) opener.addheaders.append(('Accept', 'application/xml')) urllib.request.install_opener(opener)

This will post an XML but is not used here.

def sendXMLtoJSS(resource, method = '', data = None): request = urllib.request.Request(resource) #if method.upper() in ('POST', 'PUT', 'DELETE'): #request.get_method = lambda: method if method.upper() in ('POST', 'PUT') and data: headers = { 'Content-Type' : 'text/xml' } #data = urllib.parse.urlencode(data) data = data.encode('ascii') req = urllib.request.Request(resource, data, headers) req.get_method = lambda: method #req.get_method = method with urllib.request.urlopen(req) as response: the_page = response.read() return the_page #opener.addheaders.append('Content-Type', 'text/xml') #request.add_header('Content-Type', 'text/xml') #return opener.open(request, data) else: try: return opener.open(resource) except IOError as e: print (e) logData(e)

This is the rename command.

def sendRenameCommandtoJSS(id, New_Name): # JAMF says if we are enforcing the name send a command because it is friendlier for cloud customers # but uploading an xml updated the jss but did not save the settings. Had to manually go to the device # properties in JSS and click the edit and then save. # Will error out with a 500 error if a rename command is still outstanding. Devicename = urllib.parse.quote(New_Name) command = top_level_url "/mobiledevicecommands/command/DeviceName/" Devicename "/id/" str(id) req = urllib.request.Request(command) req.get_method = lambda: 'POST' #request = urllib.request.Request(resource) try: response = opener.open(req) strResponse = response.read().decode('utf-8') logData(strResponse) print(New_Name " has been successfully renamed.") #logData(response.read().decode('utf-8')) except urllib.error.HTTPError as e: if e.code == 400: print(New_Name " has an outstanding rename request. Rename failed.") else: print("Rename Error" str(e), command)

This gets the list of devices from the JSS so we can extract the ID

def getDevices(): #Download from JSS an xml list of devices and basic attributes. response = sendXMLtoJSS(top_level_url '/mobiledevices') responseBytes = response.read() responsetext = responseBytes.decode("utf-8", 'ignore') responsetext = unicodeToAscii(responsetext)#Remove special characters. #print(responsetext) xml = etree.fromstring(responsetext) #text_file = open("Output.xml", "wb") #text_file.write(responsetext) #text_file.close() return xml def getDeviceList(xmlOfDevices): for child in xmlOfDevices: #print(child.tag, child.text) deviceId = "" deviceSerial = "" deviceUsername = "" deviceName = "" deviceSupervised = "" try: temp = len(devices) except: devices = [] for group in child: #print(group.tag, group.text) if group.tag == "id": deviceId = group.text if group.tag == "serial_number": deviceSerial = group.text if group.tag == "username": deviceUsername = group.text if group.tag == "device_name": deviceName = group.text if group.tag == "supervised": deviceSupervised = group.text #if deviceId == "63": # print ("ID = 63") device = [deviceId, deviceSerial, deviceUsername, deviceName, deviceSupervised] devices.append(device) return devices

I have a FileMaker database that does this (and more).

It uses the API to first GET all your mobile devices from your JSS and puts them into FileMaker. Then you can use FileMaker to name them however you want. You can then PUT (update) them back into the JSS. Works great.

You can also PUT the Department, Room, Username, Real_Name, email, Building all at the same time as well.

Send me an email (if you use FileMaker) and I will share my database with you.