****************************************************************************************************
Location : Tableau Server
Host     : http://bnbrepository9/#/
Path     : Tableau Samples/Incident-Tracker
****************************************************************************************************

-------------------------------------------------- Datasource Incidents --------------------------------------------------

-- Query(s)

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

SELECT 
	[AssignedTo].[source],
	[AssignedTo].[roles],
	[AssignedTo].[email],
	[AssignedTo].[first_name],
	[AssignedTo].[middle_name],
	[AssignedTo].[last_name],
	[AssignedTo].[user_name],
	[AssignedTo].[company] AS [company (User)],
	[AssignedTo].[calendar_integration],
	[AssignedTo].[title],
	[AssignedTo].[name],
	[AssignedTo].[password_needs_reset],
	[AssignedTo].[photo],
	[AssignedTo].[default_perspective],
	[AssignedTo].[locked_out],
	[AssignedTo].[active] AS [active (User)],
	[AssignedTo].[department],
	[AssignedTo].[user_password],
	[AssignedTo].[accumulated_roles],
	[AssignedTo].[introduction],
	[AssignedTo].[phone],
	[AssignedTo].[home_phone],
	[AssignedTo].[sys_class_name] AS [sys_class_name (User)],
	[AssignedTo].[gender],
	[AssignedTo].[preferred_language],
	[AssignedTo].[country],
	[AssignedTo].[mobile_phone],
	[AssignedTo].[last_login],
	[AssignedTo].[sys_updated_on] AS [sys_updated_on (User)],
	[AssignedTo].[city],
	[AssignedTo].[vip],
	[AssignedTo].[manager],
	[AssignedTo].[time_zone],
	[AssignedTo].[last_login_time],
	[AssignedTo].[building],
	[AssignedTo].[cost_center],
	[AssignedTo].[state] AS [state (User)],
	[AssignedTo].[date_format],
	[AssignedTo].[zip],
	[AssignedTo].[notification],
	[AssignedTo].[failed_attempts],
	[AssignedTo].[location] AS [location (User)],
	[AssignedTo].[sys_id] AS [sys_id (User)],
	[AssignedTo].[time_format],
	[AssignedTo].[street],
	[AssignedTo].[employee_number],
	[AssignedTo].[sys_updated_by] AS [sys_updated_by (User)],
	[AssignedTo].[sys_created_by] AS [sys_created_by (User)],
	[AssignedTo].[sys_created_on] AS [sys_created_on (User)],
	[AssignedTo].[sys_mod_count] AS [sys_mod_count (User)],
	[AssignedTo].[schedule],
	[AssignedTo].[internal_integration_user],
	[AssignedTo].[ldap_server],
	[AssignedTo].[web_service_access_only],
	[AssignedTo].[sys_domain_path] AS [sys_domain_path (User)],
	[AssignedTo].[sys_domain] AS [sys_domain (User)],
	[AssignedTo].[u_u]
FROM
	[sys_user] AS [AssignedTo]

