Ihr Daten-Template für Change Management

// This configuration represents the logical steps to build the report. It uses a SQL-like
// structure to illustrate how data from different sources and conditions are combined
// to form the final event log. You will implement this logic using your reporting tool's interface.

// Activity: Change Request Created
SELECT
  'Change Request Created' AS ActivityName,
  c.Infrastructure_Change_ID AS ChangeRequestID,
  c.Create_Date AS EventStartTime,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate,
  c.Change_Request_Type AS ChangeType,
  c.Status AS Status,
  c.Priority AS Priority,
  c.Risk_Level AS RiskLevel,
  NULL AS ApproverGroup,
  c.ASGRP AS ImplementationTeam
FROM CHG_Infrastructure_Change c

UNION ALL

// Activity: Change Request Submitted
SELECT
  'Change Request Submitted' AS ActivityName,
  c.Infrastructure_Change_ID AS ChangeRequestID,
  c.Submit_Date AS EventStartTime,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate,
  c.Change_Request_Type AS ChangeType,
  c.Status AS Status,
  c.Priority AS Priority,
  c.Risk_Level AS RiskLevel,
  NULL AS ApproverGroup,
  c.ASGRP AS ImplementationTeam
FROM CHG_Infrastructure_Change c
WHERE c.Submit_Date IS NOT NULL

UNION ALL

// Activity: Risk Assessment Performed, Impact Analysis Conducted, etc. (from Tasks)
SELECT
  CASE
    WHEN t.TaskName LIKE '%Risk Assessment%' THEN 'Risk Assessment Performed'
    WHEN t.TaskName LIKE '%Impact Analysis%' THEN 'Impact Analysis Conducted'
    WHEN t.TaskName LIKE '%Implementation Plan%' THEN 'Implementation Plan Developed'
    WHEN t.TaskName LIKE '%Implementation%' THEN 'Change Implemented'
    WHEN t.TaskName LIKE '%Testing%' THEN 'Testing Performed'
    WHEN t.TaskName LIKE '%Post-Implementation Review%' OR t.TaskName LIKE '%PIR%' THEN 'Post-Implementation Review'
    ELSE NULL
  END AS ActivityName,
  t.RootRequestID AS ChangeRequestID,
  t.Actual_End_Date AS EventStartTime,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate,
  c.Change_Request_Type AS ChangeType,
  c.Status AS Status,
  c.Priority AS Priority,
  c.Risk_Level AS RiskLevel,
  NULL AS ApproverGroup,
  c.ASGRP AS ImplementationTeam
FROM TMS_Task t
JOIN CHG_Infrastructure_Change c ON t.RootRequestID = c.Infrastructure_Change_ID
WHERE t.Status = 'Closed' AND t.Actual_End_Date IS NOT NULL AND ActivityName IS NOT NULL

UNION ALL

// Activity: Status-based events (Approved, Rejected, Scheduled, Closed, Cancelled)
SELECT
  CASE
    WHEN a.Status_New = 'Scheduled' AND a.Status_Previous IN ('Request For Authorization', 'Planning In Progress') THEN 'Change Request Approved'
    WHEN a.Status_New = 'Scheduled' THEN 'Change Scheduled'
    WHEN a.Status_New = 'Rejected' THEN 'Change Request Rejected'
    WHEN a.Status_New = 'Completed' AND c.Status_Reason = 'Successful' THEN 'Change Verified' // Approximation for Verified before Closed
    WHEN a.Status_New = 'Closed' THEN 'Change Closed'
    WHEN a.Status_New = 'Cancelled' THEN 'Change Cancelled'
    ELSE NULL
  END AS ActivityName,
  a.Change_Request_ID AS ChangeRequestID,
  a.Status_Change_Date AS EventStartTime, // Placeholder for the actual timestamp field in the audit log
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate,
  c.Change_Request_Type AS ChangeType,
  a.Status_New AS Status,
  c.Priority AS Priority,
  c.Risk_Level AS RiskLevel,
  a.Approver_Group AS ApproverGroup, // Placeholder for the approver group field
  c.ASGRP AS ImplementationTeam
