Find it EZ

Location: Tableau Server
Host: http://bnbrepository9/#/
Path: Tableau Samples/Request Report
Datasource ven01911
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
        [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]
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]
Datasource Request
Query(s)
SELECT
        [Request].[sys_class_name],
        [Request].[priority],
        [Request].[assignment_group],
        [Request].[sla_due],
        [Request].[price],
        [Request].[state],
        [Request].[closed_by],
        [Request].[escalation],
        [Request].[active],
        [Request].[work_notes],
        [Request].[assigned_to],
        [Request].[time_worked],
        [Request].[parent],
        [Request].[close_notes],
        [Request].[calendar_duration],
        [Request].[reassignment_count],
        [Request].[approval],
        [Request].[urgency],
        [Request].[number],
        [Request].[approval_history],
        [Request].[comments],
        [Request].[opened_at],
        [Request].[cmdb_ci],
        [Request].[business_duration],
        [Request].[description],
        [Request].[closed_at],
        [Request].[company],
        [Request].[opened_by],
        [Request].[impact],
        [Request].[short_description],
        [Request].[approval_set],
        [Request].[order],
        [Request].[knowledge],
        [Request].[sys_created_by],
        [Request].[due_date],
        [Request].[correlation_display],
        [Request].[user_input],
        [Request].[sys_id],
        [Request].[location],
        [Request].[sys_created_on],
        [Request].[watch_list],
        [Request].[sys_updated_by],
        [Request].[contact_type],
        [Request].[sys_mod_count],
        [Request].[activity_due],
        [Request].[made_sla],
        [Request].[group_list],
        [Request].[correlation_id],
        [Request].[sys_domain],
        [Request].[sys_updated_on],
        [Request].[follow_up],
        [Request].[expected_start],
        [Request].[work_end],
        [Request].[work_start],
        [Request].[delivery_task],
        [Request].[upon_reject],
        [Request].[upon_approval],
        [Request].[delivery_plan],
        [Request].[request_state],
        [Request].[requested_for],
        [Request].[stage],
        [Request].[requested_date],
        [Request].[calendar_stc],
        [Request].[delivery_address],
        [Request].[special_instructions],
        [Request].[comments_and_work_notes],
        [Request].[work_notes_list],
        [Request].[sys_domain_path],
        [Request].[additional_assignee_list],
        [Request].[business_service]
FROM
        [sc_request] AS [Request]
