osquery_policy (table) Content
- Start Row: 0
- Rows per Page: 50
- Total Rows: 7
- Current Page: 1
- Total Pages: 1
| 01JR04CD2P4PP502MY6E1220G9 | Ad tracking is limited (macOS) | SELECT CASE WHEN EXISTS (SELECT 1 FROM managed_policies WHERE domain='com.apple.AdLib' AND name='forceLimitAdTracking' AND value='1' LIMIT 1) THEN 'true' ELSE 'false' END AS policy_result; | Checks that a mobile device management (MDM) solution configures the Mac to limit advertisement tracking. | Pass | Fail | Contact your IT administrator to ensure your Mac is receiving a profile that disables advertisement tracking. | ["macos"] | |||||||||
| 01JR04CD2PYWA7WZG4Z0C3ZMGY | Antivirus healthy (Linux) | SELECT score FROM (SELECT CASE WHEN COUNT(*) = 2 THEN 'true' ELSE 'false' END AS score FROM processes WHERE (name = 'clamd') OR (name = 'freshclam')) WHERE score = 'true'; | Checks that both ClamAV's daemon and its updater service (freshclam) are running. | Pass | Fail | Ensure ClamAV and Freshclam are installed and running. | ["linux","windows","macos"] | |||||||||
| 01JR04CD2PGEDE3QTZ17JHPQRV | Antivirus healthy (macOS) | SELECT score FROM (SELECT case when COUNT(*) = 2 then 1 ELSE 0 END AS score FROM plist WHERE (key = 'CFBundleShortVersionString' AND path = '/Library/Apple/System/Library/CoreServices/XProtect.bundle/Contents/Info.plist' AND value>=2162) OR (key = 'CFBundleShortVersionString' AND path = '/Library/Apple/System/Library/CoreServices/MRT.app/Contents/Info.plist' and value>=1.93)) WHERE score == 1; | Checks the version of Malware Removal Tool (MRT) and the built-in macOS AV (Xprotect). Replace version numbers with the latest version regularly. | Pass | Fail | To enable automatic security definition updates, on the failing device, select System Preferences > Software Update > Advanced > Turn on Install system data files and security updates. | ["macos"] | |||||||||
| 01JR04CD2PG6QJ54RRMAWY5HWN | Antivirus healthy (Windows) | SELECT 1 from windows_security_center wsc CROSS JOIN windows_security_products wsp WHERE antivirus = 'Good' AND type = 'Antivirus' AND signatures_up_to_date=1; | Checks the status of antivirus and signature updates from the Windows Security Center. | Pass | Fail | Ensure Windows Defender or your third-party antivirus is running, up to date, and visible in the Windows Security Center. | ["windows"] | |||||||||
| 01JR04CD2PBXG18K1ZKB7568AW | Automatic installation of application updates is enabled (macOS) | SELECT 1 FROM managed_policies WHERE domain='com.apple.SoftwareUpdate' AND name='AutomaticallyInstallAppUpdates' AND value=1 LIMIT 1; | Checks that a mobile device management (MDM) solution configures the Mac to automatically install updates to App Store applications. | Pass | Fail | Contact your IT administrator to ensure your Mac is receiving a profile that enables automatic installation of application updates. | ["macos"] | |||||||||
| 01JR04CD2P8PFXBD07XSW9RAJQ | Automatic installation of operating system updates is enabled (macOS) | SELECT 1 FROM managed_policies WHERE domain='com.apple.SoftwareUpdate' AND name='AutomaticallyInstallMacOSUpdates' AND value=1 LIMIT 1; | Checks that a mobile device management (MDM) solution configures the Mac to automatically install operating system updates. | Pass | Fail | Contact your IT administrator to ensure your Mac is receiving a profile that enables automatic installation of operating system updates. | ["macos"] | |||||||||
| 01JR04CD2PT3CAHM8XHCV9Q73A | Ensure 'Minimum password length' is set to '14 or more characters' | SELECT 1 FROM security_profile_info WHERE minimum_password_length >= 14; | This policy setting determines the least number of characters that make up a password for a user account. | Pass | Fail | Automatic method: Ask your system administrator to establish the recommended configuration via GP, set the following UI path to 14 or more characters 'Computer ConfigurationPoliciesWindows SettingsSecurity SettingsAccount PoliciesPassword PolicyMinimum password length' | ["windows"] |
Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in query number 6:
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: ), found: $current_page at Line: 42, Column: 35"console/content/table/osquery_policy.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.