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:
list-users— fetches all users matching the target site roles whoselastLoginis older than the inactivity threshold. The tool paginates the result set; note that ifMAX_RESULT_LIMITis configured, the fetch is capped and the role/lastLogin filter is applied client-side after fetch — some candidates beyond the cap may not appear.query-admin-insightswithkind: "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 stalelastLogintimestamp (e.g., API-only users).query-admin-insightswithkind: "ts-users"— cross-references Tableau Desktop and Prep last-access dates (Tableau Desktop - Last Access Date,Tableau Prep - Last Access Date), joined to candidates byUser Email/User Name. A user with a recent non-null Desktop or Prep date is active and is excluded, even if theirlastLoginis stale and they have no TS Events Access event. Anulldate 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
| Argument | Type | Required | Description |
|---|---|---|---|
inactiveDays | string (integer) | No | Minimum days of inactivity. Defaults to 90. |
roles | string | No | Comma-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— forlist-usersvds:read— forquery-admin-insights
Notes
- TS Events caps at 90 days lookback on Tableau Cloud (365 days with Advanced Management).
lastLoginreflects 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 arenullfor every user — anulldate 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-applyto act on the results.
See also: Environment Variables