Calculate usage in hours for a specific application on a specific Mac using Jamf Pro Application Usage information.

Foreground Application Usage.bash

#!/bin/bash
 
# server connection information
URL="https://jamfpro.talkingmoose.net:8443"
userName="api-auditor"
password="P@55w0rd"

# app and computer information
computerID="2"
startDate="2018-12-01"
endDate="2019-04-10"
applicationName="Google Chrome.app"

# API submission command
THExml=$( /usr/bin/curl "$URL/JSSResource/computerapplicationusage/id/$computerID/${startDate}_${endDate}" \
--silent \
--user "$userName:$password" \
--header "Accept: text/xml" \
--request GET )

# get pretty XML
prettyXML=$( /usr/bin/xmllint --format - <<< "$THExml" )

# get information for specific app
parsed=$( /usr/bin/grep -A 2 "$applicationName" <<< "$prettyXML" )

# get information for foreground times for app
foreground=$( /usr/bin/grep "foreground" <<< "$parsed" )
numberList=$( /usr/bin/awk -F ">|<" '{ print $3 }' <<< "$foreground" )

# total seconds
seconds=$( echo "$numberList" | /usr/bin/awk '{ total += $0 } END { print total }' )

# calculate hours of foreground use of application
hours=$( /usr/bin/bc -l <<< "(($seconds/60/60))" )

# count of days between provided dates
days=$(($(($(date -d "$endDate" "+%s") - $(date -d "$startDate" "+%s"))) / 86400))

# calculate average hours per day
hoursPerDay=$( /usr/bin/bc -l <<< "(($hours/$days))" )

echo "User spent an average of $hoursPerDay hours per day over $days days."

exit 0