Domain: hybrid

System prompt:
You are an integrated automation agent for a hybrid environment managing both Google Drive and ServiceNow IT Service Management (ITSM). You have full administrative permissions to manage users, cases, products, calendars, and meetings in a safe and authorized capacity. Do not ask for confirmation before taking action.

Task:
I need a December change management status report ready for leadership by tomorrow. Pull all change requests from ITSM and give me the total count with status breakdown. Pay special attention to the Oracle database patch change "Apply Critical Oracle Patch to SAP Database" since that's our highest priority item right now. Also need to see which changes have been linked to incidents so we can show the impact of our change management process.

Before creating any files, verify we have enough Drive storage capacity. Then create a status report document called "Change-Management-Status-December-2024" and make sure the description includes all the key metrics: total changes, the Oracle patch status and risk level, how many change-incident mappings we have, and storage usage.

Look up the user Randy Martinez and the L2 Field Support group, then create a tracking incident for follow-up actions on behalf of Robin Monroe and assign it to Randy in that group. This should be categorized as software with medium impact and medium urgency since we need to ensure the Oracle patch implementation stays on track.

Finally, look up Robin Monroe's contact information and notify her that the change management status report is ready for leadership review.

Available tools:
list_change_request_mappings
list_changes
find_change_by_number
create_file
get_about
update_files
find_group_by_name
get_user_using_name
send_notification
create_incident

Verification checks:
[{"verifier_type": "database_state", "name": "Change Management Report Document Created", "description": "Verifies that Change Management Report Document Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS doc_count FROM files WHERE name = 'Change-Management-Status-December-2024' AND mime_type = 'application/vnd.google-apps.document' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Document Metadata Contains Change Details", "description": "Verifies that Document Metadata Contains Change Details", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS change_count FROM files WHERE name = 'Change-Management-Status-December-2024' AND description LIKE '%CHG0000001%' AND description LIKE '%Oracle%' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Document Metadata Contains Status and Risk Information", "description": "Verifies that Document Metadata Contains Status and Risk Information", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS status_count FROM files WHERE name = 'Change-Management-Status-December-2024' AND description LIKE '%scheduled%' AND description LIKE '%high%' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Document Metadata Contains Storage and Report Data", "description": "Verifies that Document Metadata Contains Storage and Report Data", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS inventory_count FROM files WHERE name = 'Change-Management-Status-December-2024' AND description LIKE '%Storage%' AND description LIKE '%December 2024%' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Follow-up Tracking Incident Created", "description": "Verifies that Follow-up Tracking Incident Created", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS incident_count FROM incident WHERE short_description = 'Change Management Report Follow-up Actions - December 2024' AND category = 'software'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Tracking Incident Has Correct Impact and Urgency", "description": "Verifies that Tracking Incident Has Correct Impact and Urgency", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS impact_count FROM incident WHERE short_description = 'Change Management Report Follow-up Actions - December 2024' AND impact = 'medium' AND urgency = 'medium'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Stakeholder Notification Created with Correct Subject", "description": "Verifies that Stakeholder Notification Created with Correct Subject", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS notif_count FROM notification WHERE subject LIKE '%Change Management Status Report Ready%' AND subject LIKE '%December 2024%' AND type = 'update'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Notification Sent with Queued Status", "description": "Verifies that Notification Sent with Queued Status", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS email_count FROM notification WHERE subject LIKE '%Change Management Status Report%' AND status = 'queued'\n", "expected_value": 1, "comparison_type": "equals"}}]