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
[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]
SELECT
[Department].[dept_head],
[Department].[cost_center] AS [cost_center (Department)],
[Department].[sys_updated_on] AS [sys_updated_on (Department)],
[Department].[name] AS [name (Department)],
[Department].[primary_contact],
[Department].[head_count],
[Department].[sys_created_by] AS [sys_created_by (Department)],
[Department].[sys_created_on] AS [sys_created_on (Department)],
[Department].[id],
[Department].[description] AS [description (Department)],
[Department].[sys_id] AS [sys_id (Department)],
[Department].[sys_updated_by] AS [sys_updated_by (Department)],
[Department].[sys_mod_count] AS [sys_mod_count (Department)],
[Department].[company] AS [company (Department)],
[Department].[parent] AS [parent (Department)]
FROM
[cmn_department] AS [Department]
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 (User)]
FROM
[sys_user] AS [OpenedBy]