SECOPS

Quarterly Vendor Access Evidence Pack Builder

On a quarterly schedule, pulls every third-party service account from Postgres, joins it to last-login and grant data.

CategorySecOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerQuarterly schedule fires
  • ActionQuery vendor accounts, owners, and last-login from PostgresPostgreSQLPostgres
  • LogicFlag dormant or unowned accounts as high-risk
  • ActionPublish dated evidence pack to ConfluenceConfluenceConfluence
  • OutputPost sign-off link to security channel in SlackSlack

What it does

Builds the audit-ready evidence package security teams need every quarter to prove who has third-party vendor access and whether it is still warranted. It snapshots the current state of all vendor service accounts and publishes a single, dated Confluence page that an approver can review and sign.

When to use it

Run it at the start of each attestation cycle (e.g. first business day of the quarter) when you need a defensible, point-in-time record for SOC 2, ISO 27001, or internal review. Replaces the manual spreadsheet scramble of screenshotting consoles.

How it works

  1. 1A quarterly schedule fires the workflow.
  2. 2Queries the access-inventory Postgres tables for all vendor accounts, their owners, grant dates, and last-login timestamps.
  3. 3Flags accounts that are dormant (no login in 90+ days) or missing an owner so reviewers see risk first.
  4. 4Formats the joined dataset into an evidence table with a sign-off block.
  5. 5Publishes a dated, versioned page to the attestation space in Confluence and posts the link to the security channel in Slack for the approver to action.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect ConfluenceSpaces, pages, blueprints.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.