****************************************************************************************************
Location : Tableau Server
Host     : http://bnbrepository9/#/
Path     : Tableau Samples/Incidents
****************************************************************************************************

-- Query(s)

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]