Script to filter mac from OCS exported file and prints OFFICESCAN exported file without mac matched lines

print-ocs-not-installed.sh

#!/bin/bash

# Script to filter mac from OCS exported file and prints 
# OFFICESCAN exported file without mac matched lines
# Need csvkit installed: pip install csvkit

set -e

OFFICESCAN="OfficeScan agent listing.csv"
OCS="export.csv"
MACLIST="ocsmaclist.tmp"
OUTPUT="output.tmp"

cp "${OFFICESCAN}" "${OUTPUT}"
sed 1d "${OCS}" | awk -F ";" '{print $7}' | tr ':' '-' | sed '/^$/d' > "${MACLIST}"
while IFS= read -r OCSMAC; do
    sed -i "/${OCSMAC}/d" "${OUTPUT}"
done < "${MACLIST}"

csvcut -c 2,3,21,60 "${OUTPUT}"
rm "${MACLIST}"
rm "${OUTPUT}"