Skip to main content

User License Reclamation — Inform

user-license-reclamation-inform

A read-only Tableau Cloud admin workflow that identifies inactive licensed users who are candidates for downgrade to Unlicensed.

Admin Only

This prompt is restricted to Tableau site administrators and requires the ADMIN_TOOLS_ENABLED site setting.

Workflow

The prompt orchestrates three tool calls:

  1. list-users — fetches all users matching the target site roles whose lastLogin is older than the inactivity threshold. The tool paginates the result set; note that if MAX_RESULT_LIMIT is configured, the fetch is capped and the role/lastLogin filter is applied client-side after fetch — some candidates beyond the cap may not appear.
  2. query-admin-insights with kind: "ts-events" — cross-references Access events within the lookback window (capped at 90 days on standard Tableau Cloud) to exclude users who are active despite a stale lastLogin timestamp (e.g., API-only users).
  3. query-admin-insights with kind: "ts-users" — cross-references Tableau Desktop and Prep last-access dates (Tableau Desktop - Last Access Date, Tableau Prep - Last Access Date), joined to candidates by User Email / User Name. A user with a recent non-null Desktop or Prep date is active and is excluded, even if their lastLogin is stale and they have no TS Events Access event. A null date is treated as "no signal" — the user remains a candidate.

The final output is a Markdown table of reclamation candidates with their site role, last login, and days inactive. No user modifications are performed.

Arguments

ArgumentTypeRequiredDescription
inactiveDaysstring (integer)NoMinimum days of inactivity. Defaults to 90.
rolesstringNoComma-separated site roles to target. Defaults to Creator,Explorer.

Configuration

ADMIN_TOOLS_ENABLED=true

# Optional overrides (env vars)
LICENSE_RECLAIM_INACTIVE_DAYS=90
LICENSE_RECLAIM_ROLES=Creator,Explorer

Scopes

This prompt uses existing scopes — no new scope registration is needed:

  • tableau:users:read — for list-users
  • vds:read — for query-admin-insights

Notes

  • TS Events caps at 90 days lookback on Tableau Cloud (365 days with Advanced Management).
  • lastLogin reflects Tableau UI sign-in only — API-only or embedded users may show as inactive.
  • Tableau Desktop / Prep last-access dates (kind: "ts-users") are populated only when the tenant collects Desktop/Prep telemetry. On tenants where this data is unavailable these fields are null for every user — a null date is treated as "no signal", never as activity, so a user active only in Desktop/Prep could still be flagged. The report appends a caveat when Desktop/Prep data appears unavailable.
  • Pair with user-license-reclamation-apply to act on the results.

See also: Environment Variables