I am new to ServiceNow but getting quickly up to speed. I am trying to go back in time and find out what incidents were not resolved at the end of each month but having a hard time.
This is what I am using:
Type: Pie chart Bar chart List Pivot Table ------ Box chart Calendar Control chart Histogram Horizontal bar Line chart Pareto chart Trend chart Trendbox chart Vertical bar Table: Accessory [cmdb_ci_acc] Action [ecc_action] Active Batch Jobs [u_active_batch_jobs] Active Transactions [v_transaction] Add Field [v_ws_field_creator] Additional Applications [u_additional_applications] Adobe Software License [ast_license_adobe] Agreement [sla] Agreement Requests [sla_request] AIX Server [cmdb_ci_aix_server] App Dev Inc Audit [u_view_inc_audit_appdev1] Application [cmdb_ci_appl] Application Model [cmdb_application_product_model] Application PID [cmdb_pid] Application Server [cmdb_ci_app_server] Application Software [cmdb_ci_application_software] Appointment [itil_appointment] Approval [sysapproval_approver] Approval Steps [process_step_approval] Archive Distribution List/Security Groups [ar_u_active_directory_groups] Archive Incident [ar_incident] Archive Incident by Assigned To [ar_u_incident_by_assigned_to] Archive Incident by Plan [ar_u_incident_by_plan] Archive IT System Operations [ar_u_it_system_operations] Archive Missing Extract [ar_u_missing_extract] Archive NHP Incident SLA [ar_u_nhp_incident_sla] Archive Service Desk [ar_u_service_desk] Archive U view inc audit ebira [ar_u_view_inc_audit_ebira] Archive u_view_inc_dept [ar_u_u_view_inc_dept] Asset [alm_asset] Asset Covered [clm_m2m_contract_asset] Asset Covered [clm_m2m_rate_card_asset] Asset Entitlement [alm_entitlement_asset] Atlas Access Request [u_atlas_access] Attachment Extractor [attachment_extractor] Automatic Transfer Switch [cmdb_ci_ats_power_eq] Banner Step [expert_banner_step] BEA Weblogic [cmdb_ci_app_server_weblogic] BSM Indicator [bsm_indicator] BSM Map Actions [bsm_action] BSM Map View [map_view] BSM Related Item [bsm_related_item] BSM Saved Map [bsm_graph] Budget [u_budget] Build Tool [u_build_tool] Building [cmn_building] Buildings [cmdb_ci_building_facility] Business Justifications [u_business_justifications_marx] Business Process [cmdb_ci_business_process] Business Service [cmdb_ci_service] Capital Expenditure HW [u_capital_expenditure_hw] Catalog Item [sc_cat_item] Catalog Request Item Metric [sc_req_item_metric] Catalog Request Item SLA [sc_req_item_sla] Catalog Request Metric [sc_request_metric] Catalog Request SLA [sc_request_sla] Catalog Task [sc_task] Catalog Task Metric [sc_task_metric] Catalog Task SLA [sc_task_sla] Category [sc_category] Chain Summary [ts_chain_summary] Change [u_change] Change Metric [change_request_metric] Change Phase [change_phase] Change Request [change_request] Change Request SLA [change_request_sla] Change Task [change_task] Change Task Metric [change_task_metric] Change Task SLA [change_task_sla] Change Task Time Worked [change_task_time_worked] Child Script(s) [u_child_script_s_] CI Alias [cmdb_alias] CI CPU Metrics [cmdb_metric_cpu] CI DB Connection Metrics [cmdb_metric_db_connections] CI Filters [map_filters] CI Garbage Collection Metrics [cmdb_metric_garbage_collection] CI Identifier [ci_identifier] CI Java Metrics [cmdb_metric_java] CI Java PermGen Metrics [cmdb_metric_java_permgen] CI Load Metrics [cmdb_metric_load] CI Log Count [cmdb_metric_logs] CI Memory Metrics [cmdb_metric_memory] CI Metric [cmdb_metric] CI MySQL Metrics [cmdb_metric_mysql_statements] CI Oracle Metrics [cmdb_metric_oracle] CI Relationship [cmdb_rel_ci] CI Relationship Rollup [cmdb_rel_rollup] CI Relationship Type [cmdb_rel_type] CI Replication Metrics [cmdb_metric_replication] CI Semaphore Metrics [cmdb_metric_semaphores] CI Semaphore Queue Metrics [cmdb_metric_semaphore_waiters] CI Service-now Metrics [cmdb_metric_service_now] CI Session Queue Metrics [cmdb_metric_session_waiters] CI Transaction Metrics [cmdb_metric_transactions] CI's affected [release_cis] CI's affected [task_ci] CI/Group Relationship Type [cmdb_rel_group_type] CI/User Relationship Type [cmdb_rel_user_type] CIM Probe [discovery_probes_cim] CIM Query [discovery_probes_cim_query] CIM Server [cmdb_ci_cim_server] Circuit [cmdb_ci_circuit] Classification [discovery_classy] Classification Criteria [discovery_class_criteria] Clone Log [clone_log] Clone Security Token [clone_token] Cluster [cmdb_ci_cluster] Cluster Node [cmdb_ci_cluster_node] Cluster Node Resource [cmdb_ci_cluster_node_resource] Cluster Resource [cmdb_ci_cluster_resource] Cluster Virtual IP [cmdb_ci_cluster_vip] CMDB Baseline [cmdb_baseline] CMDB baseline entry [cmdb_baseline_entry] CMDB Categories [cmdb_categories] CMDB Discovery [cmdb_discovery] CMDB lease [cmdb_lease] CMDB View [cmdb_view] CMDB View Instance [cmdb_view_instance] Command [u_command] Communication Device [cmdb_ci_comm] Company [core_company] Computer [cmdb_ci_computer] Computer Peripheral [cmdb_ci_peripheral] Computer Room [cmdb_ci_computer_room] Computer Room AC [cmdb_ci_crac] Condition [clm_condition_checker] Condition [cmn_condition_checker] Condition Checks [clm_condition_check] Condition Checks [cmn_condition_check] Condition Default [wf_condition_default] Config Order [u_config_order] Configuration [ecc_queue_config] Configuration File(s) [u_configuration_file_s_] Configuration Item [cmdb_ci] Connectivity Test [ha_connectivity_test] Connectivity Test Result [ha_connectivity_test_result] Consumable [alm_consumable] Consumable Model [cmdb_consumable_product_model] Contained Skills [cmn_skill_contains] Content Block [content_block] Content Configuration [content_config] Content Link [content_link] Content Theme [content_theme] Content Theme CSS [content_theme_css] Content Type [content_type] Contract [ast_contract] Contract History [clm_contract_history] Cost Center [cmn_cost_center] Cost centers affected [task_cost_center] CR Categories [u_cr_categories] Create Field [v_field_creator] Create Table [v_table_creator] Create Web Service [v_ws_creator] Credential Affinity [dscy_credentials_affinity] Crystal Parameters [u_crystal_parameters] Currency [fx_currency] Currency Instance [fx_currency_instance] Currency Test [fx_currency_test] Customer Uploads [v_customer_uploads] Data Center [cmdb_ci_datacenter] Data Center Zone [cmdb_ci_zone] Data Lookup Definitions [dl_definition] Database [cmdb_ci_database] Database Access Request [u_database_access_request] Database Catalog [cmdb_ci_db_catalog] Database Check [ha_db_check] Database Check Table Include [ha_db_check_type_include] Database Check Type [ha_db_check_type] Database Clone [clone] Database Clone [ha_clone] Database Instance [cmdb_ci_db_instance] Database Script Runs [u_db_script_run] Day(s) of the Week [u_day_s__of_the_week] DB2 Catalog [cmdb_ci_db_db2_catalog] DB2 Instance [cmdb_ci_db_db2_instance] Default Stockroom [alm_user_stockroom] Defect Deployment Forms [u_defect_deployment_forms] Defect tracking [u_defect_tracking] Delegate [sys_user_delegate] Department [cmn_department] Deployment Form [u_deployment_form] Depreciation [cmdb_depreciation] Desktop Software [cmdb_ci_desktop_software] Detail Pages [content_type_detail] Detailed Content [content_block_detail] Device [discovery_device_history] Diagnostics Test [diagnostics_test] Diagrammer Actions [diagrammer_action] Direct Current Plant Battery Bank [cmdb_ci_dc_plant_battery_pwr] Direct Current Plant Equipment [cmdb_ci_dc_plant_eq_power_eq] Direct Relationships [cmdb_related] Directory Server [cmdb_ci_directory_server] Discovery Device History Log [discovery_device_history_log] Discovery Port Probe [discovery_port_probe] Discovery Status [discovery_status] Disk [cmdb_ci_disk] Distribution List/Security Groups [u_active_directory_groups] DNS Name [cmdb_ci_dns_name] Domino [cmdb_ci_app_server_domino] DSL [dsl] DTS Package/Crystal Report [u_dts_package_crystal_report] Dynamic category [sc_category_top_n] Dynamic Content [content_block_programmatic] EC2 Virtual Machine Instance [cmdb_ci_ec2_instance] ECC Agent Counter Metric [ecc_agent_counter_metric] ECC Agent Memory Metric [ecc_agent_memory_metric] ECC Agent Metric [ecc_agent_metric] ECC Agent RGR Metric [ecc_agent_rgr_metric] ECC Agent Scalar Metric [ecc_agent_scalar_metric] Edit Field [v_field_editor] Edit Table [v_table_editor] Edit Web Service [v_ws_editor] Edit Web Service Field [v_ws_field_editor] Editor Macro [syntax_editor_macro] Email Server [cmdb_ci_email_server] Environment [cmdb_ci_environment] Environment [cmdb_environment_to_ci] EPOCs [u_epocs] Errors Logged [cmdb_metric_errors] esar [u_esar] Estimate [u_estimate] ESX Resource Pool [cmdb_ci_esx_resource_pool] ESX Server [cmdb_ci_esx_server] Event [ecc_event] Event Handler [ecc_event_handler] Events Logged [cmdb_metric_event_logs] Events Processed [cmdb_metric_events_processed] Exchange Rate [fx_rate] Execution Plan [sc_cat_item_delivery_plan] Exit Interface Routing Rule [dscy_route_interface] Expense [u_capital_expenditure] Expense Line [fm_expense_line] Extracts [u_cmdb_ci_extracts] F5 BIG-IP [cmdb_ci_lb_bigip] Facets Development [u_facets_development] Facets Production [u_facets_production] Facets Reporting [u_facets_reporting] Facets Testing [u_facets_testing] Facilities [facilities] Facility Hardware [cmdb_ci_facility_hardware] faucet [u_faucet] Feature [release_feature] Feature Task [release_task] File Server/Department Access [u_file_server_department_acces] File System [cmdb_ci_file_system] Fixed asset to asset [m2m_fixed_asset_to_asset] Fixed Assets [alm_fixed_assets] Flash Movie [content_block_flash] Flatten table [hierarchy_clone] Format (FMT) [u_format__fmt_] FTP Server [cmdb_ci_ftp_server] Fuel Tank [cmdb_ci_fuel_tank] Generic Software License [ast_license_generic] Global [global] Global Searches [ts_query] Graph Line [jrobin_graph_line] Group [cmdb_ci_group] Group [sys_user_group] Group approval [sysapproval_group] Group Member [cmn_notif_grmember] Group Member [sys_user_grmember] Group Relationship [cmdb_rel_group] Group Role [sys_group_has_role] Groups affected [task_group] Hardware [alm_hardware] Hardware [cmdb_ci_hardware] Hardware Catalog [pc_hardware_cat_item] Hardware Model [cmdb_hardware_product_model] Header [content_block_header] Help Context [cmn_context_help] Help the Help Desk Status [discovery_status_hthd] HPUX Server [cmdb_ci_hpux_server] Human Resources [hr] HVAC Equipment [cmdb_ci_hvac] Hyper-V Cluster [cmdb_ci_hyper_v_cluster] Hyper-V Object [cmdb_ci_hyper_v_object] Hyper-V Resource Pool [cmdb_ci_hyper_v_resource_pool] Hyper-V Resource Pool Component [cmdb_ci_hyper_v_rpool_comp] Hyper-V Server [cmdb_ci_hyper_v_server] Hyper-V Virtual Machine Instance [cmdb_ci_hyper_v_instance] Hyper-V Virtual Network [cmdb_ci_hyper_v_network] IANA Enterprise Number [iana_enterprise_numbers] IBM Mainframe [cmdb_ci_mainframe] IBM Mainframe LPAR [cmdb_ci_mainframe_lpar] IBM Websphere [cmdb_ci_app_server_websphere] IFrames [content_block_iframe] IMAC [change_request_imac] Images [db_image] Impacted Services [task_cmdb_ci_service] Incident [incident] Incident by Assigned To [u_incident_by_assigned_to] Incident by Assigned To [u_incident_by_assigned_to] Incident by Plan [u_incident_by_plan] Incident by Plan [u_view_incident_by_plan] Incident fact table [incident_fact_table] Incident Metric [incident_metric] Incident SLA [incident_sla] Incident Time Worked [incident_time_worked] Infrastructure Service [cmdb_ci_infra_service] Infrastructure Software [cmdb_ci_inf_software] Insert Scripts (DML) [u_insert_scripts__dml_] Invalid Serial Number [dscy_invalid_serial] IP Address [cmdb_ci_ip_address] IP Address Access Control [ip_access] IP Address to DNS Name [cmdb_ip_address_dns_name] IP Device [cmdb_ci_ip_device] IP Network [cmdb_ci_ip_network] IP Network [dscy_ip_net] IP Phone [cmdb_ci_ip_phone] IP Router [cmdb_ci_ip_router] IP Server [cmdb_ci_ip_server] IP Service [cmdb_ip_service] IP Service Instance [cmdb_ci_ip_service] IP Switch [cmdb_ci_ip_switch] IT System Operations [u_it_system_operations] Item [sc_cart_item] ITSM Event [u_itsm_event] JavaServer [cmdb_ci_app_server_java] JBoss [cmdb_ci_app_server_jboss] KB Submission [kb_submission] Knowledge [kb_knowledge] Knowledge [knowledge_candidate] Knowledge [service_knowledge] Knowledge / Task Relationship [task_rel_kb_type] Knowledge Applied to Tasks [m2m_kb_task] Knowledge Related to Products [m2m_kb_ci] Knowledge Searches [ts_query_kb] KVM [cmdb_ci_kvm] KVM Object [cmdb_ci_kvm_object] KVM Virtual Device [cmdb_kvm_device] KVM Virtual Machine Instance [cmdb_ci_kvm_vm_instance] Label [label] Label auto [label_auto] Label entry [label_entry] Label history [label_history] Label table [label_table] LDAP Service [cmdb_ci_infra_service_ldap] Lease [ast_lease] Lease Instance [ast_contract_instance] License Entitlement [alm_entitlement] Line items [ast_po_item] Linux Memory Metrics [cmdb_metric_linux_memory] Linux Server [cmdb_ci_linux_server] List of Content [content_block_lists] Load Balancer [cmdb_ci_lb] Load Balancer Interface [cmdb_ci_lb_interface] Load Balancer Pool [cmdb_ci_lb_pool] Load Balancer Pool Member [cmdb_ci_lb_pool_member] Load Balancer Service [cmdb_ci_lb_service] Load Balancer Service VLAN [cmdb_lb_service_vlan] Load Balancer VLAN [cmdb_ci_lb_vlan] Load Balancer VLAN Interface [cmdb_lb_vlan_interface] Location [cmn_location] Locations affected [task_location] Logged in User [v_user_session] Login Rule [content_page_rule] Map [map] Map cell [map_cell] Map Preference [map_preferences] Map View Configuration Types [map_view_ci_type] Map View Relationship Types [map_view_rel_type] MARx Access [u_marx_access] Matcher Field Definitions [dl_definition_rel_match] Member [jrobin_graph_set_member] Memory Module [cmdb_ci_memory_module] Menu item [menu_item] Menu Section [menu_section] Meta Tags [content_page_meta] Metric [metric_instance] Metric definition [metric_definition] Microsoft Software License [ast_license_msft] MID Server [ecc_agent_monitor] MID server / CI Affinity [ecc_agent_ci] MID Server Capability [ecc_agent_capability] MID Server Capability [ecc_agent_capability_m2m] MID Server Capability Value Test [ecc_agent_capability_value_test] MID Server Cluster [ecc_agent_cluster] MID Server Cluster Agent [ecc_agent_cluster_member_m2m] MID Server Configuration Parameter [ecc_agent_config] MID Server IP Range [ecc_agent_ip_range] MID Server IP Range [ecc_agent_ip_range_m2m] MID Server Thread [ecc_agent_thread] Missing Extract [u_missing_extract] Model [cmdb_ci_model] Model Category [cmdb_model_category] Model Compatibility [cmdb_m2m_model_compatibility] Model Component [cmdb_m2m_model_component] Model Entry [cmdb_ci_model_entry] Model Name [cmdb_model] Model Substitution [cmdb_m2m_model_substitute] Monitors [u_monitors] MSFT SQL Catalog [cmdb_ci_db_mssql_catalog] MSFT SQL Instance [cmdb_ci_db_mssql_instance] MultiProbe [discovery_probes_multi] MultiProbe Included Probe [discovery_probes_multi_probe] MySQL Catalog [cmdb_ci_db_mysql_catalog] MySQL Instance [cmdb_ci_db_mysql_instance] Name Fixups [cmdb_fixup] Navigation Menu [content_block_menu] Netware Server [cmdb_ci_netware_server] Network [cmdb_ci_kvm_network] Network Adapter [cmdb_ci_network_adapter] Network Gear [cmdb_ci_netgear] Network Infrastructure Item [dscy_net_base] Network Resources [u_network_resources] Network Traffic [cmdb_ci_net_traffic] News [service_news] Next Hop Routing Rule [dscy_route_next_hop] NFS File system [cmdb_ci_file_system_nfs] NHP Incident SLA [u_nhp_incident_sla] Not Available for Groups [sc_categort_group_no_mtom] Notification condition [notification_condition] Notification Device [cmn_notif_device] Notification Device Variable [cmn_notif_device_variable] Notification Filter [notification_filter] Notification Group [cmn_notif_group] Notification Messages [cmn_notif_message] Notification Rules [cmn_rota_notif] Notification Service Provider [cmn_notif_service_provider] OLA [ola] OLA Monitors [ola_monitors] On-call Member [cmn_rota_member] On-call Notification [v_on_call] Oracle Catalog [cmdb_ci_db_ora_catalog] Oracle Database Listener [cmdb_ci_db_ora_listener] Oracle Instance [cmdb_ci_db_ora_instance] Ordered Item Link [sc_ordered_item_link] OS/X Server [cmdb_ci_osx_server] Other Schedule [cmn_other_schedule] Outage [cmdb_ci_outage] Outlet [cmdb_ci_pdu_outlet] Page [content_page] Pairing Request [ha_pairing_request] Parallels [cmdb_ci_vm_parallels] Partition Read/Write Statistics [cmdb_metric_partition] Patch [cmdb_ci_patches] PDF Page Header Footer Template [sys_report_page_hdrftr] PDU [cmdb_ci_pdu] Peer Relationships [cmdb_peer] People Relationship [cmdb_rel_person] Peripherals [u_peripherals] Plan [u_plan] Plan execution [plan_execution] Plan mysql [plan_mysql] Plan oracle [plan_oracle] Planned task [planned_task] Planned Task Relationship [planned_task_rel_planned_task] Power Equipment [cmdb_ci_power_eq] Power Generator [cmdb_ci_generator_power_eq] Price [fx_price] Price Test [fx_price_test] Print Queue [cmdb_ci_print_queue] Printer [cmdb_ci_printer] Printer Instance [cmdb_printer_instance] Printer Instance [cmdb_print_queue_instance] Probe [discovery_probes] Probe Capability [discovery_probe_capability_m2m] Probe parameter [discovery_probe_parameter] Probe to Credential Classification [probe_credential_class] Problem [problem] Problem Metric [problem_metric] Problem SLA [problem_sla] Process Guides [process_guide] Process Steps [process_step] Product [release_product] Product [u_product] Product Catalog Item [pc_product_cat_item] Production Control [u_production_control] Program [u_program] Project [pm_project] Project Metric [pm_project_metric] Project SLA [pm_project_sla] Project task [pm_project_task] Project Task Metric [pm_project_task_metric] Project Task SLA [pm_project_task_sla] Project Task Time Worked [pm_project_task_time_worked] Provider Portal [u_provider_portal] Provision Source [u_provision_source] Purchase Order [ast_po] Question Choices [question_choice] Queue [ecc_queue] Queue Handler [ecc_handler] RACI Matrix [u_pm_raci] Rack [cmdb_ci_rack] RCA Time Line [u_rca_time_line] Recurring Price [sc_recurring_rollup] Reference Definitions [u_reference_definitions] Relative Duration [cmn_relative_duration] Release [release_project] Release [u_release] Release Feature Metric [release_feature_metric] Release Metric [release_project_metric] Release Phase [release_phase] Release Task SLA [release_task_sla] Release Task SLA [release_task_metric] Reminder [reminder] Replicated Operation Snapshot [ha_replication_snapshot] Request [sc_request] Requested Item [sc_req_item] RFC's implemented [release_rfcs] Risk Conditions [risk_conditions] Root Cause Analysis [u_root_cause_analysis] Root SVN Location [u_root_svn_location] Roster [cmn_rota_roster] Roster Schedule Entry [roster_schedule_span] Rota [cmn_rota] Rotation Escalation [cmn_rota_escalation] Rotation Schedule [v_rotation] Round Robin Archive [jrobin_archive] Round Robin Data Source [jrobin_datasource] Round Robin Database [jrobin_database] Round Robin Definition [jrobin_definition] Round Robin Graph [jrobin_graph] Round Robin Graph Set [jrobin_graph_set] Router Interface [dscy_router_interface] Rule [sc_cat_item_guide_items] Run Document(s) [u_run_document_s_] Run Frequency [u_run_frequency] Running Process [cmdb_running_process] SAR Development Clients [u_sar_development_clients] SAR Production Clients [u_sar_production_clients] SAR Reporting Clients [u_sar_reporting_clients] SAR Test Clients [u_sar_test_clients] SAR Training Databases [u_sar_training_databases] Schedule [cmn_schedule] Schedule Entry [cmn_schedule_span] Schedule Page [cmn_schedule_page] Scriptable Object [v_scriptable_object] Seat [u_seat] Security Access Request [u_security_access_request] Security ACL Detail [security_acl_detail] Serial Number [cmdb_serial_number] Server [cmdb_ci_server] Service [cmdb_ip_service_ci] Service Account [u_service_account] Service Catalog Searches [sc_ts_query] Service Contract [ast_service] Service Desk [u_service_desk] Service Registry Query [service_reg_query] Service Request [u_service_request] Service Type [service_reg_query_slp_service_type] Shopping Cart [sc_cart] Site [content_site] Sized Content [content_block_sized] Skill [cmn_skill] SLA [contract_sla] SLA Conditions [sla_condition_class] SLA/OLA Business Owners [itil_agreement_owners] SLA/OLA Business Owners [itil_agreement_support] SLA/OLA General CI relationships [itil_agreement_ci] SLA/OLA Reports [itil_agreement_reports] SLA/OLA Targeted Items [itil_agreement_target_ci] SLP Query [service_reg_query_slp] SMB File system [cmdb_ci_file_system_smb] SNC Component [cmdb_ci_snc_component] SNMP Field [discovery_probes_snmp_field] SNMP Probe [discovery_probes_snmp] Software [cmdb_ci_spkg] Software Catalog [pc_software_cat_item] Software Downgrade [cmdb_m2m_downgrade_model] Software Instance [cmdb_software_instance] Software License [alm_license] Software License [ast_license_base] Software License [ast_software_license] Software License Instance [ast_license_package_instance] Software License Instance [ast_license_software_instance] Software Model [cmdb_software_product_model] Software Suite [cmdb_m2m_suite_model] Software Usage [ast_usage] Solaris Server [cmdb_ci_solaris_server] Solaris Virtual Machine Instance [cmdb_ci_solaris_instance] Source Code [u_source_code] SQL Response Metrics [cmdb_metric_sql] Stage Default [wf_stage_default] State Binding [state_binding] Static Content [content_block_static] Stock Rule [alm_stock_rule] Stockroom [alm_stockroom] Stockroom Model [alm_m2m_stockroom_model] Stockroom Type [alm_stockroom_type] Storage Device [cmdb_ci_msd] Storage Disk [cmdb_ci_storage_disk] Storage File Share [cmdb_ci_storage_fileshare] Storage HBA [cmdb_ci_storage_hba] Storage Pool [cmdb_ci_kvm_storage_pool] Storage Pool [cmdb_ci_storage_pool] Storage Port [cmdb_ci_storage_port] Storage Server [cmdb_ci_storage_server] Storage Volume [cmdb_ci_kvm_storage_volume] Storage Volume [cmdb_ci_storage_volume] Stored Procedures (SP) [u_stored_procedures__sp_] Style Sheet [content_css] Subscribers [cmdb_subscriber] Subversion [u_subversion] Suggested Relationship [cmdb_rel_type_suggest] Surger Protection Equipment [cmdb_ci_surge_power_eq] Survey [survey_master] Survey Conditions [survey_conditions] Survey Instances [survey_instance] Survey Responses [survey_response] Switch Forwarding Rule [dscy_swtch_fwd_rule] Switch Partition [dscy_swtch_partition] Switch Port [cmdb_switch_port] Switchport [dscy_switchport] Sybase Catalog [cmdb_ci_db_syb_catalog] Sybase Instance [cmdb_ci_db_syb_instance] Symantec Software License [ast_license_symantec] SysOps [u_moveit] System Logs [v_logfiles] Table [sys_db_object] Table Check Column [ha_table_check_column] Table Check Inconsistent Row [ha_table_check_row_incon] Table Check Row [ha_table_check_row] Table Scripts (DDL) [u_table_scripts__ddl_] Table Select [u_table_select] Task [task] Task / KB Relationship [task_rel_kb] Task Action Workflow [task_action_workflow] Task Relationship [task_rel_task] Task Relationship Type [task_rel_type] Task Relationships Allowed [task_rel_allowed] Task Sequencing [execution_plan_local] Task SLA [task_sla] Task Survey [task_survey] Task survey detail [task_survey_detail] TCP Connection [cmdb_tcp] TCP Connection [cmdb_tcp_connection] TCP Half-connection [cmdb_tcp_half] Template Import Log [template_import_log] Terms and Conditions [clm_m2m_contract_and_terms] Terms and Conditions [clm_terms_and_conditions] Test Audit View [u_v_test_audit_view] Test Cases [u_test_cases] Test Clients [u_test_clients] Test Execution [test_execution] Text Search Groups [ts_group] Text Search Summaries [ts_search_summary] Text Search Tables [ts_table] Text Searches [text_search] Thread State Metrics [cmdb_metric_thread] Ticket [ticket] Time Card [time_card] Time Worked [task_time_worked] TMG Core Groups [u_tmg_core_groups] Tomcat [cmdb_ci_app_server_tomcat] Tomcat Connector [cmdb_ci_tomcat_connector] Tower [cmdb_ci_tower_tower_eq] Tower Beacon [cmdb_ci_beacon_tower_eq] Tower Equipment [cmdb_ci_tower_eq] Tower Light Controller [cmdb_ci_twr_light_cnt_tower_eq] Tower Lights [cmdb_ci_tower_light_tower_eq] Training Databases [u_training_databases] Transfer Order [alm_transfer_order] Transfer Order Line [alm_transfer_order_line] Ts word roots [ts_word_roots] U view inc audit ebira [u_view_inc_audit_ebira] u_usageanalytics_users [u_usageanalytics_users] u_view_inc_dept [u_u_view_inc_dept] Uninterruptible Power Supply [cmdb_ci_ups_power_eq] UNIX Daemon [cmdb_ci_unix_daemon] UNIX Server [cmdb_ci_unix_server] UPS [cmdb_ci_ups] UPS Alarm [cmdb_ci_ups_alarm] UPS Alarm [ups_alarm] UPS Bypass [cmdb_ci_ups_bypass] UPS Input [cmdb_ci_ups_input] UPS Output [cmdb_ci_ups_output] Usage [u_usage] UsageAnalytics Counts for Tables [usageanalytics_count] UsageAnalytics for Applications [usageanalytics_app] User [sys_user] User Entitlement [alm_entitlement_user] User Role [sys_user_has_role] Users Covered [clm_m2m_contract_user] Variable [item_option_new] Variables [sc_item_variables_task] vCenter Folder Type [vmware_vcenter_folder_type_m2m] Vendor Catalog Item [pc_vendor_cat_item] Vendor Type [vendor_type] Version [u_version] Video [db_video] View Incident Audit [u_view_incident_audit_appdev] View Incident Audit [u_view_incident_audit] View Incident by Assigned To [u_view_incident_by_assigned_to] View Incident by Dept [u_view_incident_by_dept] Virtual Machine [cmdb_ci_vm] Virtual Machine Instance [cmdb_ci_vm_instance] Virtual Machine Object [cmdb_ci_vm_object] Virtual Machine Template [cmdb_ci_vm_template] Virtual Private Network [cmdb_ci_vpn] Virtualization Server [cmdb_ci_virtualization_server] VMware [cmdb_ci_vm_vmware] VMware Folder Type [vmware_folder_type] VMware vCenter Cluster [cmdb_ci_vcenter_cluster] VMware vCenter Datacenter [cmdb_ci_vcenter_datacenter] VMware vCenter Datastore [cmdb_ci_vcenter_datastore] VMware vCenter Folder [cmdb_ci_vcenter_folder] VMware vCenter Instance [cmdb_ci_vcenter] VMware vCenter Network [cmdb_ci_vcenter_network] VMware vCenter Object [cmdb_ci_vcenter_object] VMware vCenter Server Object [cmdb_ci_vcenter_server_obj] VMware Virtual Machine Instance [cmdb_ci_vmware_instance] VMware Virtual Machine Template [cmdb_ci_vmware_template] Warranty [ast_warranty] Web Application [cmdb_ci_web_application] Web Server [cmdb_ci_web_server] Web Service [cmdb_ci_web_service] Web Site [cmdb_ci_web_site] Websphere Cell [cmdb_ci_websphere_cell] Windows Classification [discovery_classy_windows] Windows Cluster [cmdb_ci_win_cluster] Windows Cluster Node [cmdb_ci_win_cluster_node] Windows Cluster Resource [cmdb_ci_win_cluster_resource] Windows Server [cmdb_ci_win_server] Windows Service [cmdb_ci_windows_service] Wing [u_wing] Wire [dscy_net_wire] Wizard Client Script [expert_script_client] Wizard Panel Transition [expert_panel_transition] Wizard UI Policy [expert_ui_policy] Wizard UI Policy Action [expert_ui_policy_action] WMI Field [discovery_probes_wmi_field] WMI Probe [discovery_probes_wmi] Workflow [wf_workflow] Workflow Actions [wf_action] Workflow Activity [wf_activity] Workflow Activity Definition [wf_activity_definition] Workflow Activity History [wf_history] Workflow Condition [wf_condition] Workflow Context [wf_context] Workflow Coverage Category [wf_category] Workflow Executing Activity [wf_executing] Workflow Execution [wf_workflow_execution] Workflow Instance [wf_workflow_instance] Workflow Queued Command [wf_command] Workflow SC Variable [wf_variable] Workflow Stage [wf_stage] Workflow Transition [wf_transition] Workflow Transition History [wf_transition_history] Wrapper Script (VBS) [u_wrapper_script__vbs_] XML [u_xml] Zones [cmdb_ci_vm_zones] Group by: Active Activity due Affected Application Affected Database Affected Server Application Name Approval Approval set Assigned to Assignment group Blocked by Firewall Business Priority Business duration Business resolve time Caller Can Be Reached Using DSL Can Make External Calls Can Make Internal Calls Can Receive External Calls Can Receive Internal Calls Category Caused by Change Change Owner Change Request Change Type Choice List Client Close code Closed Closed by Company Computer Name Configuration item Contact type Correlation ID Correlation display Created Created by Database Date/Time Expected Date/Time Started Date/Time of Failure Date/Time to Restore Delivery plan Delivery task Destination ID Device Type DocIDs Domain Due date Duration Environment Escalation Escalation Level Expected start Extension(s) File Available File In Sent Folder File Name(s) First Time Access Follow up Has Dial Tone Has This Ever Worked Imact_Answer Impact Impact_Question Incident Type Job Name Knowledge Location Made SLA Model Number Network Location Notify Number Occurred Before Opened Opened by Operations Order Output Location Parent Physical Location Printer Name Printer Type Priority Problem Projector Name Proxy User Radio On Reassignment count Rebooted PC Receiving Email Remote Access Turned On Remote User Reopened Replaced Battery Reportable SysID Resolve time Resolved Resolved by Responded Responded by SLA Number SLA Status SLA due Scope Severity Short description Space Remaining State(state) State(incident_state) Style Subcategory Subject Line Task type Testing Required Time worked Updated Updated by Updates Upon approval Upon reject Urgency Visibility Voice Mail Working Work end Work start vip_reminder Show Related Fields
I don't really care about the view type, I am just looking for something by State that show where each Assignment Group was at the end of the month. So that would be all Incidents not closed or resolved. Is this possible?
