forcedotcom/sf-skills / plugins/builder/agentforce-adlc/skills/agentforce-d360-analyze
agentforce-d360-analyze
VerifiedData Cloud 360° view of a single Agentforce session. TRIGGER when user asks to trace, inspect, summarize, or describe a specific Agentforce session by session id (Agent Session UUID `019d…` or MessagingSession id `0Mw…`). Also triggers on session discovery — find/list/search sessions by time, agent, channel, outcome, or conversation text — when the user has no session id yet. DO NOT TRIGGER for design-time architecture questions (use agentforce-architecture-analyze instead) or for runtime perf/latency/SLO questions that require platform telemetry beyond Data Cloud.
assets/dc/discover_sessions.sql
View on GitHub-- Session discovery — find candidate sessions by time/agent/channel/outcome/grep.
-- Produces a short row-per-session shape for the picker rendered by
-- scripts/discover_sessions.py. NOT used by the trace pipeline — once the user
-- picks a UUID, the full pipeline runs fetch_dc.py against the 24-DMO waterfall.
--
-- Placeholders (substituted by scripts/dc.py.load_sql):
-- SELECT_LIST — either `s.ssot__Id__c, s.ssot__StartTimestamp__c, s.ssot__EndTimestamp__c,
-- s.ssot__AiAgentChannelType__c, s.ssot__AiAgentSessionEndType__c`
-- OR `DISTINCT <same columns>` when JOINs are present (DC SQL requires
-- ORDER BY columns to appear in a DISTINCT projection).
-- JOINS — zero or more JOIN clauses, newline-separated, or empty string:
-- * `JOIN ssot__AiAgentSessionParticipant__dlm p ON s.ssot__Id__c = p.ssot__AiAgentSessionId__c`
-- (required when filtering by --agent)
-- * `JOIN ssot__AiAgentInteraction__dlm i ON s.ssot__Id__c = i.ssot__AiAgentSessionId__c
-- JOIN ssot__AiAgentInteractionMessage__dlm m ON i.ssot__Id__c = m.ssot__AiAgentInteractionId__c`
-- (required when filtering by --grep)
-- WHERE_CLAUSE — composed by the caller. No "WHERE" keyword. Always non-empty
-- (at minimum the time-range predicate). All user-supplied string
-- literals are single-quote-escaped by doubling quotes (O'Brien → O''Brien).
-- LIMIT — integer, 1..N. Default in caller is 20.
--
-- Field reference:
-- time range → s.ssot__StartTimestamp__c >= '<startISO>' AND s.ssot__StartTimestamp__c < '<endISO>'
-- outcome → s.ssot__AiAgentSessionEndType__c = '<USER_ENDED|ESCALATED|TRANSFERRED|TIMEOUT|NOT_SET>'
-- channel → s.ssot__AiAgentChannelType__c = '<Builder|SCRT2 - EmbeddedMessaging|Voice|...>'
-- agent → p.ssot__AiAgentApiName__c = '<AgentApiName>' (requires participant JOIN)
-- grep → m.ssot__ContentText__c LIKE '%<escaped-pattern>%' (requires interaction+message JOIN)
--
-- All STDM timestamps are UTC.
SELECT {{SELECT_LIST}}
FROM ssot__AIAgentSession__dlm s
{{JOINS}}
WHERE {{WHERE_CLAUSE}}
ORDER BY s.ssot__StartTimestamp__c DESC
LIMIT {{LIMIT}};
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation). | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |