If you receive "0 computers matched" "Attempting to upload computers to group x" -- With the result that no computers get added to the static group:

• A possible solution is to ensure your input file does not contain any extensions (.txt) in the filename!

Thank you @alexjdale and @cshepp11 , for sharing this script. I was able to make half way.
Do you also have script to remove computers from static group? Please share with me if you got one ready.
I was trying to modify the given script to remove computers in it but it was deleting the static group itself.

Thank you.

@Naren Take a look at the thread Script to add a device to a computer group? for an example of how to add a computer to an existing Static Group rather than replacing the contents of the group. Following the example in that thread you can use computer_deletions instead of computer_additions to remove computers from a group instead of adding them.

Thank you @sdagley for sharing the link. I was trying with two different scripts one to add multiple computers to static group other to remove from static group.
But when i was trying to execute the script it is adding or removing only the last entry from excel.
For example my .csv file has four computers and script is actually only reacting to the last one in it. @cshepp11

!/bin/bash

currentuser=$(stat -f%Su /dev/console)
HostName=$(scutil --get ComputerName)
logdir="/Users/${currentuser}/Desktop/AdminExceptions.csv"

Verify input file exists

if [ ! -f "${logdir}" ]; then echo "Input file not found, exiting" exit 1
fi
IMPORTLIST="${logdir}"

EXPORTFLAG=€1.80

exportCSV="/tmp/JSSFailures.csv"

Hostname of JSS

JSS="jssportal.com"

Group ID for target static group

JSSGROUPID="53"
JSSGROUPNAME="AdminRightExceptions"

API service account credentials

JSSUSER="apiuser"
JSSPASS="apipwd"

Start building XML for computer group, which will be uploaded at the end

GROUPXML="<computer_group><computer_deletions>"

if [ ! "$JSS" ] || [ ! "$JSSGROUPID" ] || [ ! "$JSSUSER" ] || [ ! "$JSSPASS" ]; then echo "Required variables have not all been entered. Please validate and retry." exit 1
fi

echo "Input file: ${logdir}"

Read list into an array

inputArraycounter=0
while read line || [[ -n "$line" ]]; do inputArray[$inputArraycounter]="$line" inputArraycounter=$[inputArraycounter+1]
done < "$IMPORTLIST"
echo "${#inputArray[@]} lines found"

foundCounter=0
for ((i = 0; i < ${#inputArray[@]}; i++)); do echo "Processing ${inputArray[$i]}" nameLookup=curl -s -k -u $JSSUSER:$JSSPASS https://$JSS:8443/JSSResource/computers/name/${inputArray[$i]} sizeLookup=echo $nameLookup | xpath //size 2>/dev/null | tr -cd [:digit:] if [ "$sizeLookup" != "" ]; then idLookup=echo $nameLookup | xpath //id 2>/dev/null if [ "$idLookup" ]; then GROUPXML="$GROUPXML<computer>$idLookup</computer>" foundCounter=$((foundCounter+1)) fi echo "Match found, adding to group"
else echo "$sizeLookup entries found, skipping." if [ "$EXPORTFLAG" = "export" ]; then echo "${inputArray[$i]},$sizeLookup computers matched">>$exportCSV fi fi
done
GROUPXML="$GROUPXML</computer_deletions></computer_group>"
echo "$foundCounter computers matched"

deleting computer from casper with UUID

echo "Attempting to Delete computers from group $JSSGROUPID"
curl -s -v -k -u $JSSUSER:$JSSPASS https://$JSS:8443/JSSResource/computergroups/id/$JSSGROUPID -X PUT -HContent-type:application/xml --data $GROUPXML

@sdagley any idea why its picking up only last line in the lookup, for example if I have 3 values, a, b, c in the list it will only process value c and leave other 2 items?

Hey, in order to run script in Big Sur, use xpath5.18

1#!/bin/bash
2
3# Copyright 2014 by Alex Dale
4# Add computers to a static group in a JSS from a plaintext list of computer names
5#
6# Make sure your target group is a static group and is empty, or it will be overwritten
7# Input file must have one name per line.
8# Usage: scriptname.sh /path/to/input/file
9# Add "export" as an optional argument after input file to export a csv with failed system lookup info to /tmp/JSSFailures.csv
10# Searches are performed with a wildcard at the end to catch names with (2), etc appended to the name by the OS
11# Multiple matches (due to wildcard or dupe records) will be skipped, for safety
12# 
13# Test this first on your dev JSS!  I cannot account for all scenarios.
14
15#Verify input file exists
16if [ ! -f "$1" ]; then
17    echo "Input file not found, exiting"
18    exit 1
19fi
20IMPORTLIST=$1
21EXPORTFLAG=$2
22exportCSV="/tmp/JSSFailures.csv"
23# Hostname of JSS
24JSS="jss.domain.com"
25# Group ID for target static group
26JSSGROUPID="inputyourgroupidhere"
27# API service account credentials
28JSSUSER="username"
29JSSPASS="password"
30# Start building XML for computer group, which will be uploaded at the end
31GROUPXML="<computer_group><computers>"
32
33if [ ! "$JSS" ] || [ ! "$JSSGROUPID" ] || [ ! "$JSSUSER" ] || [ ! "$JSSPASS" ]; then
34    echo "Required variables have not all been entered.  Please validate and retry."
35    exit 1
36fi
37
38echo "Input file: $1"
39
40# Read list into an array
41inputArraycounter=0
42while read line || [[ -n "$line" ]]; do
43    inputArray[$inputArraycounter]="$line"
44    inputArraycounter=$[inputArraycounter+1]
45done < "$IMPORTLIST"
46echo "${#inputArray[@]} lines found"
47
48foundCounter=0
49for ((i = 0; i < ${#inputArray[@]}; i++)); do
50    echo "Processing ${inputArray[$i]}"
51    nameLookup=`curl -s -k -u $JSSUSER:$JSSPASS https://$JSS:8443/JSSResource/computers/name/${inputArray[$i]}`
52    sizeLookup=`echo $nameLookup | xpath5.18 //size 2>/dev/null | tr -cd [:digit:]`
53    if [ "$sizeLookup" != "" ]; then
54        idLookup=`echo $nameLookup | xpath5.18 //id 2>/dev/null`
55        if [ "$idLookup" ]; then
56            GROUPXML="$GROUPXML<computer>$idLookup</computer>"
57            foundCounter=`expr $foundCounter + 1`
58        fi
59        echo "Match found, adding to group"
60    else
61        echo "$sizeLookup entries found, skipping."
62        if [ "$EXPORTFLAG" = "export" ]; then
63            echo "${inputArray[$i]},$sizeLookup computers matched">>$exportCSV
64        fi
65    fi
66done
67GROUPXML="$GROUPXML</computers></computer_group>"
68
69echo "$foundCounter computers matched"
70
71echo "Attempting to upload computers to group $JSSGROUPID"
72curl -s -k -u $JSSUSER:$JSSPASS https://$JSS:8443/JSSResource/computergroups/id/$JSSGROUPID -X PUT -HContent-type:application/xml --data $GROUPXML