get_TagComms.tqsq

<?xml version="1.0" encoding="UTF-8"?><SQLQuery AllowBuffering="false" AllowFuture="true" AutoTypeParameters="false" CacheDuration="0" CacheDurationUnits="M" CachedServer="MESM" Columns="" Comment="" Connector="" DateColumn="" DateFormat="MM/dd/yyyy HH:mm:ss" Debug="false" Description="" DocType="SQLQuery" Duration="60" DurationUnits="M" EndDate="" FilterExpr="" FixedQuery="" Group="" GroupingExpr="" ID="3067" InlineTransform="" IntervalCount="1" IsCachable="false" JoinExpr="" Mask="" Method="" Mode="FixedQuery" NumberFormat="0.00" Param.1="" Param.10="" Param.11="" Param.12="" Param.13="" Param.14="" Param.15="" Param.16="" Param.17="" Param.18="" Param.19="" Param.2="" Param.20="" Param.21="" Param.22="" Param.23="" Param.24="" Param.25="" Param.26="" Param.27="" Param.28="" Param.29="" Param.3="" Param.30="" Param.31="" Param.32="" Param.4="" Param.5="" Param.6="" Param.7="" Param.8="" Param.9="" ParamDescription.1="" ParamDescription.10="" ParamDescription.11="" ParamDescription.12="" ParamDescription.13="" ParamDescription.14="" ParamDescription.15="" ParamDescription.16="" ParamDescription.17="" ParamDescription.18="" ParamDescription.19="" ParamDescription.2="" ParamDescription.20="" ParamDescription.21="" ParamDescription.22="" ParamDescription.23="" ParamDescription.24="" ParamDescription.25="" ParamDescription.26="" ParamDescription.27="" ParamDescription.28="" ParamDescription.29="" ParamDescription.3="" ParamDescription.30="" ParamDescription.31="" ParamDescription.32="" ParamDescription.4="" ParamDescription.5="" ParamDescription.6="" ParamDescription.7="" ParamDescription.8="" ParamDescription.9="" ParamType.1="" ParamType.10="" ParamType.11="" ParamType.12="" ParamType.13="" ParamType.14="" ParamType.15="" ParamType.16="" ParamType.17="" ParamType.18="" ParamType.19="" ParamType.2="" ParamType.20="" ParamType.21="" ParamType.22="" ParamType.23="" ParamType.24="" ParamType.25="" ParamType.26="" ParamType.27="" ParamType.28="" ParamType.29="" ParamType.3="" ParamType.30="" ParamType.31="" ParamType.32="" ParamType.4="" ParamType.5="" ParamType.6="" ParamType.7="" ParamType.8="" ParamType.9="" Password="" PathID="768" Query="EXEC MESM_TagComms_Get&#10;" QueryParams="" ReaderRoles="SAP_XMII_User" RestrictedPropertyOverride="false" RowCount="5000" SaveDate="12/09/2016 14:52:48" Schedule="" SelectedColumns="" Server="MESM" Service="" SortExpr="" StartDate="" Tables="" TempTable="" TempTableList="CHECK_CONSTRAINTS,COLUMNS,COLUMN_DOMAIN_USAGE,COLUMN_PRIVILEGES,CONSTRAINT_COLUMN_USAGE,CONSTRAINT_TABLE_USAGE,DOMAINS,DOMAIN_CONSTRAINTS,KEY_COLUMN_USAGE,MESM_FloorMaps,MESM_FloorStations,MESM_JobsPartsStation,MESM_JobsSerial,MESM_LvlHierarchy,MESM_MaterialStock,MESM_Matrix_Operators_Eqp,MESM_Matrix_Operators_Stations,MESM_Operators,MESM_Orders,MESM_OrdersComponents,MESM_OrdersComponentsIssued,MESM_OrdersConfirmations,MESM_OrdersDowntime,MESM_OrdersDowntimeTypes,MESM_OrdersJobs,MESM_OrdersProduction,MESM_OrdersScheduleLog,MESM_OrdersSpecialInstructions,MESM_OrdersStatusLog,MESM_OrdersStatusTypes,MESM_PCoAgents,MESM_PCoServers,MESM_ShiftTypes,MESM_TagComm,MESM_TagFunctions,MESM_TagTypes,MES_data_Job_Ctl,MES_data_Job_Item_Ctl,MES_data_Job_Rework,MES_data_Job_Serial,MES_data_Job_Stn,MES_data_Job_Stn_Req_Dtl,MES_data_Job_Stn_Req_Hedr,PARAMETERS,REFERENTIAL_CONSTRAINTS,ROUTINES,ROUTINE_COLUMNS,SCHEMATA,SEQUENCES,TABLES,TABLE_CONSTRAINTS,TABLE_PRIVILEGES,VIEWS,VIEW_COLUMN_USAGE,VIEW_TABLE_USAGE,all_columns,all_objects,all_parameters,all_sql_modules,all_views,allocation_units,assemblies,assembly_files,assembly_modules,assembly_references,assembly_types,asymmetric_keys,availability_databases_cluster,availability_group_listener_ip_addresses,availability_group_listeners,availability_groups,availability_groups_cluster,availability_read_only_routing_lists,availability_replicas,backup_devices,certificates,change_tracking_databases,change_tracking_tables,check_constraints,column_store_dictionaries,column_store_segments,column_type_usages,column_xml_schema_collection_usages,columns,computed_columns,configurations,conversation_endpoints,conversation_groups,conversation_priorities,credentials,crypt_properties,cryptographic_providers,data_spaces,database_audit_specification_details,database_audit_specifications,database_files,database_filestream_options,database_mirroring,database_mirroring_endpoints,database_mirroring_witnesses,database_permissions,database_principals,database_recovery_status,database_role_members,databases,default_constraints,destination_data_spaces,dm_audit_actions,dm_audit_class_type_map,dm_broker_activated_tasks,dm_broker_connections,dm_broker_forwarded_messages,dm_broker_queue_monitors,dm_cdc_errors,dm_cdc_log_scan_sessions,dm_clr_appdomains,dm_clr_loaded_assemblies,dm_clr_properties,dm_clr_tasks,dm_cryptographic_provider_properties,dm_database_encryption_keys,dm_db_file_space_usage,dm_db_fts_index_physical_stats,dm_db_index_usage_stats,dm_db_log_space_usage,dm_db_mirroring_auto_page_repair,dm_db_mirroring_connections,dm_db_mirroring_past_actions,dm_db_missing_index_details,dm_db_missing_index_group_stats,dm_db_missing_index_groups,dm_db_partition_stats,dm_db_persisted_sku_features,dm_db_script_level,dm_db_session_space_usage,dm_db_task_space_usage,dm_db_uncontained_entities,dm_exec_background_job_queue,dm_exec_background_job_queue_stats,dm_exec_cached_plans,dm_exec_connections,dm_exec_procedure_stats,dm_exec_query_memory_grants,dm_exec_query_optimizer_info,dm_exec_query_resource_semaphores,dm_exec_query_stats,dm_exec_query_transformation_stats,dm_exec_requests,dm_exec_sessions,dm_exec_trigger_stats,dm_filestream_file_io_handles,dm_filestream_file_io_requests,dm_filestream_non_transacted_handles,dm_fts_active_catalogs,dm_fts_fdhosts,dm_fts_index_population,dm_fts_memory_buffers,dm_fts_memory_pools,dm_fts_outstanding_batches,dm_fts_population_ranges,dm_fts_semantic_similarity_population,dm_hadr_auto_page_repair,dm_hadr_availability_group_states,dm_hadr_availability_replica_cluster_nodes,dm_hadr_availability_replica_cluster_states,dm_hadr_availability_replica_states,dm_hadr_cluster,dm_hadr_cluster_members,dm_hadr_cluster_networks,dm_hadr_database_replica_cluster_states,dm_hadr_database_replica_states,dm_hadr_instance_node_map,dm_hadr_name_id_map,dm_io_backup_tapes,dm_io_cluster_shared_drives,dm_io_pending_io_requests,dm_logpool_hashentries,dm_logpool_stats,dm_os_buffer_descriptors,dm_os_child_instances,dm_os_cluster_nodes,dm_os_cluster_properties,dm_os_dispatcher_pools,dm_os_dispatchers,dm_os_hosts,dm_os_latch_stats,dm_os_loaded_modules,dm_os_memory_allocations,dm_os_memory_broker_clerks,dm_os_memory_brokers,dm_os_memory_cache_clock_hands,dm_os_memory_cache_counters,dm_os_memory_cache_entries,dm_os_memory_cache_hash_tables,dm_os_memory_clerks,dm_os_memory_node_access_stats,dm_os_memory_nodes,dm_os_memory_objects,dm_os_memory_pools,dm_os_nodes,dm_os_performance_counters,dm_os_process_memory,dm_os_ring_buffers,dm_os_schedulers,dm_os_server_diagnostics_log_configurations,dm_os_spinlock_stats,dm_os_stacks,dm_os_sublatches,dm_os_sys_info,dm_os_sys_memory,dm_os_tasks,dm_os_threads,dm_os_virtual_address_dump,dm_os_wait_stats,dm_os_waiting_tasks,dm_os_windows_info,dm_os_worker_local_storage,dm_os_workers,dm_qn_subscriptions,dm_repl_articles,dm_repl_schemas,dm_repl_tranhash,dm_repl_traninfo,dm_resource_governor_configuration,dm_resource_governor_resource_pool_affinity,dm_resource_governor_resource_pools,dm_resource_governor_workload_groups,dm_server_audit_status,dm_server_memory_dumps,dm_server_registry,dm_server_services,dm_tcp_listener_states,dm_tran_active_snapshot_database_transactions,dm_tran_active_transactions,dm_tran_commit_table,dm_tran_current_snapshot,dm_tran_current_transaction,dm_tran_database_transactions,dm_tran_locks,dm_tran_session_transactions,dm_tran_top_version_generators,dm_tran_transactions_snapshot,dm_tran_version_store,dm_xe_map_values,dm_xe_object_columns,dm_xe_objects,dm_xe_packages,dm_xe_session_event_actions,dm_xe_session_events,dm_xe_session_object_columns,dm_xe_session_targets,dm_xe_sessions,endpoint_webmethods,endpoints,event_notification_event_types,event_notifications,events,extended_procedures,extended_properties,filegroups,filetable_system_defined_objects,filetables,foreign_key_columns,foreign_keys,fulltext_catalogs,fulltext_document_types,fulltext_index_catalog_usages,fulltext_index_columns,fulltext_index_fragments,fulltext_indexes,fulltext_languages,fulltext_semantic_language_statistics_database,fulltext_semantic_languages,fulltext_stoplists,fulltext_stopwords,fulltext_system_stopwords,function_order_columns,http_endpoints,identity_columns,index_columns,indexes,internal_tables,key_constraints,key_encryptions,linked_logins,login_token,master_files,master_key_passwords,message_type_xml_schema_collection_usages,messages,module_assembly_usages,numbered_procedure_parameters,numbered_procedures,objects,openkeys,parameter_type_usages,parameter_xml_schema_collection_usages,parameters,partition_functions,partition_parameters,partition_range_values,partition_schemes,partitions,plan_guides,procedures,registered_search_properties,registered_search_property_lists,remote_logins,remote_service_bindings,resource_governor_configuration,resource_governor_resource_pool_affinity,resource_governor_resource_pools,resource_governor_workload_groups,routes,schemas,securable_classes,selective_xml_index_namespaces,selective_xml_index_paths,sequences,server_assembly_modules,server_audit_specification_details,server_audit_specifications,server_audits,server_event_notifications,server_event_session_actions,server_event_session_events,server_event_session_fields,server_event_session_targets,server_event_sessions,server_events,server_file_audits,server_permissions,server_principal_credentials,server_principals,server_role_members,server_sql_modules,server_trigger_events,server_triggers,servers,service_broker_endpoints,service_contract_message_usages,service_contract_usages,service_contracts,service_message_types,service_queue_usages,service_queues,services,soap_endpoints,spatial_index_tessellations,spatial_indexes,spatial_reference_systems,sql_dependencies,sql_expression_dependencies,sql_logins,sql_modules,stats,stats_columns,symmetric_keys,synonyms,sysaltfiles,syscacheobjects,syscharsets,syscolumns,syscomments,sysconfigures,sysconstraints,syscurconfigs,syscursorcolumns,syscursorrefs,syscursors,syscursortables,sysdatabases,sysdepends,sysdevices,sysdiagrams,sysfilegroups,sysfiles,sysforeignkeys,sysfulltextcatalogs,sysindexes,sysindexkeys,syslanguages,syslockinfo,syslogins,sysmembers,sysmessages,sysobjects,sysoledbusers,sysopentapes,sysperfinfo,syspermissions,sysprocesses,sysprotects,sysreferences,sysremotelogins,sysservers,system_columns,system_components_surface_area_configuration,system_internals_allocation_units,system_internals_partition_columns,system_internals_partitions,system_objects,system_parameters,system_sql_modules,system_views,systypes,sysusers,table_types,tables,tcp_endpoints,trace_categories,trace_columns,trace_event_bindings,trace_events,trace_subclass_values,trace_xe_action_map,trace_xe_event_map,traces,transmission_queue,trigger_event_types,trigger_events,triggers,type_assembly_usages,types,user_token,via_endpoints,views,xml_indexes,xml_schema_attributes,xml_schema_collections,xml_schema_component_placements,xml_schema_components,xml_schema_elements,xml_schema_facets,xml_schema_model_groups,xml_schema_namespaces,xml_schema_types,xml_schema_wildcard_namespaces,xml_schema_wildcards,zoldMAA_data_Stn_Part_Data" Time="" TimePeriod="" Trace="false" UseTypedParams="false" UserName="" Version="15.0.7.12" WriterRoles="SAP_XMII_Super_Administrator,SAP_XMII_Administrator,SAP_XMII_Developer" XParamName.1="" XParamName.10="" XParamName.11="" XParamName.12="" XParamName.13="" XParamName.14="" XParamName.15="" XParamName.16="" XParamName.2="" XParamName.3="" XParamName.4="" XParamName.5="" XParamName.6="" XParamName.7="" XParamName.8="" XParamName.9="" XParamValue.1="" XParamValue.10="" XParamValue.11="" XParamValue.12="" XParamValue.13="" XParamValue.14="" XParamValue.15="" XParamValue.16="" XParamValue.2="" XParamValue.3="" XParamValue.4="" XParamValue.5="" XParamValue.6="" XParamValue.7="" XParamValue.8="" XParamValue.9=""><Joins/><Tasks/></SQLQuery>