Hi all,
I've been handed a LONG list of Usernames, and I need to make a list of any computer serial numbers associated with those Usernames.
I'm assuming this is a custom API call, does anybody have anything cooked up and ready to go?
Thanks!
Page 1 / 1
Been a little while since I had to use this, but input a csv of usernames and it should create a static group.
#!/bin/sh
set -x
#
# HARDCODED VALUES SET HERE
#
#Name our static Computer group (No spaces in name)
Name="$(osascript -e 'display dialog "Please enter the group name you want (all one word):" default answer "" with title "Group Name" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in the URL of the JSS we are are pulling and pushing the data to. (NOTE: We will need the https:// and :8443. EX:https://jss.company.com:8443 )
jssURL="$(osascript -e 'display dialog "Please enter the jss URL:" default answer "https://server.com:8443" with title "jss URL" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in a username and password that has the correct read and write permissions to the JSS API for what data we need
jssUser="$(osascript -e 'display dialog "Please enter Username:" default answer "" with title "jss Username" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
jssPass="$(osascript -e 'display dialog "Please enter Password:" default answer "" with title "jss Password" giving up after 86400 with text buttons {"OK"} default button 1 with hidden answer' -e 'return text returned of result')"
#CSF file path for list
devicelist="/tmp/ids.csv"
touch /tmp/ids.csv
userlist="$(osascript -e 'display dialog "Please enter the path to Username List (Drag and drop csv file):" default answer "" with title "Path to Username File" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Default temp file name and path we will build for API submission. - No need to edit this
groupFilePath="/tmp/devices.xml"
jamfHelper="/Library/Application Support/JAMF/bin/jamfHelper.app/Contents/MacOS/jamfHelper"
#####No configuration variables below this line. You should not need to edit unless you are modifying functionality
#####################################################################################################
echo "Finding Computer IDs for users in migration list"
l=`cat $userlist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, names=($l)
IFS="$PREV_IFS" # Restore IFS
for nam in ${names[@]}; do
list=$(curl -H "Accept: application/xml" -H "Content-Type: application/xml" -X GET -k --user "$jssUser":"$jssPass" "$jssURL"/JSSResource/users/email/$nam | xpath /users/user/links/computers/computer/id)
echo $list | sed 's/<id>//g' | sed 's/<\\/id>/\\'$'\\n/g' >> "$devicelist"
done
#Create new static user group
var1="<computer_group><name>"$Name"</name><is_smart>false</is_smart></computer_group>"
echo ${var1} > /tmp/newdevicegroup.xml
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/"$Name" -T "/tmp/newdevicegroup.xml" -X POST
#We will use these variable to build our xml file
a="<computer_group><computers>"
b="<computer>"
c="</computer>"
d="</computers></computer_group>"
#Build our array of values
echo "Building the array from CSV..."
v=`cat $devicelist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, values=($v)
IFS="$PREV_IFS" # Restore IFS
#Build the XML from the array
echo "Building the xml at $groupFilePath..."
echo "$a" > "$groupFilePath"
for val in ${values[@]}; do
echo "$b" >> "$groupFilePath"
echo "<id>$val</id>" >> "$groupFilePath"
echo "$c" >> "$groupFilePath"
done
echo "$d" >> "$groupFilePath"
#Submit group to JSS
echo "File submitting to $jssURL..."
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/$Name -T "$groupFilePath" -X PUT
#Clean up
rm "$groupFilePath"
rm "$devicelist"
rm /tmp/newdevicegroup.xml
"$jamfHelper" -windowType "utility" -title "Script Done" -description "Script Finished Running" -timeout 300 -button1 "OK"
Been a little while since I had to use this, but input a csv of usernames and it should create a static group.
#!/bin/sh
set -x
#
# HARDCODED VALUES SET HERE
#
#Name our static Computer group (No spaces in name)
Name="$(osascript -e 'display dialog "Please enter the group name you want (all one word):" default answer "" with title "Group Name" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in the URL of the JSS we are are pulling and pushing the data to. (NOTE: We will need the https:// and :8443. EX:https://jss.company.com:8443 )
jssURL="$(osascript -e 'display dialog "Please enter the jss URL:" default answer "https://server.com:8443" with title "jss URL" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in a username and password that has the correct read and write permissions to the JSS API for what data we need
jssUser="$(osascript -e 'display dialog "Please enter Username:" default answer "" with title "jss Username" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
jssPass="$(osascript -e 'display dialog "Please enter Password:" default answer "" with title "jss Password" giving up after 86400 with text buttons {"OK"} default button 1 with hidden answer' -e 'return text returned of result')"
#CSF file path for list
devicelist="/tmp/ids.csv"
touch /tmp/ids.csv
userlist="$(osascript -e 'display dialog "Please enter the path to Username List (Drag and drop csv file):" default answer "" with title "Path to Username File" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Default temp file name and path we will build for API submission. - No need to edit this
groupFilePath="/tmp/devices.xml"
jamfHelper="/Library/Application Support/JAMF/bin/jamfHelper.app/Contents/MacOS/jamfHelper"
#####No configuration variables below this line. You should not need to edit unless you are modifying functionality
#####################################################################################################
echo "Finding Computer IDs for users in migration list"
l=`cat $userlist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, names=($l)
IFS="$PREV_IFS" # Restore IFS
for nam in ${names[@]}; do
list=$(curl -H "Accept: application/xml" -H "Content-Type: application/xml" -X GET -k --user "$jssUser":"$jssPass" "$jssURL"/JSSResource/users/email/$nam | xpath /users/user/links/computers/computer/id)
echo $list | sed 's/<id>//g' | sed 's/<\\/id>/\\'$'\\n/g' >> "$devicelist"
done
#Create new static user group
var1="<computer_group><name>"$Name"</name><is_smart>false</is_smart></computer_group>"
echo ${var1} > /tmp/newdevicegroup.xml
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/"$Name" -T "/tmp/newdevicegroup.xml" -X POST
#We will use these variable to build our xml file
a="<computer_group><computers>"
b="<computer>"
c="</computer>"
d="</computers></computer_group>"
#Build our array of values
echo "Building the array from CSV..."
v=`cat $devicelist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, values=($v)
IFS="$PREV_IFS" # Restore IFS
#Build the XML from the array
echo "Building the xml at $groupFilePath..."
echo "$a" > "$groupFilePath"
for val in ${values[@]}; do
echo "$b" >> "$groupFilePath"
echo "<id>$val</id>" >> "$groupFilePath"
echo "$c" >> "$groupFilePath"
done
echo "$d" >> "$groupFilePath"
#Submit group to JSS
echo "File submitting to $jssURL..."
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/$Name -T "$groupFilePath" -X PUT
#Clean up
rm "$groupFilePath"
rm "$devicelist"
rm /tmp/newdevicegroup.xml
"$jamfHelper" -windowType "utility" -title "Script Done" -description "Script Finished Running" -timeout 300 -button1 "OK"this looks awesome, I'll give it a shot. Thanks!
Been a little while since I had to use this, but input a csv of usernames and it should create a static group.
#!/bin/sh
set -x
#
# HARDCODED VALUES SET HERE
#
#Name our static Computer group (No spaces in name)
Name="$(osascript -e 'display dialog "Please enter the group name you want (all one word):" default answer "" with title "Group Name" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in the URL of the JSS we are are pulling and pushing the data to. (NOTE: We will need the https:// and :8443. EX:https://jss.company.com:8443 )
jssURL="$(osascript -e 'display dialog "Please enter the jss URL:" default answer "https://server.com:8443" with title "jss URL" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Enter in a username and password that has the correct read and write permissions to the JSS API for what data we need
jssUser="$(osascript -e 'display dialog "Please enter Username:" default answer "" with title "jss Username" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
jssPass="$(osascript -e 'display dialog "Please enter Password:" default answer "" with title "jss Password" giving up after 86400 with text buttons {"OK"} default button 1 with hidden answer' -e 'return text returned of result')"
#CSF file path for list
devicelist="/tmp/ids.csv"
touch /tmp/ids.csv
userlist="$(osascript -e 'display dialog "Please enter the path to Username List (Drag and drop csv file):" default answer "" with title "Path to Username File" giving up after 86400 with text buttons {"OK"} default button 1' -e 'return text returned of result')"
#Default temp file name and path we will build for API submission. - No need to edit this
groupFilePath="/tmp/devices.xml"
jamfHelper="/Library/Application Support/JAMF/bin/jamfHelper.app/Contents/MacOS/jamfHelper"
#####No configuration variables below this line. You should not need to edit unless you are modifying functionality
#####################################################################################################
echo "Finding Computer IDs for users in migration list"
l=`cat $userlist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, names=($l)
IFS="$PREV_IFS" # Restore IFS
for nam in ${names[@]}; do
list=$(curl -H "Accept: application/xml" -H "Content-Type: application/xml" -X GET -k --user "$jssUser":"$jssPass" "$jssURL"/JSSResource/users/email/$nam | xpath /users/user/links/computers/computer/id)
echo $list | sed 's/<id>//g' | sed 's/<\\/id>/\\'$'\\n/g' >> "$devicelist"
done
#Create new static user group
var1="<computer_group><name>"$Name"</name><is_smart>false</is_smart></computer_group>"
echo ${var1} > /tmp/newdevicegroup.xml
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/"$Name" -T "/tmp/newdevicegroup.xml" -X POST
#We will use these variable to build our xml file
a="<computer_group><computers>"
b="<computer>"
c="</computer>"
d="</computers></computer_group>"
#Build our array of values
echo "Building the array from CSV..."
v=`cat $devicelist`
PREV_IFS="$IFS" # Save previous IFS
IFS=, values=($v)
IFS="$PREV_IFS" # Restore IFS
#Build the XML from the array
echo "Building the xml at $groupFilePath..."
echo "$a" > "$groupFilePath"
for val in ${values[@]}; do
echo "$b" >> "$groupFilePath"
echo "<id>$val</id>" >> "$groupFilePath"
echo "$c" >> "$groupFilePath"
done
echo "$d" >> "$groupFilePath"
#Submit group to JSS
echo "File submitting to $jssURL..."
curl -k -v -u "$jssUser":"$jssPass" "$jssURL"/JSSResource/computergroups/name/$Name -T "$groupFilePath" -X PUT
#Clean up
rm "$groupFilePath"
rm "$devicelist"
rm /tmp/newdevicegroup.xml
"$jamfHelper" -windowType "utility" -title "Script Done" -description "Script Finished Running" -timeout 300 -button1 "OK"This worked great- I did have to change the line with xpath to:
xmllint --xpath "//users/user/links/computers/computer/id" -
for it to work, but otherwise was great! Thanks so much.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.