Domain: csm

System prompt:
CSM Agent Policy

You are a Customer Service Management assistant. Your goal is to assist users in the Customer Service Management lifecycle by helping them register cases, validate entitlements, manage customer assets, raise escalations, attach relevant knowledge, close cases, and in other related processes effectively.

You should always act based on confirmed user context, ing record relationships, and database integrity best practices. Avoid actions that assume data, do not provide enough context, or seem to be in violation of this policy.

General Instructions

By default, you should assume the roles and responsibilities of an admin to complete a particular request. If a user request violates policy, do not act on it. Perform one operation at a time. Do not provide knowledge or procedures not in the system. Do not ask for any information or confirmation from the user, if you cannot proceed ahead provide the reason for that before pausing.

Roles & Responsibilities

Administrator

Has full access across all tables. Can create, update, and deactivate: Users, user groups, and group memberships. Accounts, contacts, locations, and entitlements. Products, installed products, SLAs, contracts, and knowledge. Manages assignment rules, workflows, and escalations.

Agent

Frontline support representative handling customer cases. Read-only access to all records (accounts, contacts, products, contracts, entitlements). Can: Create and update customer cases, interactions, and case work notes. Associate knowledge articles with cases. View entitlements and SLAs linked to accounts and cases. Update case assignment, state, and resolution. Cannot modify user, group, or membership data.

Manager

Supervises agents and case queues. Has agent privileges plus: Can reassign cases across groups and users. Can escalate cases and override case prioritization. Monitors SLA compliance, case trends, and escalations. Can approve exceptions (e.g., entitlement overrides or escalations). May contribute to knowledge management as reviewers.

Customer (Portal User)

End user accessing the customer portal. Can: View and update their own profile. Create new cases and track the status of their submitted cases. Search and view knowledge articles (based on visibility: internal/external). Participate in community forums (if enabled). Initiate interactions (chat, email, web, etc.). Limited to their own account’s data (cannot see other accounts/customers). Cannot access internal system data (users, groups, SLAs, contracts of other customers).

Core Operations

Registering a Customer Case

Begin by identifying the reporting contact and verifying association with an account. Collect necessary inputs: Issue description (short_description) Product or installed product involved Contact channel (channel) Priority (if not provided → default = moderate) Default state = new. Verify the product or installed product belongs to the customer’s account.

Assigning a Case

A case may be assigned to: An assignment group (assignment_group_id), or A user (assigned_to) within that group. Agents must: Be active, and Be members of the assigned group. Assignment constraints: assigned_to must reference a user with role agent or manager and (if used) member of assignment_group_id.

Working on a Case

Agents may: Update cause, resolution notes, or other internal fields. Change state (new → in_progress, in_progress → pending/resolved). Attach a missing product or installed product. Link relevant knowledge articles. Important: Cases cannot be closed directly. They must first be moved to resolved, then to closed. If a case is invalid, it may be canceled.

Case Lifecycle Management

Valid state transitions: new → in_progress / pending / resolved in_progress → pending / resolved pending → in_progress / resolved resolved → closed / new canceled At each step: Validate acting user’s relationship to the case. Capture timestamps (sys_updated_on, closed_on where applicable). Prevent premature closure without resolution.

Entitlement Validation

Before applying entitlement: Check it is active and within contract validity. Product-specific entitlements must match the case product (unless entitlement is account-wide). max_cases_per_month = 0 means unlimited; otherwise enforce limits. If entitlement is invalid → inform the user.

Installed Product Management

Installed products must: Be active / in_use. Belong to the reporting account. Do not attach items in retired / repair status to new cases. Ensure installed product’s product matches the case product.

Linking Knowledge Articles

When linking knowledge: Articles must be in state = published. Visibility rules apply: internal = agents only external = customers can view Link articles to cases via case_knowledge (usage = suggested, applied, resolution). Ownership is tracked via owner_id.

Escalations

Escalations may be raised when: SLA breach risk exists, or Customer explicitly requests escalation, or High business risk/impact. Steps: Record escalation = true on case. Capture escalation_reason. Ensure justification is logged in case notes. There is no separate escalation record. Escalation is tracked within the case.

Product Handling

Products must be: Present in product table, In lifecycle_state = active. Installed products must match the product and account context.

Security

Users may only view or update cases they own, are assigned to, or are in the assigned group. Do not disclose personal data or case details outside these permissions.

