PopulateMobileDeviceAssetTags.sh

#!/bin/bash

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# 
# Written by: William Smith
# Professional Services Engineer
# Jamf
# bill@talkingmoose.net
# https://github.com/talkingmoose/Jamf-Scripts
#
# Originally posted: April 21, 2015
# Last updated: August 13, 2018
#
# Purpose: Searches a Jamf Pro server for mobile device assets
# with empty Asset Tag fields and populates those fields from lists
# provided by Apple. Script relies on the Jamf Pro Classic API. Requires
# a text file of device serial numbers and asset tags in the format
# "SerialNumber > tab > AssetTag > return" and named FullList.txt in
# the same directory as the script.
#
# The script creates a log file in the same folder as the script.
#
# Except where otherwise noted, this work is licensed under
# http://creativecommons.org/licenses/by/4.0/
# 
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #


####################################
# start the timer
####################################


# the time right now
startTime=$( /bin/date '+%s' )


####################################
# Jamf Pro URL and credentials
####################################


URL="https://jamfpro.domain.com:8443"
userName="API-Editor"
passWord="password"


####################################
# File locations
####################################


# path to this script
currentDirectory=$( /usr/bin/dirname "$0" )

# name of this script
currentScript=$( /usr/bin/basename -s .sh "$0" )

# set the log file in same directory as script
logFile="$currentDirectory/$currentScript - $( /bin/date '+%y-%m-%d' ).log"

# store Apple-provided spreadsheets file in same directory as script
fullList=$( /bin/cat "$currentDirectory/FullList.txt" )


####################################
# Functions
####################################


function stripreturns()	{
	stripped=$( /bin/echo $1 | /usr/bin/xmllint --noblanks - )
	/bin/echo $stripped
}


function logresult()	{
	if [ $? = 0 ] ; then
	  /bin/date "+%Y-%m-%d %H:%M:%S	$1" >> "$logFile"
	else
	  /bin/date "+%Y-%m-%d %H:%M:%S	$2" >> "$logFile"
	fi
}


####################################
# Create list of computer
# serial numbers without asset tags
####################################


# start the log
logresult "--------------------- Begin Script ---------------------"

# rotate logs -- delete all but the five most recent log files
deleteOldLogs=$( /bin/ls -1t "$currentDirectory/$currentScript"*.log | /usr/bin/tail -n +6 )

while IFS= read -r aLine
do
	logFileName=$( /usr/bin/basename "$aLine" )
	/bin/rm "$aLine"
	logresult "Deleting old log file: $logFileName."
done <<< "$deleteOldLogs"

# creating a list of computers without asset tags
logresult "Gathering list of computers without asset tags."

# human-readable POST XML for a new search
TEHxml="<advanced_mobile_device_search>
		<name>Mobile Devices with no asset tags as of $( /bin/date )</name>
		<criteria>
			<criterion>
				<name>Asset Tag</name>
				<priority>0</priority>
				<and_or>and</and_or>
				<search_type>is</search_type>
				<value></value>
			</criterion>
		</criteria>
		<display_fields>
			<display_field>
				<name>Serial Number</name>
			</display_field>
		</display_fields>
	</advanced_mobile_device_search>"

# this strips the returns before POSTing the XML
POSTxml=$( stripreturns "$TEHxml" )

# create a temporary advanced computer search in the Jamf Pro server using the criteria in the POST XML above		
createSearch=$( /usr/bin/curl -k -s 0 $URL/JSSResource/advancedmobiledevicesearches/id/0 --user "$userName:$passWord" -H "Content-Type: text/xml" -X POST -d "$POSTxml" )

# log the result
logresult "Created temporary Advanced Mobile Device Search in Jamf Pro at $URL." "Failed creating temporary Advanced Mobile Device Search in Jamf Pro at $URL."

# get temporary advanced computer search ID
searchID=$( /bin/echo $createSearch | /usr/bin/awk -F "<id>|</id>" '{ print $2 }' )

# run the search and return serial numbers
search=$( /usr/bin/curl -k -s 0 $URL/JSSResource/advancedmobiledevicesearches/id/$searchID --user "$userName:$passWord" -H "Accept: text/xml" -X GET )

# turn the returned list into a list of just serial numbers
serialNumberList=$( /bin/echo "$search" | /usr/bin/perl -lne 'BEGIN{undef $/} while (/<Serial_Number>(.*?)<\/Serial_Number>/sg){print $1}' )

# count the serial numbers and log the results
serialNumberCount=$( /bin/echo $serialNumberList | /usr/bin/wc -w )
serialNumberCount=$( stripreturns "$serialNumberCount" )

# log the result
logresult "Found $serialNumberCount mobile devices without asset tags." "Failed finding mobile devices without asset tags."

# delete the temporary advanced computer search
/usr/bin/curl -k -s 0 $URL/JSSResource/advancedmobiledevicesearches/id/$searchID --user "$userName:$passWord" -X DELETE

# log the result
logresult "Deleted temporary Advanced Mobile Device Search." "Failed deleting temporary Advanced Computer Search."


####################################
# Compare Apple's list of serial
# numbers with the found list of
# serial numbers. Populate asset
# tags for serial numbers that
# have no asset tag.
####################################

for aLine in $serialNumberList
do
	matchedDevice=$( echo "$fullList" | grep "$aLine" )
	
	if [ "$matchedDevice" = "" ] ; then
		# log the result
		logresult "Serial number $aLine not found in the spreadsheet from Apple."
	else
		serialNumber=$( /bin/echo "$matchedDevice" | /usr/bin/awk '{ print $1 }' )
		assetTag=$( /bin/echo "$matchedDevice" | /usr/bin/awk '{ print $2 }' )
		
		THExml="<mobile_device>
				<general>
					<asset_tag>$assetTag</asset_tag>
				</general>
			</mobile_device>"
		
		PUTxml=$( stripreturns "$THExml" )
		
		/usr/bin/curl -k 0 $URL/JSSResource/mobiledevices/serialnumber/$serialNumber --user "$userName:$passWord" -H "Content-Type: text/xml" -X PUT -d "$PUTxml"
		
		# log the result
		logresult "Added asset tag $assetTag to mobile device with serial number $serialNumber." "Failed to add asset tag $assetTag to mobile device with serial number $serialNumber."
		
		# keep count of populated asset tags
		matched=$((matched+1))
	fi
	
done


####################################
# stop the timer
# calculate how long the script ran
####################################


logresult "Completing script."
logresult "Populated $matched asset tags of $serialNumberCount mobile devices without asset tags."

# the time right now
stopTime=$( /bin/date '+%s' )

# subtract start time from stop time and log the time in seconds
DIFF=$(($stopTime-$startTime))
logresult "Script operations took $DIFF seconds to complete."


logresult "---------------------- End Script ----------------------

"

exit 0