How to View and Filter Execution History in n8n

1{
2  "name": "Execution Monitor — Daily Report",
3  "nodes": [
4    {
5      "parameters": {
6        "rule": {
7          "interval": [
8            { "field": "hours", "hoursInterval": 24 }
9          ]
10        }
11      },
12      "name": "Daily Schedule",
13      "type": "n8n-nodes-base.scheduleTrigger",
14      "typeVersion": 1.2,
15      "position": [250, 300]
16    },
17    {
18      "parameters": {
19        "url": "={{ $env.N8N_HOST || 'http://localhost:5678' }}/api/v1/executions",
20        "authentication": "genericCredentialType",
21        "genericAuthType": "httpHeaderAuth",
22        "sendQuery": true,
23        "queryParameters": {
24          "parameters": [
25            { "name": "status", "value": "error" },
26            { "name": "limit", "value": "100" }
27          ]
28        }
29      },
30      "name": "Fetch Failed Executions",
31      "type": "n8n-nodes-base.httpRequest",
32      "typeVersion": 4,
33      "position": [450, 300]
34    },
35    {
36      "parameters": {
37        "jsCode": "const executions = $input.all();\nconst summary = {\n  totalFailed: executions.length,\n  byWorkflow: {},\n  reportDate: new Date().toISOString().split('T')[0]\n};\n\nfor (const exec of executions) {\n  const wfName = exec.json.workflowData?.name || 'Unknown';\n  summary.byWorkflow[wfName] = (summary.byWorkflow[wfName] || 0) + 1;\n}\n\nconst topFailures = Object.entries(summary.byWorkflow)\n  .sort((a, b) => b[1] - a[1])\n  .slice(0, 10)\n  .map(([name, count]) => `${name}: ${count} failures`);\n\nreturn [{\n  json: {\n    ...summary,\n    topFailures,\n    message: `Daily Execution Report: ${summary.totalFailed} failed executions`\n  }\n}];"
38      },
39      "name": "Build Report",
40      "type": "n8n-nodes-base.code",
41      "typeVersion": 2,
42      "position": [650, 300]
43    }
44  ],
45  "connections": {
46    "Daily Schedule": {
47      "main": [[{ "node": "Fetch Failed Executions", "type": "main", "index": 0 }]]
48    },
49    "Fetch Failed Executions": {
50      "main": [[{ "node": "Build Report", "type": "main", "index": 0 }]]
51    }
52  }
53}