**************************************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Problem Report **************************************************************************************************** -------------------------------------------------- Datasource dev10906 -------------------------------------------------- -- Query(s) SELECT [Problem].[sys_class_name], [Problem].[priority], [Problem].[assignment_group], [Problem].[sla_due], [Problem].[problem_state], [Problem].[state], [Problem].[closed_by], [Problem].[escalation], [Problem].[active], [Problem].[work_notes], [Problem].[assigned_to], [Problem].[time_worked], [Problem].[parent], [Problem].[close_notes], [Problem].[calendar_duration], [Problem].[reassignment_count], [Problem].[approval], [Problem].[urgency], [Problem].[number], [Problem].[approval_history], [Problem].[comments], [Problem].[opened_at], [Problem].[cmdb_ci], [Problem].[business_duration], [Problem].[description], [Problem].[closed_at], [Problem].[company], [Problem].[opened_by], [Problem].[impact], [Problem].[short_description], [Problem].[approval_set], [Problem].[order], [Problem].[knowledge], [Problem].[sys_created_by], [Problem].[due_date], [Problem].[correlation_display], [Problem].[user_input], [Problem].[sys_id], [Problem].[location], [Problem].[sys_created_on], [Problem].[watch_list], [Problem].[sys_updated_by], [Problem].[contact_type], [Problem].[sys_mod_count], [Problem].[activity_due], [Problem].[made_sla], [Problem].[group_list], [Problem].[correlation_id], [Problem].[sys_domain], [Problem].[sys_updated_on], [Problem].[follow_up], [Problem].[rfc], [Problem].[expected_start], [Problem].[work_end], [Problem].[work_start], [Problem].[delivery_task], [Problem].[upon_reject], [Problem].[upon_approval], [Problem].[delivery_plan], [Problem].[work_around], [Problem].[comments_and_work_notes], [Problem].[work_notes_list], [Problem].[related_incidents], [Problem].[known_error], [Problem].[sys_domain_path], [Problem].[additional_assignee_list], [Problem].[business_service] FROM [problem] AS [Problem] SELECT [Group].[roles], [Group].[cost_center], [Group].[name], [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], [Group].[sys_created_on] AS [sys_created_on (Group)], [Group].[manager], [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], [Group].[parent] AS [parent (Group)], [Group].[u_lucha], [Group].[u_lu2], [Group].[u_u] FROM [sys_user_group] AS [Group] 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], [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], [Incident].[subcategory], [Incident].[problem_id], [Incident].[notify], [Incident].[rfc] AS [rfc (Incident)], [Incident].[category], [Incident].[caused_by], [Incident].[severity], [Incident].[calendar_stc], [Incident].[business_stc], [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], [Incident].[resolved_by], [Incident].[resolved_at], [Incident].[comments_and_work_notes] AS [comments_and_work_notes (Incident)], [Incident].[work_notes_list] AS [work_notes_list (Incident)], [Incident].[child_incidents], [Incident].[reopen_count], [Incident].[parent_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]