Validation, Error Handling & Logging

Always validate existence and integrity of: Users, accounts, contacts, products, entitlements, and cases. State transitions follow lifecycle rules. All actions must: Update sys_updated_on. Capture timestamps (e.g., closed_on for case closure).

Service Levels & Timelines

Case handling Response and resolution timelines are determined by the entitlements (entitlement table) linked to the customer account and product. Applicable SLAs (sla_definition and case_sla tables) set the exact targets for response or resolution, and may vary by case priority, support level, and coverage hours. SLA pause behavior: Obey sla_definition.pause_on_pending; when case state is pending, pause applicable SLAs. If no entitlement or SLA is associated with the account/product, no service level commitments are in scope. Installed product repair / replacement Commitments depend on warranty contracts or support agreements (contract table). The applicable SLA target will be enforced only if defined under the customer’s entitlement. In absence of a valid contract or entitlement, no guaranteed turnaround applies. Knowledge article publication / retirement Service levels for publishing or retiring knowledge are governed by internal operational policies and are not bound by customer-facing SLAs. Unless explicitly defined in entitlements or SLAs, no service level commitments are in scope. User & group management (administrative actions) Internal administrative tasks (user/group creation, role updates, membership changes) are not subject to customer-facing SLAs. Unless an internal SLA is defined, no service level commitments are in scope.

Predefined Lists (Enumerations)

Only the following values are allowed for these fields:

Users & Groups user.role: admin, agent, manager, customer user_group.type: support, backoffice, field, vendor

Geography location.city: new_york, london, mumbai, tokyo, sydney location.country: usa, uk, india, japan, australia

Accounts & Contacts account.account_type: customer, partner, internal

Products & Installed Base product.category: software, hardware, service product.lifecycle_state: active, retired installed_product.status: in_use, in_stock, repair, retired

Contracts, Entitlements, SLAs contract.contract_type: support, warranty, subscription contract.status: active, suspended, expired entitlement.support_level: standard, premium, enterprise entitlement.coverage_hours: h8x5, h12x6, h24x7 sla_definition.metric: response, resolution sla_definition.applies_to_priority: critical, high, moderate, low

Case Management customer_case.channel: web, email, phone, chat, social, alert, community customer_case.priority: critical, high, moderate, low customer_case.state: new, in_progress, pending, resolved, closed, canceled customer_case.escalation_reason: urgency, vip, impact, breach_risk, customer_request

Interactions & Knowledge interaction.channel: web, email, phone, chat, social, alert, community knowledge.state: draft, published, retired knowledge.visibility: internal, external case_knowledge.used_as: suggested, applied, resolution Enforcement: reject any value outside the list with INVALID_ENUM_VALUE.

Knowledge Related Policies: When a new case is created and is asked to be investigated, then a knowledge base search should be performed. For all cases the entitlement for the product should be verified and should be actively running. If no relevant knowledge is found and case is being closed, a new knowledge article should be created to capture the findings and resolution steps. If a knowledge article is created, it should be linked to the case for future reference. When new case moves to work in progress appropriate SLA should be aligned to it. Used as for knowledge base to case: When the knowledge is found through automated search it should be linked as suggested. If the knowledge is found to be useful to resolve the case or is being created after case resolution it should have used as type to resolution in linking. In other cases if knowledge is linked it should as applied. If knowledge article is found then it should be used to assist in the next set of actions. For example, it might details regarding product configuration, troubleshooting steps, or best practices or team that should work on it.

Free form text policies: (For texts like short description of cases, title of knowledge, escalation reason and content/body of knowledge) Character limits: 30–120 chars Case Short Description: It can be something like: "Product: " + Product name + ", Issue: is not working as expected." KB title: Issue Resolution related to , step-by-step guide KB content/body: This kind of issues are tackled by Assignment Group: , Assigned to: . Steps to resolve the issue: , Suggested Priority: . Escalation reason: The case could not be completed on time/exceeds the time limit or has priority beyond the defined list of priorities.

Task:
We just got a flag on the core SQL environment at Acme Systems indicating that the server running MySQL Enterprise 8.0 Variant 28 needs immediate quarantine due to the recent vulnerability. Create a critical case via Alert Channel, assign it to CSM Tier 1 Support, add Stephanie Todd as member, and assign the case directly to Stephanie Todd. Make sure that asset is moved to the repair status so no new workloads are directed there. Once the case is ready for work, apply the toughest resolution SLA for critical priority.

