InKolidebyFritz Ifert-Miller·Dec 14, 20218 SQL snippets to make you an osquery datetime expertLearning to interact with timestamps has never been easier as we explore SQL’s various date and time functions and how they can be used.
InKolidebyFritz Ifert-Miller·Oct 14, 2021Why you can’t trust your NULLs in OsqueryThe pain of empty strings in SQLite: A basic assumption of nearly any database is that the absence of data in a table is recorded as NULL.
InKolidebyFritz Ifert-Miller·Sep 22, 2021Determining Mac Hardware Manufacture Date Using OsqueryCreating virtual lookup tables in SQLite
InKolidebyFritz Ifert-Miller·Dec 28, 2020Modern Macs Still Need FileVaultBuilt-in Mac SSD Encryption Is Easily Bypassed by an Attacker With Physical Access if Filevault Isn’t EnabledA response icon3A response icon3
InKolidebyFritz Ifert-Miller·Jul 23, 2020Checking macOS Screenlock RemotelyThey (we) said it couldn’t be doneA response icon2A response icon2
InKolidebyFritz Ifert-Miller·Mar 16, 2020Are your employees Slack Messages leaking while their screen is locked?Notification Preferences: Interpreting Bit fields with Osquery
InKolidebyFritz Ifert-Miller·Feb 28, 2020How to Set Up Windows File Integrity Monitoring using Osquery and KolideUsing the ntfs_journal_events table in Osquery 4.2.0
InKolidebyFritz Ifert-Miller·Jan 15, 2020Using Kolide + osquery to find and fix critical Windows Crypto VulnerabilityOn Monday the NSA announced a critical vulnerability (CVE-2020–0601) in Windows 10 which allows an attacker to “undermine how Windows…
InKolidebyFritz Ifert-Miller·Nov 26, 2019Manipulating plist and registry output in osqueryPivoting SQL data with MAX & CASE
InKolidebyFritz Ifert-Miller·Oct 9, 2019macOS Catalina & osquery“I’m sorry Dave, I can’t let you query that…”A response icon2A response icon2