FROM CHG_ChangeAPDetail a // Or a similar audit form
JOIN CHG_Infrastructure_Change c ON a.Change_Request_ID = c.Infrastructure_Change_ID
WHERE ActivityName IS NOT NULL

SELECT
  CIC.Infrastructure_Change_ID AS ChangeRequestID,
  'Change Request Created' AS ActivityName,
  CIC.Submit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  CIC.Status AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_Infrastructure_Change CIC
WHERE CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Request Submitted' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Request For Authorization%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Risk Assessment Performed' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Request For Change%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Impact Analysis Conducted' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Request For Change%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Request Approved' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Scheduled%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Request Rejected' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Rejected%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Implementation Plan Developed' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Planning In Progress%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Scheduled' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Scheduled%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Implemented' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Completed%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Testing Performed' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Completed%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Post-Implementation Review' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Closed%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Verified' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Closed%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Closed' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Closed%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31'

UNION ALL

SELECT
  AUD.Original_Request_ID AS ChangeRequestID,
  'Change Cancelled' AS ActivityName,
  AUD.Audit_Date AS EventStartTime,
  CIC.Change_Type AS ChangeType,
  AUD.Fields_Changed AS Status,
  CIC.Priority AS Priority,
  CIC.Risk_Level AS RiskLevel,
  CIC.ASLOGID AS ApproverGroup,
  CIC.ASGRP AS ImplementationTeam,
  'BMC Helix ITSM' AS SourceSystem,
  GETDATE() AS LastDataUpdate
FROM CHG_ChangeRequest_AuditLogSystem AUD
JOIN CHG_Infrastructure_Change CIC ON AUD.Original_Request_ID = CIC.Infrastructure_Change_ID
WHERE AUD.Fields_Changed LIKE '%Status%Cancelled%'
  AND CIC.Submit_Date BETWEEN '2023-01-01' AND '2023-12-31';

import requests
import json
import csv
from datetime import datetime

class=class="hl-string">"hl-comment"># --- Configuration ---
class=class="hl-string">"hl-comment"># Replace with your BMC Helix environment details
BASE_URL = class="hl-string">"https://[your-helix-domain].bmc.com"
USERNAME = class="hl-string">"[your_api_user]"
PASSWORD = class="hl-string">"[your_api_password]"

class=class="hl-string">"hl-comment"># Set the date range for the extraction (YYYY-MM-DD)
START_DATE = class="hl-string">"2023-01-01"
END_DATE = class="hl-string">"2023-12-31"

class=class="hl-string">"hl-comment"># Output file name
OUTPUT_FILE = class="hl-string">"change_management_event_log.csv"

class=class="hl-string">"hl-comment"># --- End of Configuration ---

def get_auth_token(base_url, username, password):
    class="hl-string">"""Authenticates with the REST API and returns a JWT token."""
    auth_url = fclass="hl-string">"{base_url}/api/jwt/login"
    headers = {class="hl-string">"Content-Type": class="hl-string">"application/x-www-form-urlencoded"}
    data = {class="hl-string">"username": username, class="hl-string">"password": password}
    try:
        response = requests.post(auth_url, headers=headers, data=data)
        response.raise_for_status()
        return response.text
    except requests.exceptions.RequestException as e:
        print(fclass="hl-string">"Error during authentication: {e}")
        return None

def format_timestamp(ts_string):
    class="hl-string">"""Formats Helix timestamp to ISO 8601 format."""
    if not ts_string:
        return None
    class=class="hl-string">"hl-comment"># Helix format is often class="hl-string">'YYYY-MM-DDTHH:MM:SS.sss+0000'
    try:
        dt_obj = datetime.strptime(ts_string.split(class="hl-string">'.')[0], class="hl-string">"%Y-%m-%dT%H:%M:%S")
        return dt_obj.strftime(class="hl-string">"%Y-%m-%d %H:%M:%S")
    except (ValueError, IndexError):
        return ts_string class=class="hl-string">"hl-comment"># Return as-is if format is unexpected

