Self-Join unique for unique values list
Links: https://scarpettagroup.com/filemaker-portal-show-distinct-value-tutorial/ https://community.claris.com/en/s/question/0D50H00006ezabvSAA/filter-from-unique-values
Common Configuration Enumaration (CCE)
The Common Configuration Enumaration (CCE) List provides unique identifiers to security-related system configuration issues in order to improve workflow by facilitating fast and accurate correlation of configuration data across multiple…
Apache macOS
ps aux | grep httpd Internal Apache Binary: /usr/sbin/httpd Start/Stop: sudo /usr/sbin/apachectl start Version: /usr/sbin/apachectl -v Config: /etc/apache2/httpd.conf Find used Apache: which -a httpd whereis httpd /usr/sbin/httpd sudo apachectl stop…
Apple Configuration Profile Reference
https://developer.apple.com/business/documentation/Configuration-Profile-Reference.pdf
How to make files accessible only by root?
sudo chown root:admin /path/to/application
How to autofill a column with multiple values
How to autofill a column with multiple values 1) Select the range B2:B5000 (or whatever your exact range may be) 2) Press F5 (Go to, Special, Blanks) 3) This should…
Jamf Scripting 101 + 201
Commands; More than 1,000 that can be called from terminal and or scripts /bin /sbin /usr/bin /usr/sbin 3rd Party tools /usr/local/bin/jamf Begin Script with She-Bang (!#) Variables are fill-in the…
Simple If Statement in Bash script
#!/bin/bash osVersion=$( sw_vers -productVersion ) if [ $osVersion = "10.14.5" ]; then echo "No upgraded needed." else jamf policy -event runUpgrade fi
Simple While – wait for app to quit
#!/bin/bash while [ $( pgrep TextEdit ) ] do echo Waiting for TextEdit to quit. sleep 2 done echo TextEdit has quit. Link: https://www.youtube.com/watch?v=UQs7-N2_35k
sw_vers – print macOS version information
NAME sw_vers – print macOS version information SYNOPSIS sw_vers sw_vers -productName sw_vers -productVersion sw_vers -buildVersion DESCRIPTION sw_vers prints macOS version information for the currently running operating system on the local…