Office updates - little script help

Anyone?

@jameson Patience, my friend.

#!/bin/bash

apps=(
    Microsoft_PowerPoint
    Microsoft_Word
    Microsoft_Excel
    Microsoft_Outlook
)

# Get all the MSau temp dirs (there can be multiple)
while read -r line; do
    tempDirs+=("$line")
done <<< "$(/usr/bin/find "${TMPDIR%/}" -name "MSau*" -type d -maxdepth 1 -mindepth 1)"

# Look in each temp directory for any of the update packages, if they exist add them to the updates array
for tempDir in "${tempDirs[@]}"; do
    for app in "${apps[@]}"; do
        appFound=$(/usr/bin/find "$tempDir" -name "$app*" -type f -maxdepth 1 -mindepth 1 | awk -F '/' '{print $NF}')
        if [[ -n "$appFound" ]]; then
            updates+=("$appFound")
        fi
    done
done

# If the array is not empty, print out the array, otherwise print out an empty result
if [[ "${#updates[@]}" -ge 1 ]]; then
    echo "<result>$( /usr/bin/printf '%s
' "${updates[@]}" )</result>"
else
    echo "<result></result>"
fi

Thank you very much :)

Running the script manually it works fine and rapport correct back, but when added it as EA it seems not to find anything on the client and rapport it is empty (yes have tried a recon first:) )

@jameson Jamf Pro might not like the new lines in the output. I also found that sometimes the update packages look like "Word_16.23.19030902_to_16.25.19051201_Delta.pkg", so I accounted for that. Try this:

#!/bin/bash

apps=(
    PowerPoint
    Word
    Excel
    Outlook
    SkypeForBusiness
)

declare -a updates

# Get all the MSau temp dirs (there can be multiple)
while read -r line; do
    tempDirs+=("$line")
done <<< "$(/usr/bin/find "${TMPDIR%/}" -name "MSau*" -type d -maxdepth 1 -mindepth 1)"

# Look in each temp directory for any of the update packages, if they exist add them to the updates array
for tempDir in "${tempDirs[@]}"; do
    for app in "${apps[@]}"; do
        appFound=$(/usr/bin/find "$tempDir" -name "*$app*" -type f -maxdepth 1 -mindepth 1 | awk -F '/' '{print $NF}')
        if [[ -n "$appFound" ]]; then
            updates+=("$appFound")
        fi
    done
done

# If the array is not empty, print out the array, otherwise print out an empty result
if [[ "${#updates[@]}" -ge 1 ]]; then
    echo "<result>${updates[*]}</result>"
else
    echo "<result></result>"
fi

No - still not working. If no updates are there it rapports none - so somehow it must be the naming etc since nothing is showed when updates are there

I cannot help on the scripting, but could be interesting to get this EA working so it Is possible to track which clients that have updates pending.
Maybe @mm2270 ] can help on this as I know he is a scripting "guru" :)

It must have something to do with the multi-line result and Jamf Pro not liking that. I don't want to test the EA in my environment though.

By default, Microsoft AutoUpdate (MAU) checks for updates every 12 hours. If updates are pending, users get notified. You could use a configuration profile to increase the check frequency and MAU will notify users more often without you having to do anything.

This little slide in no users take note of - Guess it is part of to many things during the years has been sliding in and often with unecessary information.
So hope it Can be solved

Yes Usera are not good to note these information sliding in. I am not a script guy, but is there any other way to create the script as there often a various ways to reach the goal