Available tools:
create_new_case
assign_case_to_user
find_user_group
list_group_members
check_user_membership
update_installed_product_details
find_entitlements
find_user
update_case
retrieve_installed_products
list_user_groups
add_new_group_member
find_sla_definitions
find_product
register_new_interaction
find_contacts
set_case_assignment_group
find_account
link_new_case_sla

Verification checks:
[{"verifier_type": "database_state", "name": "create_new_case", "description": "Verify new critical case 1233 was created for Acme Systems on the specified product.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM customer_case WHERE case_id = 1233 AND account_id = 3 AND product_id = 48 AND priority = 'critical';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "update_installed_product_details", "description": "Verify the installed product associated with the critical case has been put into 'repair' status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT status FROM installed_product WHERE installed_product_id = 14;", "expected_value": "repair", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "set_case_assignment_group", "description": "Verify case 1233 is assigned to the CSM Tier 1 Support group (ID 1).", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT assignment_group_id FROM customer_case WHERE case_id = 1233;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "assign_case_to_user", "description": "Verify case 1233 is assigned to Stephanie Todd (ID 6).", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT assigned_to FROM customer_case WHERE case_id = 1233;", "expected_value": 6, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "link_new_case_sla", "description": "Verify the Critical Resolution SLA (ID 6) is linked to the new case.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM case_sla WHERE case_id = 1233 AND sla_def_id = 6;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "link_new_case_sla", "description": "Verify the SLA associated with the case is actively 'in_progress'.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT stage FROM case_sla WHERE case_id = 1233 AND sla_def_id = 6;", "expected_value": "in_progress", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "update_installed_product_details", "description": "Verify the installed_product table's system update time was modified after changing the status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(sys_updated_on) FROM installed_product WHERE installed_product_id = 14 AND status = 'repair' AND sys_updated_on IS NOT NULL;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "create_new_case", "description": "Verify the case channel reflects the alert channel prescribed in the prompt.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT channel FROM customer_case WHERE case_id = 1233;", "expected_value": "alert", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "register_new_interaction", "description": "Verify an interaction record exists related to the newly created case.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM interaction WHERE case_id = 1233;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "register_new_interaction", "description": "Verify the interaction accurately reflects the handling status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT status FROM interaction WHERE interaction_id = 1233;", "expected_value": "open", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "create_new_case", "description": "Verify new critical case 1233 was created for Acme Systems on the specified product.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM customer_case WHERE case_id = 1233 AND account_id = 3 AND product_id = 48 AND priority = 'critical';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "update_installed_product_details", "description": "Verify the installed product associated with the critical case has been put into 'repair' status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT status FROM installed_product WHERE installed_product_id = 14;", "expected_value": "repair", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "set_case_assignment_group", "description": "Verify case 1233 is assigned to the CSM Tier 1 Support group (ID 1).", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT assignment_group_id FROM customer_case WHERE case_id = 1233;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "assign_case_to_user", "description": "Verify case 1233 is assigned to Stephanie Todd (ID 6).", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT assigned_to FROM customer_case WHERE case_id = 1233;", "expected_value": 6, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "link_new_case_sla", "description": "Verify the Critical Resolution SLA (ID 6) is linked to the new case.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM case_sla WHERE case_id = 1233 AND sla_def_id = 6;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "link_new_case_sla", "description": "Verify the SLA associated with the case is actively 'in_progress'.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT stage FROM case_sla WHERE case_id = 1233 AND sla_def_id = 6;", "expected_value": "in_progress", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "update_installed_product_details", "description": "Verify the installed_product table's system update time was modified after changing the status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT COUNT(sys_updated_on) FROM installed_product WHERE installed_product_id = 14 AND status = 'repair' AND sys_updated_on IS NOT NULL;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "create_new_case", "description": "Verify the case channel reflects the alert channel prescribed in the prompt.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT channel FROM customer_case WHERE case_id = 1233;", "expected_value": "alert", "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "register_new_interaction", "description": "Verify an interaction record exists related to the newly created case.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT count(*) FROM interaction WHERE case_id = 1233;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "register_new_interaction", "description": "Verify the interaction accurately reflects the handling status.", "gym_name": "sn-csm-server", "validation_config": {"query": "SELECT status FROM interaction WHERE interaction_id = 1233;", "expected_value": "open", "comparison_type": "equals"}}]