SELECT
        [Task].[sys_class_name],
        [Task].[priority],
        [Task].[assignment_group],
        [Task].[sla_due],
        [Task].[state],
        [Task].[closed_by],
        [Task].[escalation],
        [Task].[active],
        [Task].[work_notes],
        [Task].[assigned_to],
        [Task].[time_worked],
        [Task].[parent],
        [Task].[close_notes],
        [Task].[calendar_duration],
        [Task].[reassignment_count],
        [Task].[approval],
        [Task].[urgency],
        [Task].[number],
        [Task].[approval_history],
        [Task].[comments],
        [Task].[opened_at],
        [Task].[cmdb_ci],
        [Task].[business_duration],
        [Task].[description],
        [Task].[closed_at],
        [Task].[company],
        [Task].[opened_by],
        [Task].[impact],
        [Task].[short_description],
        [Task].[approval_set],
        [Task].[order],
        [Task].[knowledge],
        [Task].[sys_created_by],
        [Task].[due_date],
        [Task].[correlation_display],
        [Task].[user_input],
        [Task].[sys_id],
        [Task].[location],
        [Task].[sys_created_on],
        [Task].[watch_list],
        [Task].[sys_updated_by],
        [Task].[contact_type],
        [Task].[sys_mod_count],
        [Task].[activity_due],
        [Task].[made_sla],
        [Task].[group_list],
        [Task].[correlation_id],
        [Task].[sys_domain],
        [Task].[sys_updated_on],
        [Task].[follow_up],
        [Task].[expected_start],
        [Task].[work_end],
        [Task].[work_start],
        [Task].[delivery_task],
        [Task].[upon_reject],
        [Task].[upon_approval],
        [Task].[delivery_plan],
        [Task].[comments_and_work_notes],
        [Task].[work_notes_list],
        [Task].[sys_domain_path],
        [Task].[additional_assignee_list],
        [Task].[business_service]
FROM
        [task] AS [Task]

SELECT
        [Incident].[sys_class_name] AS [sys_class_name (Incident)],
        [Incident].[priority] AS [priority (Incident)],
        [Incident].[assignment_group] AS [assignment_group (Incident)],
        [Incident].[sla_due] AS [sla_due (Incident)],
        [Incident].[incident_state] AS [incident_state (Incident)],
        [Incident].[state] AS [state (Incident)],
        [Incident].[closed_by] AS [closed_by (Incident)],
        [Incident].[escalation] AS [escalation (Incident)],
        [Incident].[active] AS [active (Incident)],
        [Incident].[work_notes] AS [work_notes (Incident)],
        [Incident].[assigned_to] AS [assigned_to (Incident)],
        [Incident].[time_worked] AS [time_worked (Incident)],
        [Incident].[parent] AS [parent (Incident)],
        [Incident].[close_notes] AS [close_notes (Incident)],
        [Incident].[calendar_duration] AS [calendar_duration (Incident)],
        [Incident].[reassignment_count] AS [reassignment_count (Incident)],
        [Incident].[approval] AS [approval (Incident)],
        [Incident].[urgency] AS [urgency (Incident)],
        [Incident].[number] AS [number (Incident)],
        [Incident].[approval_history] AS [approval_history (Incident)],
        [Incident].[comments] AS [comments (Incident)],
        [Incident].[opened_at] AS [opened_at (Incident)],
        [Incident].[cmdb_ci] AS [cmdb_ci (Incident)],
        [Incident].[business_duration] AS [business_duration (Incident)],
        [Incident].[description] AS [description (Incident)],
        [Incident].[closed_at] AS [closed_at (Incident)],
        [Incident].[company] AS [company (Incident)],
        [Incident].[opened_by] AS [opened_by (Incident)],
        [Incident].[impact] AS [impact (Incident)],
        [Incident].[short_description] AS [short_description (Incident)],
        [Incident].[approval_set] AS [approval_set (Incident)],
        [Incident].[order] AS [order (Incident)],
        [Incident].[knowledge] AS [knowledge (Incident)],
        [Incident].[sys_created_by] AS [sys_created_by (Incident)],
        [Incident].[due_date] AS [due_date (Incident)],
        [Incident].[correlation_display] AS [correlation_display (Incident)],
        [Incident].[user_input] AS [user_input (Incident)],
        [Incident].[sys_id] AS [sys_id (Incident)],
        [Incident].[location] AS [location (Incident)],
        [Incident].[sys_created_on] AS [sys_created_on (Incident)],
        [Incident].[watch_list] AS [watch_list (Incident)],
        [Incident].[sys_updated_by] AS [sys_updated_by (Incident)],
        [Incident].[contact_type] AS [contact_type (Incident)],
        [Incident].[sys_mod_count] AS [sys_mod_count (Incident)],
        [Incident].[activity_due] AS [activity_due (Incident)],
        [Incident].[made_sla] AS [made_sla (Incident)],
        [Incident].[group_list] AS [group_list (Incident)],
        [Incident].[correlation_id] AS [correlation_id (Incident)],
        [Incident].[sys_domain] AS [sys_domain (Incident)],
        [Incident].[sys_updated_on] AS [sys_updated_on (Incident)],
        [Incident].[follow_up] AS [follow_up (Incident)],
        [Incident].[caller_id] AS [caller_id (Incident)],
        [Incident].[subcategory] AS [subcategory (Incident)],
        [Incident].[problem_id] AS [problem_id (Incident)],
        [Incident].[notify] AS [notify (Incident)],
        [Incident].[rfc] AS [rfc (Incident)],
        [Incident].[category] AS [category (Incident)],
        [Incident].[caused_by] AS [caused_by (Incident)],
        [Incident].[severity] AS [severity (Incident)],
        [Incident].[calendar_stc] AS [calendar_stc (Incident)],
        [Incident].[business_stc] AS [business_stc (Incident)],
        [Incident].[expected_start] AS [expected_start (Incident)],
        [Incident].[work_end] AS [work_end (Incident)],
        [Incident].[work_start] AS [work_start (Incident)],
        [Incident].[delivery_task] AS [delivery_task (Incident)],
        [Incident].[upon_reject] AS [upon_reject (Incident)],
        [Incident].[upon_approval] AS [upon_approval (Incident)],
        [Incident].[delivery_plan] AS [delivery_plan (Incident)],
        [Incident].[close_code] AS [close_code (Incident)],
        [Incident].[resolved_by] AS [resolved_by (Incident)],
        [Incident].[resolved_at] AS [resolved_at (Incident)],
        [Incident].[comments_and_work_notes] AS [comments_and_work_notes (Incident)],
        [Incident].[work_notes_list] AS [work_notes_list (Incident)],
        [Incident].[child_incidents] AS [child_incidents (Incident)],
        [Incident].[reopen_count] AS [reopen_count (Incident)],
        [Incident].[parent_incident] AS [parent_incident (Incident)],
        [Incident].[sys_domain_path] AS [sys_domain_path (Incident)],
        [Incident].[additional_assignee_list] AS [additional_assignee_list (Incident)],
        [Incident].[business_service] AS [business_service (Incident)]