def main():
    class="hl-string">"""Main function to extract, transform, and save change management data."""
    token = get_auth_token(BASE_URL, USERNAME, PASSWORD)
    if not token:
        return

    headers = {
        class="hl-string">"Authorization": fclass="hl-string">"AR-JWT {token}",
        class="hl-string">"Content-Type": class="hl-string">"application/json"
    }

    class=class="hl-string">"hl-comment"># Field IDs for class="hl-string">'CHG:Infrastructure Change' form
    class=class="hl-string">"hl-comment"># Add any other custom fields you need here
    fields = [
        class="hl-string">"Infrastructure Change ID", class=class="hl-string">"hl-comment"># ChangeRequestID
        class="hl-string">"Create Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Change Request Created'
        class="hl-string">"Submit Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Change Request Submitted'
        class="hl-string">"Actual Start Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Change Implemented'
        class="hl-string">"Actual End Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Post-Implementation Review'
        class="hl-string">"Completed Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Change Verified'
        class="hl-string">"Closed Date", class=class="hl-string">"hl-comment"># For class="hl-string">'Change Closed'
        class="hl-string">"Last Modified Date",
        class="hl-string">"Change Request Status",
        class="hl-string">"Change Type",
        class="hl-string">"Priority",
        class="hl-string">"Risk Level",
        class="hl-string">"ASLOGID", class=class="hl-string">"hl-comment"># Approver Login ID (can be used for Approver Group)
        class="hl-string">"ASGRP" class=class="hl-string">"hl-comment"># Assigned Group (can be used for Implementation Team)
    ]

    query = fclass="hl-string">"'Create Date' >= \"{START_DATE}T00:00:00Z\class="hl-string">" AND 'Create Date' <= \"{END_DATE}T23:59:59Z\class="hl-string">""
    
    all_events = []
    offset = 0
    limit = 500
    processed_count = 0

    print(class="hl-string">"Starting data extraction...")

    while True:
        api_url = fclass="hl-string">"{BASE_URL}/api/arsys/v1/entry/CHG:Infrastructure Change?q={query}&fields=values({','.join(fields)})&limit={limit}&offset={offset}"
        try:
            response = requests.get(api_url, headers=headers)
            response.raise_for_status()
            data = response.json()
            entries = data.get(class="hl-string">"entries", [])
        except requests.exceptions.RequestException as e:
            print(fclass="hl-string">"Error fetching data from API: {e}")
            break

        if not entries:
            break class=class="hl-string">"hl-comment"># No more records to fetch
        
        last_data_update = datetime.now().strftime(class="hl-string">"%Y-%m-%d %H:%M:%S")

        for entry in entries:
            values = entry.get(class="hl-string">"values", {})
            change_id = values.get(class="hl-string">"Infrastructure Change ID")
            if not change_id:
                continue

            class=class="hl-string">"hl-comment"># Common attributes for all events of this case
            base_event = {
                class="hl-string">"ChangeRequestID": change_id,
                class="hl-string">"SourceSystem": class="hl-string">"BMC Helix ITSM",
                class="hl-string">"LastDataUpdate": last_data_update,
                class="hl-string">"ChangeType": values.get(class="hl-string">"Change Type"),
                class="hl-string">"Status": values.get(class="hl-string">"Change Request Status"),
                class="hl-string">"Priority": values.get(class="hl-string">"Priority"),
                class="hl-string">"RiskLevel": values.get(class="hl-string">"Risk Level"),
                class="hl-string">"ApproverGroup": values.get(class="hl-string">"ASLOGID"),
                class="hl-string">"ImplementationTeam": values.get(class="hl-string">"ASGRP")
            }
            
            status = values.get(class="hl-string">"Change Request Status")
            last_modified_date = format_timestamp(values.get(class="hl-string">"Last Modified Date"))

            class=class="hl-string">"hl-comment"># 1. Change Request Created
            if values.get(class="hl-string">"Create Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Request Created", class="hl-string">"EventStartTime": format_timestamp(values.get(class="hl-string">"Create Date"))})

            class=class="hl-string">"hl-comment"># 2. Change Request Submitted
            if values.get(class="hl-string">"Submit Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Request Submitted", class="hl-string">"EventStartTime": format_timestamp(values.get(class="hl-string">"Submit Date"))})
            
            class=class="hl-string">"hl-comment"># The following activities are inferred from status and key dates.
            class=class="hl-string">"hl-comment"># This logic assumes a standard process flow. Adjust if your flow differs.

            class=class="hl-string">"hl-comment"># 3. Risk Assessment Performed & 4. Impact Analysis Conducted
            class=class="hl-string">"hl-comment"># Inferred when status moves past class="hl-string">'Request For Authorization'
            if status not in [class="hl-string">'Draft', class="hl-string">'Request For Authorization'] and values.get(class="hl-string">"Submit Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Risk Assessment Performed", class="hl-string">"EventStartTime": last_modified_date})
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Impact Analysis Conducted", class="hl-string">"EventStartTime": last_modified_date})

            class=class="hl-string">"hl-comment"># 5. Change Request Approved
            class=class="hl-string">"hl-comment"># 7. Implementation Plan Developed
            class=class="hl-string">"hl-comment"># 8. Change Scheduled
            if status in [class="hl-string">'Scheduled', class="hl-string">'Implementation In Progress', class="hl-string">'Completed', class="hl-string">'Closed']:
                 class=class="hl-string">"hl-comment"># Use Last Modified Date as a proxy for approval/planning timestamp
                 event_time = last_modified_date
                 all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Request Approved", class="hl-string">"EventStartTime": event_time})
                 all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Implementation Plan Developed", class="hl-string">"EventStartTime": event_time})
                 all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Scheduled", class="hl-string">"EventStartTime": event_time})

            class=class="hl-string">"hl-comment"># 6. Change Request Rejected
            if status == class="hl-string">'Rejected':
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Request Rejected", class="hl-string">"EventStartTime": last_modified_date})

            class=class="hl-string">"hl-comment"># 9. Change Implemented
            if values.get(class="hl-string">"Actual Start Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Implemented", class="hl-string">"EventStartTime": format_timestamp(values.get(class="hl-string">"Actual Start Date"))})

            class=class="hl-string">"hl-comment"># 10. Testing Performed
            class=class="hl-string">"hl-comment"># 11. Post-Implementation Review
            if values.get(class="hl-string">"Actual End Date"):
                event_time = format_timestamp(values.get(class="hl-string">"Actual End Date"))
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Testing Performed", class="hl-string">"EventStartTime": event_time})
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Post-Implementation Review", class="hl-string">"EventStartTime": event_time})
            
            class=class="hl-string">"hl-comment"># 12. Change Verified
            if values.get(class="hl-string">"Completed Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Verified", class="hl-string">"EventStartTime": format_timestamp(values.get(class="hl-string">"Completed Date"))})

            class=class="hl-string">"hl-comment"># 13. Change Closed
            if status == class="hl-string">'Closed' and values.get(class="hl-string">"Closed Date"):
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Closed", class="hl-string">"EventStartTime": format_timestamp(values.get(class="hl-string">"Closed Date"))})

            class=class="hl-string">"hl-comment"># 14. Change Cancelled
            if status == class="hl-string">'Cancelled':
                all_events.append({**base_event, class="hl-string">"ActivityName": class="hl-string">"Change Cancelled", class="hl-string">"EventStartTime": last_modified_date})
        
        processed_count += len(entries)
        print(fclass="hl-string">"Processed {processed_count} change requests...")
        offset += limit

    if not all_events:
        print(class="hl-string">"No events were generated. Check your date range and API permissions.")
        return

    class=class="hl-string">"hl-comment"># Write to CSV
    fieldnames = all_events[0].keys()
    with open(OUTPUT_FILE, class="hl-string">'w', newline=class="hl-string">'', encoding=class="hl-string">'utf-8') as f:
        writer = csv.DictWriter(f, fieldnames=fieldnames)
        writer.writeheader()
        writer.writerows(all_events)

    print(fclass="hl-string">"\nExtraction complete. Event log saved to {OUTPUT_FILE}")

if __name__ == class="hl-string">"__main__":
    main()