Automated Audit Data Collection and Storage in InfluxDB

This n8n workflow automates the process of collecting audit data from various system components including databases, filesystems, instances, and nodes, as well as monitoring active and failed workflows. It then formats and sends this data to an InfluxDB database for analysis and visualization. The workflow begins with a manual trigger, allowing users to run audits on demand. It gathers different types of audit reports and risk assessments, and processes them to generate InfluxDB-compatible data strings. Additionally, the workflow tracks system activity by counting active workflows and failed executions daily, sending summarized metrics to InfluxDB. This setup is useful for continuous monitoring, performance tracking, and auditing in complex system environments, helping administrators to maintain visibility and improve system reliability.