Implementing Osquery for Endpoint Monitoring

Instructions

1. Install dependencies: pip install requests (osquery installed on endpoints)
2. Generate osquery.conf with scheduled query packs for:

• Process monitoring: new processes, unusual parent-child relationships
• Network listeners: unexpected listening ports and outbound connections
• File integrity: modifications in /etc, /usr/bin, system32
• Persistence: cron jobs, startup items, scheduled tasks, services

1. Deploy configuration to endpoints.
2. Analyze differential results from osquery log output.
3. Generate security findings report.

python scripts/agent.py --results-dir /var/log/osquery/results/ --output osquery_report.json

Examples

Osquery Scheduled Query

{"schedule": {"process_snapshot": {"query": "SELECT pid, name, path, cmdline, uid FROM processes WHERE on_disk = 0;", "interval": 300}}}

Verification Criteria

Confirm successful execution by validating:

• [ ] All prerequisite tools and access requirements are satisfied
• [ ] Each workflow step completed without errors
• [ ] Output matches expected format and contains expected data
• [ ] No security warnings or misconfigurations detected
• [ ] Results are documented and evidence is preserved for audit

Compliance Framework Mapping

This skill supports compliance evidence collection across multiple frameworks:

• SOC 2: CC7.1 (Monitoring), CC7.2 (Anomaly Detection), CC7.3 (Incident Identification)
• ISO 27001: A.12.4 (Logging & Monitoring), A.16.1 (Security Incident Management)
• NIST 800-53: AU-6 (Audit Review), SI-4 (System Monitoring), IR-5 (Incident Monitoring)
• NIST CSF: DE.AE (Anomalies & Events), DE.CM (Continuous Monitoring)

Claw GRC Tip: When this skill is executed by a registered agent, compliance evidence is automatically captured and mapped to the relevant controls in your active frameworks.

Deploying This Skill with Claw GRC

Agent Execution

Register this skill with your Claw GRC agent for automated execution:

# Install via CLI
npx claw-grc skills add implementing-osquery-for-endpoint-monitoring

# Or load dynamically via MCP
grc.load_skill("implementing-osquery-for-endpoint-monitoring")

Audit Trail Integration

When executed through Claw GRC, every step of this skill generates tamper-evident audit records:

• SHA-256 chain hashing ensures no step can be modified after execution
• Evidence artifacts (configs, scan results, logs) are automatically attached to relevant controls
• Trust score impact — successful execution increases your agent's trust score

Continuous Compliance

Schedule this skill for recurring execution to maintain continuous compliance posture. Claw GRC monitors for drift and alerts when re-execution is needed.