SELECT 
	[ClosedBy].[source] AS [source (User)],
	[ClosedBy].[roles] AS [roles (User)],
	[ClosedBy].[email] AS [email (User)],
	[ClosedBy].[first_name] AS [first_name (User)],
	[ClosedBy].[middle_name] AS [middle_name (User)],
	[ClosedBy].[last_name] AS [last_name (User)],
	[ClosedBy].[user_name] AS [user_name (User)],
	[ClosedBy].[company] AS [company (User) #1],
	[ClosedBy].[calendar_integration] AS [calendar_integration (User)],
	[ClosedBy].[title] AS [title (User)],
	[ClosedBy].[name] AS [name (User)],
	[ClosedBy].[password_needs_reset] AS [password_needs_reset (User)],
	[ClosedBy].[photo] AS [photo (User)],
	[ClosedBy].[default_perspective] AS [default_perspective (User)],
	[ClosedBy].[locked_out] AS [locked_out (User)],
	[ClosedBy].[active] AS [active (User) #1],
	[ClosedBy].[department] AS [department (User)],
	[ClosedBy].[user_password] AS [user_password (User)],
	[ClosedBy].[accumulated_roles] AS [accumulated_roles (User)],
	[ClosedBy].[introduction] AS [introduction (User)],
	[ClosedBy].[phone] AS [phone (User)],
	[ClosedBy].[home_phone] AS [home_phone (User)],
	[ClosedBy].[sys_class_name] AS [sys_class_name (User) #1],
	[ClosedBy].[gender] AS [gender (User)],
	[ClosedBy].[preferred_language] AS [preferred_language (User)],
	[ClosedBy].[country] AS [country (User)],
	[ClosedBy].[mobile_phone] AS [mobile_phone (User)],
	[ClosedBy].[last_login] AS [last_login (User)],
	[ClosedBy].[sys_updated_on] AS [sys_updated_on (User) #1],
	[ClosedBy].[city] AS [city (User)],
	[ClosedBy].[vip] AS [vip (User)],
	[ClosedBy].[manager] AS [manager (User)],
	[ClosedBy].[time_zone] AS [time_zone (User)],
	[ClosedBy].[last_login_time] AS [last_login_time (User)],
	[ClosedBy].[building] AS [building (User)],
	[ClosedBy].[cost_center] AS [cost_center (User)],
	[ClosedBy].[state] AS [state (User) #1],
	[ClosedBy].[date_format] AS [date_format (User)],
	[ClosedBy].[zip] AS [zip (User)],
	[ClosedBy].[notification] AS [notification (User)],
	[ClosedBy].[failed_attempts] AS [failed_attempts (User)],
	[ClosedBy].[location] AS [location (User) #1],
	[ClosedBy].[sys_id] AS [sys_id (User) #1],
	[ClosedBy].[time_format] AS [time_format (User)],
	[ClosedBy].[street] AS [street (User)],
	[ClosedBy].[employee_number] AS [employee_number (User)],
	[ClosedBy].[sys_updated_by] AS [sys_updated_by (User) #1],
	[ClosedBy].[sys_created_by] AS [sys_created_by (User) #1],
	[ClosedBy].[sys_created_on] AS [sys_created_on (User) #1],
	[ClosedBy].[sys_mod_count] AS [sys_mod_count (User) #1],
	[ClosedBy].[schedule] AS [schedule (User)],
	[ClosedBy].[internal_integration_user] AS [internal_integration_user (User)],
	[ClosedBy].[ldap_server] AS [ldap_server (User)],
	[ClosedBy].[web_service_access_only] AS [web_service_access_only (User)],
	[ClosedBy].[sys_domain_path] AS [sys_domain_path (User) #1],
	[ClosedBy].[sys_domain] AS [sys_domain (User) #1],
	[ClosedBy].[u_u] AS [u_u (ClosedBy)]
FROM
	[sys_user] AS [ClosedBy]

SELECT 
	[OpenedBy].[source] AS [source (User) #1],
	[OpenedBy].[roles] AS [roles (User) #1],
	[OpenedBy].[email] AS [email (User) #1],
	[OpenedBy].[first_name] AS [first_name (User) #1],
	[OpenedBy].[middle_name] AS [middle_name (User) #1],
	[OpenedBy].[last_name] AS [last_name (User) #1],
	[OpenedBy].[user_name] AS [user_name (User) #1],
	[OpenedBy].[company] AS [company (User) #2],
	[OpenedBy].[calendar_integration] AS [calendar_integration (User) #1],
	[OpenedBy].[title] AS [title (User) #1],
	[OpenedBy].[name] AS [name (User) #1],
	[OpenedBy].[password_needs_reset] AS [password_needs_reset (User) #1],
	[OpenedBy].[photo] AS [photo (User) #1],
	[OpenedBy].[default_perspective] AS [default_perspective (User) #1],
	[OpenedBy].[locked_out] AS [locked_out (User) #1],
	[OpenedBy].[active] AS [active (User) #2],
	[OpenedBy].[department] AS [department (User) #1],
	[OpenedBy].[user_password] AS [user_password (User) #1],
	[OpenedBy].[accumulated_roles] AS [accumulated_roles (User) #1],
	[OpenedBy].[introduction] AS [introduction (User) #1],
	[OpenedBy].[phone] AS [phone (User) #1],
	[OpenedBy].[home_phone] AS [home_phone (User) #1],
	[OpenedBy].[sys_class_name] AS [sys_class_name (User) #2],
	[OpenedBy].[gender] AS [gender (User) #1],
	[OpenedBy].[preferred_language] AS [preferred_language (User) #1],
	[OpenedBy].[country] AS [country (User) #1],
	[OpenedBy].[mobile_phone] AS [mobile_phone (User) #1],
	[OpenedBy].[last_login] AS [last_login (User) #1],
	[OpenedBy].[sys_updated_on] AS [sys_updated_on (User) #2],
	[OpenedBy].[city] AS [city (User) #1],
	[OpenedBy].[vip] AS [vip (User) #1],
	[OpenedBy].[manager] AS [manager (User) #1],
	[OpenedBy].[time_zone] AS [time_zone (User) #1],
	[OpenedBy].[last_login_time] AS [last_login_time (User) #1],
	[OpenedBy].[building] AS [building (User) #1],
	[OpenedBy].[cost_center] AS [cost_center (User) #1],
	[OpenedBy].[state] AS [state (User) #2],
	[OpenedBy].[date_format] AS [date_format (User) #1],
	[OpenedBy].[zip] AS [zip (User) #1],
	[OpenedBy].[notification] AS [notification (User) #1],
	[OpenedBy].[failed_attempts] AS [failed_attempts (User) #1],
	[OpenedBy].[location] AS [location (User) #2],
	[OpenedBy].[sys_id] AS [sys_id (User) #2],
	[OpenedBy].[time_format] AS [time_format (User) #1],
	[OpenedBy].[street] AS [street (User) #1],
	[OpenedBy].[employee_number] AS [employee_number (User) #1],
	[OpenedBy].[sys_updated_by] AS [sys_updated_by (User) #2],
	[OpenedBy].[sys_created_by] AS [sys_created_by (User) #2],
	[OpenedBy].[sys_created_on] AS [sys_created_on (User) #2],
	[OpenedBy].[sys_mod_count] AS [sys_mod_count (User) #2],
	[OpenedBy].[schedule] AS [schedule (User) #1],
	[OpenedBy].[internal_integration_user] AS [internal_integration_user (User) #1],
	[OpenedBy].[ldap_server] AS [ldap_server (User) #1],
	[OpenedBy].[web_service_access_only] AS [web_service_access_only (User) #1],
	[OpenedBy].[sys_domain_path] AS [sys_domain_path (User) #2],
	[OpenedBy].[sys_domain] AS [sys_domain (User) #2],
	[OpenedBy].[u_u] AS [u_u (OpenedBy)]
FROM
	[sys_user] AS [OpenedBy]

SELECT 
	[Configuration Item].[category] AS [category (Configuration Item)],
	[Configuration Item].[operational_status],
	[Configuration Item].[model_number],
	[Configuration Item].[comments] AS [comments (Configuration Item)],
	[Configuration Item].[fault_count],
	[Configuration Item].[subcategory] AS [subcategory (Configuration Item)],
	[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] AS [schedule (Configuration Item)],
	[Configuration Item].[asset_tag],
	[Configuration Item].[name] AS [name (Configuration Item)],
	[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] AS [cost_center (Configuration Item)],
	[Configuration Item].[assigned_to] AS [assigned_to (Configuration Item)],
	[Configuration Item].[department] AS [department (Configuration Item)],
	[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]

SELECT 
	[Group].[roles] AS [roles (Group)],
	[Group].[cost_center] AS [cost_center (Group)],
	[Group].[name] AS [name (Group)],
	[Group].[sys_created_by] AS [sys_created_by (Group)],
	[Group].[exclude_manager],
	[Group].[default_assignee],
	[Group].[type],
	[Group].[sys_id] AS [sys_id (Group)],
	[Group].[email] AS [email (Group)],
	[Group].[sys_created_on] AS [sys_created_on (Group)],
	[Group].[manager] AS [manager (Group)],
	[Group].[sys_mod_count] AS [sys_mod_count (Group)],
	[Group].[description] AS [description (Group)],
	[Group].[active] AS [active (Group)],
	[Group].[sys_updated_by] AS [sys_updated_by (Group)],
	[Group].[sys_updated_on] AS [sys_updated_on (Group)],
	[Group].[include_members],
	[Group].[source] AS [source (Group)],
	[Group].[parent] AS [parent (Group)],
	[Group].[u_lucha],
	[Group].[u_lu2],
	[Group].[u_u] AS [u_u (Group)]
FROM
	[sys_user_group] AS [Group]