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]