dynatrace-workflow

Skill: Dynatrace Workflow Creation and Deployment

Use this skill to create and deploy Dynatrace automation workflows (anomaly detection, alerting, scheduled DQL actions) for DSOA.

File Location

docs/workflows/<workflow-name>/<workflow-name>.yml
docs/workflows/<workflow-name>/readme.md
docs/workflows/<workflow-name>/img/.gitkeep
docs/workflows/README.md   (index — update after every new workflow)

Workflow YAML Format

Export an existing workflow as reference before writing a new one:

dtctl get workflows -A           # list all workflows with IDs
dtctl get workflow <id> -o yaml  # export one as a structural template

Typical workflow YAML structure:

# WORKFLOW: <Human-readable title>
# DESCRIPTION: <One-line description>
# OWNER: DSOA Team
# PLUGINS: <comma-separated plugin names>
# TAGS: snowflake, dsoa, <domain>

id: <uuid>        # omit on first create; add after dtctl returns the ID
title: "DSOA — <Descriptive Name>"
description: |
  <What this workflow does and why>

trigger:
  # Option A — scheduled (cron)
  schedule:
    rule: "0 * * * *"
    timezone: UTC
  # Option B — event-driven
  # event:
  #   eventType: "davis.problem.opened"
  #   filter: "event.category == 'AVAILABILITY'"

tasks:
  step_query:
    name: Query anomaly data
    action: dynatrace.automations:run-javascript
    input:
      script: |
        import { queryExecutionClient } from '@dynatrace-sdk/client-query';

        export default async function () {
          const result = await queryExecutionClient.queryExecute({
            body: {
              query: `
                fetch logs
                | filter db.system == "snowflake"
                | filter dsoa.run.plugin == "<plugin>"
                | summarize count = count(), by: { snowflake.<dim> }
                | filter count > 0
              `,
              requestTimeoutMilliseconds: 30000
            }
          });
          return { anomalyCount: result.result?.records?.length ?? 0, records: result.result?.records };
        }

  step_notify:
    name: Send alert notification
    action: dynatrace.slack.connector:send-message
    conditions:
      - taskId: step_query
        condition: "{{ result('step_query').anomalyCount > 0 }}"
    input:
      channel: "#dsoa-alerts"
      message: |
        :warning: DSOA anomaly detected
        Count: {{ result('step_query').anomalyCount }}
        Details: {{ result('step_query').records | dump }}