FROM
        [incident] AS [Incident]

SELECT
        [Configuration Item].[category],
        [Configuration Item].[operational_status],
        [Configuration Item].[model_number],
        [Configuration Item].[comments] AS [comments (Configuration Item)],
        [Configuration Item].[fault_count],
        [Configuration Item].[subcategory],
        [Configuration Item].[short_description] AS [short_description (Configuration Item)],
        [Configuration Item].[sys_id] AS [sys_id (Configuration Item)],
        [Configuration Item].[attributes],
        [Configuration Item].[last_discovered],
        [Configuration Item].[start_date],
        [Configuration Item].[can_print],
        [Configuration Item].[ip_address],
        [Configuration Item].[discovery_source],
        [Configuration Item].[mac_address],
        [Configuration Item].[change_control],
        [Configuration Item].[correlation_id] AS [correlation_id (Configuration Item)],
        [Configuration Item].[dns_domain],
        [Configuration Item].[fqdn],
        [Configuration Item].[monitor],
        [Configuration Item].[first_discovered],
        [Configuration Item].[maintenance_schedule],
        [Configuration Item].[schedule],
        [Configuration Item].[asset_tag],
        [Configuration Item].[name],
        [Configuration Item].[sys_class_name] AS [sys_class_name (Configuration Item)],
        [Configuration Item].[serial_number],
        [Configuration Item].[purchase_date],
        [Configuration Item].[cost_cc],
        [Configuration Item].[unverified],
        [Configuration Item].[assignment_group] AS [assignment_group (Configuration Item)],
        [Configuration Item].[po_number],
        [Configuration Item].[sys_domain_path] AS [sys_domain_path (Configuration Item)],
        [Configuration Item].[location] AS [location (Configuration Item)],
        [Configuration Item].[managed_by],
        [Configuration Item].[manufacturer],
        [Configuration Item].[due_in],
        [Configuration Item].[sys_created_by] AS [sys_created_by (Configuration Item)],
        [Configuration Item].[cost],
        [Configuration Item].[skip_sync],
        [Configuration Item].[assigned],
        [Configuration Item].[warranty_expiration],
        [Configuration Item].[justification],
        [Configuration Item].[owned_by],
        [Configuration Item].[install_date],
        [Configuration Item].[due],
        [Configuration Item].[sys_updated_on] AS [sys_updated_on (Configuration Item)],
        [Configuration Item].[gl_account],
        [Configuration Item].[asset],
        [Configuration Item].[company] AS [company (Configuration Item)],
        [Configuration Item].[lease_id],
        [Configuration Item].[model_id],
        [Configuration Item].[supported_by],
        [Configuration Item].[delivery_date],
        [Configuration Item].[checked_out],
        [Configuration Item].[sys_updated_by] AS [sys_updated_by (Configuration Item)],
        [Configuration Item].[install_status],
        [Configuration Item].[invoice_number],
        [Configuration Item].[cost_center],
        [Configuration Item].[assigned_to] AS [assigned_to (Configuration Item)],
        [Configuration Item].[department],
        [Configuration Item].[sys_domain] AS [sys_domain (Configuration Item)],
        [Configuration Item].[vendor],
        [Configuration Item].[support_group],
        [Configuration Item].[sys_created_on] AS [sys_created_on (Configuration Item)],
        [Configuration Item].[order_date],
        [Configuration Item].[checked_in],
        [Configuration Item].[sys_mod_count] AS [sys_mod_count (Configuration Item)]
FROM
        [cmdb_ci] AS [Configuration Item]