SELECT
        [Requested Item].[sys_class_name] AS [sys_class_name (Requested Item)],
        [Requested Item].[priority] AS [priority (Requested Item)],
        [Requested Item].[assignment_group] AS [assignment_group (Requested Item)],
        [Requested Item].[quantity],
        [Requested Item].[cat_item],
        [Requested Item].[sla_due] AS [sla_due (Requested Item)],
        [Requested Item].[recurring_price],
        [Requested Item].[recurring_frequency],
        [Requested Item].[sc_catalog],
        [Requested Item].[state] AS [state (Requested Item)],
        [Requested Item].[closed_by] AS [closed_by (Requested Item)],
        [Requested Item].[escalation] AS [escalation (Requested Item)],
        [Requested Item].[active] AS [active (Requested Item)],
        [Requested Item].[work_notes] AS [work_notes (Requested Item)],
        [Requested Item].[assigned_to] AS [assigned_to (Requested Item)],
        [Requested Item].[time_worked] AS [time_worked (Requested Item)],
        [Requested Item].[parent] AS [parent (Requested Item)],
        [Requested Item].[close_notes] AS [close_notes (Requested Item)],
        [Requested Item].[calendar_duration] AS [calendar_duration (Requested Item)],
        [Requested Item].[reassignment_count] AS [reassignment_count (Requested Item)],
        [Requested Item].[approval] AS [approval (Requested Item)],
        [Requested Item].[urgency] AS [urgency (Requested Item)],
        [Requested Item].[number] AS [number (Requested Item)],
        [Requested Item].[approval_history] AS [approval_history (Requested Item)],
        [Requested Item].[comments] AS [comments (Requested Item)],
        [Requested Item].[opened_at] AS [opened_at (Requested Item)],
        [Requested Item].[cmdb_ci] AS [cmdb_ci (Requested Item)],
        [Requested Item].[business_duration] AS [business_duration (Requested Item)],
        [Requested Item].[description] AS [description (Requested Item)],
        [Requested Item].[closed_at] AS [closed_at (Requested Item)],
        [Requested Item].[company] AS [company (Requested Item)],
        [Requested Item].[opened_by] AS [opened_by (Requested Item)],
        [Requested Item].[impact] AS [impact (Requested Item)],
        [Requested Item].[short_description] AS [short_description (Requested Item)],
        [Requested Item].[approval_set] AS [approval_set (Requested Item)],
        [Requested Item].[order] AS [order (Requested Item)],
        [Requested Item].[knowledge] AS [knowledge (Requested Item)],
        [Requested Item].[sys_created_by] AS [sys_created_by (Requested Item)],
        [Requested Item].[due_date] AS [due_date (Requested Item)],
        [Requested Item].[correlation_display] AS [correlation_display (Requested Item)],
        [Requested Item].[user_input] AS [user_input (Requested Item)],
        [Requested Item].[sys_id] AS [sys_id (Requested Item)],
        [Requested Item].[location] AS [location (Requested Item)],
        [Requested Item].[sys_created_on] AS [sys_created_on (Requested Item)],
        [Requested Item].[watch_list] AS [watch_list (Requested Item)],
        [Requested Item].[sys_updated_by] AS [sys_updated_by (Requested Item)],
        [Requested Item].[contact_type] AS [contact_type (Requested Item)],
        [Requested Item].[sys_mod_count] AS [sys_mod_count (Requested Item)],
        [Requested Item].[activity_due] AS [activity_due (Requested Item)],
        [Requested Item].[made_sla] AS [made_sla (Requested Item)],
        [Requested Item].[group_list] AS [group_list (Requested Item)],
        [Requested Item].[correlation_id] AS [correlation_id (Requested Item)],
        [Requested Item].[sys_domain] AS [sys_domain (Requested Item)],
        [Requested Item].[sys_updated_on] AS [sys_updated_on (Requested Item)],
        [Requested Item].[follow_up] AS [follow_up (Requested Item)],
        [Requested Item].[expected_start] AS [expected_start (Requested Item)],
        [Requested Item].[work_end] AS [work_end (Requested Item)],
        [Requested Item].[work_start] AS [work_start (Requested Item)],
        [Requested Item].[delivery_task] AS [delivery_task (Requested Item)],
        [Requested Item].[upon_reject] AS [upon_reject (Requested Item)],
        [Requested Item].[upon_approval] AS [upon_approval (Requested Item)],
        [Requested Item].[delivery_plan] AS [delivery_plan (Requested Item)],
        [Requested Item].[request],
        [Requested Item].[configuration_item],
        [Requested Item].[price] AS [price (Requested Item)],
        [Requested Item].[billable],
        [Requested Item].[stage] AS [stage (Requested Item)],
        [Requested Item].[backordered],
        [Requested Item].[estimated_delivery],
        [Requested Item].[context],
        [Requested Item].[comments_and_work_notes] AS [comments_and_work_notes (Requested Item)],
        [Requested Item].[work_notes_list] AS [work_notes_list (Requested Item)],
        [Requested Item].[sys_domain_path] AS [sys_domain_path (Requested Item)],
        [Requested Item].[order_guide],
        [Requested Item].[additional_assignee_list] AS [additional_assignee_list (Requested Item)],
        [Requested Item].[business_service] AS [business_service (Requested Item)]
FROM
        [sc_req_item] AS [Requested Item]
SELECT
        [Catalog Item].[roles],
        [Catalog Item].[delivery_time],
        [Catalog Item].[template],
        [Catalog Item].[delivery_plan] AS [delivery_plan (Catalog Item)],
        [Catalog Item].[description] AS [description (Catalog Item)],
        [Catalog Item].[model],
        [Catalog Item].[recurring_price] AS [recurring_price (Catalog Item)],
        [Catalog Item].[recurring_frequency] AS [recurring_frequency (Catalog Item)],
        [Catalog Item].[mobile_picture],
        [Catalog Item].[mobile_picture_type],
        [Catalog Item].[mobile_hide_price],
        [Catalog Item].[list_price],
        [Catalog Item].[category],
        [Catalog Item].[sc_catalogs],
        [Catalog Item].[entitlement_script],
        [Catalog Item].[preview],
        [Catalog Item].[sys_updated_by] AS [sys_updated_by (Catalog Item)],
        [Catalog Item].[sys_created_by] AS [sys_created_by (Catalog Item)],
        [Catalog Item].[sys_class_name] AS [sys_class_name (Catalog Item)],
        [Catalog Item].[sys_mod_count] AS [sys_mod_count (Catalog Item)],
        [Catalog Item].[sys_update_name],
        [Catalog Item].[sys_updated_on] AS [sys_updated_on (Catalog Item)],
        [Catalog Item].[sys_created_on] AS [sys_created_on (Catalog Item)],
        [Catalog Item].[sys_name],
        [Catalog Item].[sys_id] AS [sys_id (Catalog Item)],
        [Catalog Item].[sys_replace_on_upgrade],
        [Catalog Item].[sys_package],
        [Catalog Item].[sys_customer_update],
        [Catalog Item].[sys_policy],
        [Catalog Item].[sys_scope],
        [Catalog Item].[meta],
        [Catalog Item].[type],
        [Catalog Item].[price] AS [price (Catalog Item)],
        [Catalog Item].[ignore_price],
        [Catalog Item].[picture],
        [Catalog Item].[icon],
        [Catalog Item].[location] AS [location (Catalog Item)],
        [Catalog Item].[group],
        [Catalog Item].[active] AS [active (Catalog Item)],
        [Catalog Item].[billable] AS [billable (Catalog Item)],
        [Catalog Item].[short_description] AS [short_description (Catalog Item)],
        [Catalog Item].[order] AS [order (Catalog Item)],
        [Catalog Item].[image],
        [Catalog Item].[name],
        [Catalog Item].[no_proceed_checkout],
        [Catalog Item].[no_cart],
        [Catalog Item].[availability],
        [Catalog Item].[visible_bundle],
        [Catalog Item].[no_quantity],
        [Catalog Item].[no_order_now],
        [Catalog Item].[use_sc_layout],
        [Catalog Item].[visible_standalone],
        [Catalog Item].[custom_cart],
        [Catalog Item].[sc_ic_item_staging],
        [Catalog Item].[no_order],
        [Catalog Item].[delivery_plan_script],
        [Catalog Item].[ordered_item_link],
        [Catalog Item].[sc_ic_version],
        [Catalog Item].[visible_guide],
        [Catalog Item].[start_closed],
        [Catalog Item].[no_search],
        [Catalog Item].[omit_price],
        [Catalog Item].[cost],
        [Catalog Item].[vendor],
        [Catalog Item].[workflow]
