DEVOPS

Weekly base-image EOL posture snapshot to BigQuery

Compiles a weekly inventory of every base image in use with its support status and days-to-EOL, writes the snapshot to BigQuery for trend tracking.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule starts the posture snapshot
  • ActionEnumerate base images across tracked GitHub reposGitHubGitHub
  • ActionResolve EOL dates and compute days remaining over HTTPHTTP webhook
  • LogicBucket images into supported, near-EOL, and EOL
  • ActionAppend the timestamped snapshot to BigQueryGoogle BigQueryBigQuery
  • OutputRender a leadership trend summary in NotionNotionNotion

What it does

This workflow turns base-image EOL data into a tracked metric. Each week it inventories every base image across your repos, computes days remaining until EOL, and appends a timestamped snapshot to a BigQuery table so you can chart whether your fleet's support posture is improving or decaying over time.

When to use it

Use this when you need to report supply-chain hygiene to leadership or prove progress against a remediation goal. The historical snapshots let you show the count of EOL and near-EOL images trending down quarter over quarter.

How it works

  1. 1A weekly schedule starts the snapshot.
  2. 2The workflow enumerates base images across the tracked GitHub repos.
  3. 3It resolves each image's EOL date over HTTP and computes days remaining.
  4. 4A logic step buckets images into supported, near-EOL, and EOL categories.
  5. 5It appends the full timestamped snapshot to a BigQuery table.
  6. 6It renders a leadership summary with the week's bucket counts and trend to a Notion page.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GitHubRepos, issues, pull requests, actions.
  2. 2
    Connect HTTP webhookTrigger any URL on agent actions.
  3. 3
    Connect BigQueryDatasets, queries, schemas.
  4. 4
    Connect NotionPages, databases, comments.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.