使用 Google Gemini AI 聊天助手生成 Azure VM 时间线报告

• •可能需要目标 API 的认证凭证
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "dc70be25ab3de91313745487daa53ea6b35f677ae326eae305310e197f986f71",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "214c1831-bd0d-431a-b811-bc29122f5bf1",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1092,
        -780
      ],
      "parameters": {
        "text": "={{ $('When chat message received').item.json.chatInput }}",
        "options": {
          "systemMessage": "=You are an assistant that queries the user's Azure subscription for various Azure virtual machine information.\n\nThrough your tools, you have the ability to query information in Azure such as resource groups and virtual machines.\n\nYour task is to carefully analyze all information about one or more VMs and provide a timeline report to the user including VM state changes, CPU, network, disk activity, etc. The report will be broken down by VM and provide a historical timeline of what happened to a VM during that time.\n\nDo not ask the user questions unless absolutely necessary. He relies on you to make your own decisions.\n\nBy default, the user needs all events starting 90 days ago and newer but can override that with a request.\n\n"
        },
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "1c5bee5e-bbd8-4a0c-bcdf-817540cf5b0f",
      "name": "设置通用变量",
      "type": "n8n-nodes-base.set",
      "position": [
        720,
        -780
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "942ba480-59b8-4a77-a36d-6f198b2b76b4",
              "name": "azure_subscription_id",
              "type": "string",
              "value": "<your azure subscription id here>"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "f2bc18f2-aa40-43b5-8738-0faa64aa5beb",
      "name": "获取虚拟机性能统计",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        1060,
        -500
      ],
      "parameters": {
        "url": "=https://management.azure.com/subscriptions/{{ $json.azure_subscription_id }}/resourceGroups/{azure_resource_group_name}/providers/Microsoft.Compute/virtualMachines/{vm_name}/providers/microsoft.insights/metrics",
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "parametersQuery": {
          "values": [
            {
              "name": "api-version",
              "value": "2018-01-01",
              "valueProvider": "fieldValue"
            },
            {
              "name": "metricnames",
              "value": "Percentage CPU,Network In,Network Out,Disk Read Bytes,Disk Write Bytes",
              "valueProvider": "fieldValue"
            },
            {
              "name": "timespan",
              "value": "{from_time}/{to_time}&interval={interval}",
              "valueProvider": "fieldValue"
            },
            {
              "name": "aggregation",
              "value": "average,maximum",
              "valueProvider": "fieldValue"
            }
          ]
        },
        "toolDescription": "This tool returns performance metrics for a specific virtual machine (VM) in Azure. These metrics come from Azure Monitor and provide time-series data that helps you understand how the VM is performing over time. This includes key metrics like CPU usage (Percentage CPU), disk I/O, network in/out, and available memory, depending on what’s enabled for monitoring.\n\nYou can use query parameters (e.g., metricnames, timespan, interval, aggregation) to control which metrics are returned, over what time period, and at what granularity. The response includes metadata like the unit of measurement, timestamps, and aggregated values (e.g., average, minimum, maximum). This endpoint is commonly used for monitoring, alerting, and troubleshooting VM performance.",
        "nodeCredentialType": "microsoftAzureMonitorOAuth2Api",
        "placeholderDefinitions": {
          "values": [
            {
              "name": "azure_resource_group_name",
              "type": "string"
            },
            {
              "name": "vm_name",
              "type": "string"
            },
            {
              "name": "from_time",
              "type": "string",
              "description": "2025-05-18T20:01:52Z"
            },
            {
              "name": "to_time",
              "type": "string"
            },
            {
              "name": "interval",
              "description": " ISO 8601 duration format Options: PT1M (1min), PT5M (5min), PT15M (15min), PT30M (30min), PT1H (1hr), PT6H (6hr), PT12H (12hr), P1D (1day)"
            }
          ]
        }
      },
      "credentials": {
        "microsoftAzureMonitorOAuth2Api": {
          "id": "jUzjMChitb3DNqcr",
          "name": "Microsoft Azure Monitor"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "58093475-6b4a-44b7-8a94-783de4c662f4",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        500,
        -780
      ],
      "webhookId": "def18753-6744-4666-8062-9cc37938ff3c",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "006eb130-f4e6-4f6b-af5a-0f045eef9426",
      "name": "Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        600,
        -520
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.5-pro-preview-05-06"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "MeEjlKe69mU8qQ3w",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "838e66a3-0b0e-441d-aa02-d9dda32e3ce7",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        820,
        -460
      ],
      "parameters": {
        "sessionKey": "={{ $('When chat message received').item.json.sessionId }}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "30acbfb9-6938-475c-a97c-c8e9f93d8034",
      "name": "获取 Azure 资源组",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        1280,
        -520
      ],
      "parameters": {
        "url": "=https://management.azure.com/subscriptions/{{ $json.azure_subscription_id }}/resourcegroups?api-version=2021-04-01",
        "fields": "name, type",
        "dataField": "value",
        "authentication": "predefinedCredentialType",
        "fieldsToInclude": "selected",
        "toolDescription": "This tool returns a list of resource groups within the specified Azure subscription. A resource group is a container that holds related Azure resources like virtual machines, storage accounts, and databases. This API is useful for inventory, organization, and automation tasks.\n\nEach resource group object in the response includes basic metadata such as the name, location (region), id, and properties.provisioningState. It may also contain tags if they are defined. This endpoint is typically used to get an overview of how resources are grouped and managed across a subscription, and it’s often the first step in workflows that involve resource discovery or filtering by location or naming convention.",
        "optimizeResponse": true,
        "nodeCredentialType": "microsoftAzureMonitorOAuth2Api"
      },
      "credentials": {
        "microsoftAzureMonitorOAuth2Api": {
          "id": "jUzjMChitb3DNqcr",
          "name": "Microsoft Azure Monitor"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "b5cd2f51-dde8-410f-a622-78d87bca9883",
      "name": "获取虚拟机信息",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        1680,
        -680
      ],
      "parameters": {
        "url": "=https://management.azure.com/subscriptions/{{ $json.azure_subscription_id}}/resourceGroups/{azure_resource_group_name}/providers/Microsoft.Compute/virtualMachines",
        "fields": "name,location,tags,properties.hardwareProfile.vmSize",
        "dataField": "value",
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "fieldsToInclude": "selected",
        "parametersQuery": {
          "values": [
            {
              "name": "api-version",
              "value": "2023-03-01",
              "valueProvider": "fieldValue"
            }
          ]
        },
        "toolDescription": "This tool returns a list of all virtual machines (VMs) within a specific resource group under a given subscription. The response is a JSON object that includes metadata for each VM, such as the VM name, location (Azure region), provisioning state, VM size (e.g., Standard_D2s_v3), OS type, and associated resources like network interfaces and storage profiles. Each VM entry may also include tags, availability zone info, and reference links to related resources like disks, NICs, or the OS image used.\n\nThis endpoint does not include live runtime data like power state or metrics (e.g., CPU usage). To get those, you’d need to call separate endpoints such as instance view (/virtualMachines/{vmName}/instanceView). The primary use case for this endpoint is inventory management—enumerating and describing all VMs in a group for configuration or auditing purposes.",
        "optimizeResponse": true,
        "nodeCredentialType": "microsoftAzureMonitorOAuth2Api",
        "placeholderDefinitions": {
          "values": [
            {
              "name": "azure_resource_group_name",
              "type": "string"
            }
          ]
        }
      },
      "credentials": {
        "microsoftAzureMonitorOAuth2Api": {
          "id": "jUzjMChitb3DNqcr",
          "name": "Microsoft Azure Monitor"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "0159f464-6fb5-4ddf-8536-5dc7798bc484",
      "name": "获取虚拟机事件",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        1980,
        -940
      ],
      "parameters": {
        "url": "=https://management.azure.com/subscriptions/{{ $json.azure_subscription_id }}/providers/microsoft.insights/eventtypes/management/values",
        "fields": "category.localizedValue, level, resourceGroupName, operationName.localizedValue, properties.title, properties.details, properties.type, properties.cause,eventTimestamp",
        "dataField": "value",
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "fieldsToInclude": "selected",
        "parametersQuery": {
          "values": [
            {
              "name": "api-version",
              "value": "2015-04-01",
              "valueProvider": "fieldValue"
            },
            {
              "name": "$filter",
              "value": "=eventTimestamp ge '{{ $if('{start_timestamp}', '{start_timestamp}', DateTime.utc().minus({ days: 90 }).startOf('second').toISO()) }}'\n    {{ $if({vm_name}, ` and resourceId eq '/SUBSCRIPTIONS/${$json.azure_subscription_id}/RESOURCEGROUPS/{resource_group_name}/PROVIDERS/MICROSOFT.COMPUTE/VIRTUALMACHINES/{vm_name}`, ` and resourceGroupName eq '{resource_group_name}'`) }}'\n}",
              "valueProvider": "fieldValue"
            }
          ]
        },
        "toolDescription": "This tool returns a list of Azure Activity Log events related to management operations within a specific subscription. These events capture control-plane actions performed on Azure resources, such as creating, updating, or deleting virtual machines, storage accounts, resource groups, role assignments, and more. The log includes data on who initiated the action, when it occurred, what the operation was, its result (e.g. Succeeded, Failed), and which resource was affected.\n\nEach event in the response contains detailed fields such as eventTimestamp, operationName, status, caller, resourceId, and correlationId. This data is commonly used for auditing, compliance, and security monitoring. You can apply filters using query parameters like time range ($filter) to retrieve logs from a specific period. These logs do not contain data-plane information (like reading from a VM or querying a database)—only control-plane actions that change Azure resource state or configuration.",
        "optimizeResponse": true,
        "nodeCredentialType": "microsoftAzureMonitorOAuth2Api",
        "placeholderDefinitions": {
          "values": [
            {
              "name": "resource_group_name",
              "type": "string",
              "description": "Required"
            },
            {
              "name": "vm_name",
              "type": "string",
              "description": "Not required"
            },
            {
              "name": "start_timestamp",
              "type": "string",
              "description": "Not required. Value requires timestamp in ISO 8601 format. Convert for the user if another format is provided."
            }
          ]
        }
      },
      "credentials": {
        "microsoftAzureMonitorOAuth2Api": {
          "id": "jUzjMChitb3DNqcr",
          "name": "Microsoft Azure Monitor"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "560c6ffe-e248-4b26-8752-db8be5e4056d",
      "name": "获取当前日期",
      "type": "@n8n/n8n-nodes-langchain.toolCode",
      "position": [
        1840,
        -780
      ],
      "parameters": {
        "name": "get_current_date",
        "jsCode": "const curDate = new Date().toISOString()\nreturn curDate",
        "description": "调用此工具获取当前日期"
      },
      "typeVersion": 1.1
    },
    {
      "id": "3adb5a18-38fe-4b94-9f5f-6937d51fe90f",
      "name": "获取虚拟机实例视图",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        1500,
        -560
      ],
      "parameters": {
        "url": "=https://management.azure.com/subscriptions/{{ $json.azure_subscription_id }}/resourceGroups/{azure_resource_group_name}/providers/Microsoft.Compute/virtualMachines/{vm_name}/instanceView",
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "parametersQuery": {
          "values": [
            {
              "name": "api-version",
              "value": "2023-09-01",
              "valueProvider": "fieldValue"
            }
          ]
        },
        "toolDescription": "This tool returns the instance view of a specific virtual machine. This provides runtime details that aren’t available through the standard VM configuration API. It includes information such as the VM’s power state (e.g., PowerState/running, stopped), provisioning status, and boot diagnostics.\n\nThe response also contains detailed status codes for each component of the VM, such as the OS disk, data disks, and VM agent. These status entries help diagnose health or startup issues. Unlike the general VM list, this endpoint is focused on the current operational state of the VM and is commonly used in monitoring dashboards or automation scripts that need to respond to VM lifecycle events.",
        "nodeCredentialType": "microsoftAzureMonitorOAuth2Api",
        "placeholderDefinitions": {
          "values": [
            {
              "name": "azure_resource_group_name",
              "type": "string"
            },
            {
              "name": "vm_name",
              "type": "string"
            }
          ]
        }
      },
      "credentials": {
        "microsoftAzureMonitorOAuth2Api": {
          "id": "jUzjMChitb3DNqcr",
          "name": "Microsoft Azure Monitor"
        }
      },
      "typeVersion": 1.1
    }
  ],
  "pinData": {},
  "connections": {
    "AI Agent": {
      "main": [
        []
      ]
    },
    "Get VM Events": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Get Current Date": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get VM Information": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get VM Instance View": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Set Common Variables": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get VM Performance Stats": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Azure Resource Groups": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Set Common Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}