Rename a computer using the Jamf binary and a Google Sheet - full details: https://www.macblog.org/post/automatically-renaming-computers-from-a-google-sheet-with-jamf-pro/

rename-computer.py

#!/usr/bin/python
'''
Rename computer from remote CSV using Jamf binary

Pass in the URL to your remote CSV file using script parameter 4

The remote CSV could live on a web server you control, OR be a Google Sheet
specified in the following format:

https://docs.google.com/spreadsheets/u/0/d/<document ID>/export?format=csv&id=<document ID>&gid=0
'''


import os
import sys
import urllib2
import subprocess


CSV_PATH = '/var/tmp/computernames.csv'


def download_csv(url):
    '''Downloads a remote CSV file to CSV_PATH'''
    try:
        # open the url
        csv = urllib2.urlopen(url)
        # ensure the local path exists
        directory = os.path.dirname(CSV_PATH)
        if not os.path.exists(directory):
            os.makedirs(directory)
        # write the csv data to the local file
        with open(CSV_PATH, 'w+') as local_file:
            local_file.write(csv.read())
        # return path to local csv file to pass along
        return CSV_PATH
    except (urllib2.HTTPError, urllib2.URLError):
        print 'ERROR: Unable to open URL', url
        return False
    except (IOError, OSError):
        print 'ERROR: Unable to write file at', CSV_PATH
        return False


def rename_computer(path):
    '''Renames a computer using the Jamf binary and local CSV at <path>'''
    cmd = ['/usr/local/bin/jamf', 'setComputerName', '-fromFile', path]
    proc = subprocess.Popen(cmd, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
    out, _ = proc.communicate()
    if proc.returncode == 0:
        # on success the jamf binary reports 'Set Computer Name to XXX'
        # so we split the phrase and return the last element
        return out.split(' ')[-1]
    else:
        return False


def main():
    '''Main'''
    try:
        csv_url = sys.argv[4]
    except ValueError:
        print 'ERROR: You must provide the URL of a remote CSV file.'
        sys.exit(1)
    computernames = download_csv(csv_url)
    if computernames:
        rename = rename_computer(computernames)
        if rename:
            print 'SUCCESS: Set computer name to', rename
        else:
            print ('ERROR: Unable to set computer name. Is this device in the '
                   'remote CSV file?')
            sys.exit(1)
    else:
        print 'ERROR: Unable to set computer name without local CSV file.'
        sys.exit(1)


if __name__ == '__main__':
    main()

Hi,

Is there any update available for running this on MacOS 12.3?

I've been looking for an update too. Any luck anyone?

We are still running this on macs using 12.5 with no issue.

…

On Mon, Aug 15, 2022 at 10:28 AM zubair-k ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ I've been looking for an update too. Any luck anyone? — Reply to this email directly, view it on GitHub <https://gist.github.com/1debf91078ce75612bf2f0c3b3d99f03#gistcomment-4267559>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKBSQSJGTX7I53GL2YEIUD3VZJO2ZANCNFSM4JTVZ3FA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- *Kevin Kolcz, CETL* Technology Services Supervisor Varsity Girls Volleyball Coach Freshman Boys Volleyball Coach *Prospect High School* 801 West Kensington Road | Mount Prospect, IL 60056 (847)718-5025

-- If this is a Freedom of Information Act request, please forward the request to District 214's FOIA Officer Patrick Mogge at ***@***.*** ***@***.***> All e-mail correspondence to and from this address is subject to the Acceptable Use Policies of District 214, which may result in monitoring and disclosure to third parties, including law enforcement.  Any views or opinions presented in this e-mail are solely those of the author and might not represent those of Township High School District 214.

Thank you @kolczk,
@rvtkruys-valtech after digging further it's only happening on M1 macs running 12.3+. Try checking the version of Python in /usr/lib.
I only had Python3 in the library which needs to be installed after editing the script to call on Python 3.

Hi @zubair-k,

I have used another script, similar to this, but using Bash. The script for renaming computer names are processed during the zero touch deployment (DEP Notify). I didn't had to time yet to research on how to deploy Python3 during the zero touch deployment.

I've shared a minimal reimplementation of this functionality in ZSH here: https://gist.github.com/haircut/2a409fffe55ba65aa353642e5697f38b

Hello
Is there any update to run this on MacOS 13 upwards? I tried to work with the reimplantation you @haircut posted an the other link but I am not let it work correctly.