FROM
        [sc_cat_item] AS [Catalog Item]
SELECT
        [Category].[roles] AS [roles (Category)],
        [Category].[homepage_image],
        [Category].[mobile_hide_description],
        [Category].[mobile_subcategory_render_type],
        [Category].[mobile_picture] AS [mobile_picture (Category)],
        [Category].[sc_catalog] AS [sc_catalog (Category)],
        [Category].[parent] AS [parent (Category)],
        [Category].[description] AS [description (Category)],
        [Category].[sys_updated_by] AS [sys_updated_by (Category)],
        [Category].[sys_created_by] AS [sys_created_by (Category)],
        [Category].[sys_class_name] AS [sys_class_name (Category)],
        [Category].[sys_mod_count] AS [sys_mod_count (Category)],
        [Category].[sys_update_name] AS [sys_update_name (Category)],
        [Category].[sys_updated_on] AS [sys_updated_on (Category)],
        [Category].[sys_created_on] AS [sys_created_on (Category)],
        [Category].[sys_name] AS [sys_name (Category)],
        [Category].[sys_id] AS [sys_id (Category)],
        [Category].[sys_replace_on_upgrade] AS [sys_replace_on_upgrade (Category)],
        [Category].[sys_package] AS [sys_package (Category)],
        [Category].[sys_customer_update] AS [sys_customer_update (Category)],
        [Category].[sys_policy] AS [sys_policy (Category)],
        [Category].[sys_scope] AS [sys_scope (Category)],
        [Category].[title],
        [Category].[homepage_renderer],
        [Category].[icon] AS [icon (Category)],
        [Category].[image] AS [image (Category)],
        [Category].[header_icon],
        [Category].[module],
        [Category].[location] AS [location (Category)],
        [Category].[active] AS [active (Category)],
        [Category].[entitlement_script] AS [entitlement_script (Category)],
        [Category].[order] AS [order (Category)],
        [Category].[show_in_cms]
FROM
        [sc_category] AS [Category]
SELECT
        [Location].[country],
        [Location].[name] AS [name (Location)],
        [Location].[parent] AS [parent (Location)],
        [Location].[lat_long_error],
        [Location].[sys_created_by] AS [sys_created_by (Location)],
        [Location].[fax_phone],
        [Location].[state] AS [state (Location)],
        [Location].[contact],
        [Location].[full_name],
        [Location].[sys_id] AS [sys_id (Location)],
        [Location].[zip],
        [Location].[sys_created_on] AS [sys_created_on (Location)],
        [Location].[sys_mod_count] AS [sys_mod_count (Location)],
        [Location].[stock_room],
        [Location].[latitude],
        [Location].[sys_updated_by] AS [sys_updated_by (Location)],
        [Location].[street],
        [Location].[sys_updated_on] AS [sys_updated_on (Location)],
        [Location].[phone],
        [Location].[company] AS [company (Location)],
        [Location].[longitude],
        [Location].[city],
        [Location].[phone_territory],
        [Location].[time_zone]
FROM
        [cmn_location] AS [Location]
SELECT
        [Group].[roles] AS [roles (Group)],
        [Group].[cost_center],
        [Group].[name] AS [name (Group)],
        [Group].[sys_created_by] AS [sys_created_by (Group)],
        [Group].[exclude_manager],
        [Group].[default_assignee],
        [Group].[type] AS [type (Group)],
        [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]