Name update for Agent and associated resources in Azure Monitor  – Container Insights

Name update for Agent and associated resources in Azure Monitor – Container Insights

This article is contributed. See the original author and article here.

What is changing?  


When customers enable Container Insights, Azure Monitor deploys a containerized collection agent. This agent is being renamed from OMSAgent to Azure Monitor Agent. There are no feature updates or functional changes to the agent in this release.  


Why are the changes being made? 


The current OMSAgent name is a legacy name from the OMS product and does not reflect the branding for Azure Monitor and Container Insights products. The Azure Monitor Agent is being standardized as the single collection agent for Azure Monitor. The name change brings the agent’s name in line with these updates.  


When are the changes going live? 


The changes will roll out region by region starting from early September with AKS service update, expected to be these changes rolled out to all regions by the end of October. Exact dates and a version number of Container Insights image version with changes will be shared closer to the release date with an update to this blog post. 


AKS customers will receive the changes as part of an AKS service update. Arc and Hybrid customers will have to update the Extension and HELM chart versions manually. See detailed instructions below.  


What are the exact changes? 


The agent used by Container Insights has been renamed. So, customers will see a new pod name in their clusters. Alongside that, several other related resources have also been renamed. See the “List of renamed resources” and “List of renamed labels ” tables below for complete details.  


What is the impact? What do I need to do?  


Log analytics queries  


All log queries with string the omsagent in them will not work and results will only be returned for dates before the change. To mitigate, update the queries to have query clause to cover “omsagent” or “ama-logs” in existing queries. See examples below.  


 
 














Original query 



Updated query 



KubePodInventory 


| where Namespace == “kube-system” 


| where Name contains “omsagent” 


 



KubePodInventory 


| where Namespace == “kube-system” 


| where Name contains “omsagent” or Name contains “ama-logs” 


 



 














Original query 



Updated query 



ContainerLog 


| where Name contains “omsagent” 


 



ContainerLog  
| where Name contains “omsagent” or Name contains “ama-logs”  
 



 


Alert Rules 


Alert Rules with the string the omsagent will not work.  



  1. Query alerts with the string “omsagent” 



  1. Metric alerts which reference omsagent in a dimension   


You can find alert rules using  


Option 1 – In the Alerts section of Azure Monitor in the Azure portal


iacairns_0-1658251096562.png


 


 


Option 2 – Programmatically using Azure Resource Graph queries  


Go to the “Azure Resource Graph Explorer” in the portal and run the below query:  
 
alertsmanagementresources 


| where properties contains“omsagent” 


 


The above steps should help you find the affected rules. To update the rules, simply edit them in the portal (as below).  


 


iacairns_1-1658251096572.png


 


 


 


User scripts  


Any user scripts explicitly referencing the pod names will not work.  


Resource name in all UIs  


Customers will see the updated controller names in the Container Insights UI as well as the command line. 


Screenshot 1 – Container Insights Portal UI   


iacairns_2-1658251096578.png


 


 


iacairns_3-1658251096581.png


 


 


 


Screenshot 2 – Command Line 


iacairns_4-1658251096588.png


 


 


Screenshot 3 – Workbooks    


iacairns_5-1658251096591.png


 


 


Instructions for consuming the update 


Instructions for AKS customers  


No action needed from customers. Customers will receive this as part of an AKS service update.  


Instructions for Arc K8s customers  


Note: The extension version with the above changes is version 3.0.0 



  1. Get the Azure Log Analytics Workspace Resource Id which configured on the existing Azure Monitor for containers extension  


az k8s-extension show –name azuremonitor-containers –cluster-name <cluster-name> –resource-group <resource-group> –cluster-type connectedClusters -n azuremonitor-containers 


 



  1. Delete the existing Azure Monitor for Containers extension either through Azure Portal or Azure CLI 



  1. Create Azure Monitor for containers extension either through Azure Portal or Azure CLI. Make sure to use the same Azure Log Analytics Workspace ResourceId which is obtained in Step #1, to ensure the data being ingested to the same Log analytics workspace as before  


 


Instructions for Hybrid customers  


Note: The Helm chart version with the above changes is version 3.0.0 



  1. Get the Azure Log Analytics workspace which is being used for the Azure Monitor for containers HELM chart.  You can obtain through   


helm get values <azure-monitor-for-containers-release-name> -A 



  1. Delete the Azure Monitor for containers HELM chart – https://docs.microsoft.com/en-us/azure/azure-monitor/containers/container-insights-optout-hybrid#how-to-stop-monitoring-using-helm 



  1. Install the HELM chart as per the Instructions –  https://docs.microsoft.com/en-us/azure/azure-monitor/containers/container-insights-hybrid-setup#install-the-helm-chart . Make sure to same Azure Log Analytics Workspace to ensure the data being ingested to the same Log Analytics workspace as before. 


 


List of renamed resources 


Note: The xxxx below is a placeholder for random hash values appended to the resource name. In practice, a name like “ama-logs-xxxxx” will appear as “ama-logs-cfkst” or similar.   












































































Resource Type 



Old name 



New name 



Configmap 



configmap/omsagent-rs-config 



configmap/ama-logs-rs-config 



Pod 



pod/omsagent-xxxxx 



pod/ama-logs-xxxxx 



Pod 



pod/omsagent-rs-xxxxxxxxxx- xxxxx 



pod/ama-logs-rs- xxxxxxxxxx-xxxxx 



Pod 



pod/omsagent-win-xxxxx 



pod/ama-logs-windows- xxxxx 



Secret 



secret/omsagent-secret 



secret/ama-logs-secret 



Secret 



secret/omsagent-token-xxxxx 



secret/ama-logs-token-xxxxx 



ServiceAccount 



serviceaccount/omsagent 



serviceaccount/ama-logs 



ControllerRevision 



controllerrevision.apps/omsagent-xxxxxxxxxx 



controllerrevision.apps/ama-logs-xxxxxxxxxx 



ControllerRevision 



controllerrevision.apps/omsagent-win-xxxxxxxxxx 



controllerrevision.apps/ama-logs-windows-xxxxxxxxxx 



Daemonset 



daemonset.apps/omsagent 



daemonset.apps/ama-logs 



Daemonset 



daemonset.apps/omsagent-win 



daemonset.apps/ama-logs-windows 



Deployment 



deployment.apps/omsagent-rs 



deployment.apps/ama-logs-rs 



Replicaset 



replicaset.apps/omsagent-rs-xxxxxxxxxx 



replicaset.apps/ama-logs-rs-xxxxxxxxxx 



 


List of renamed labels 














component=oms-agent 



component=ama-logs-agent 



component=oms-agent-win 



component=ama-logs-agent-windows 



 


 

From enabling hybrid work to creating collaborative experiences—here’s what’s new in Microsoft 365

From enabling hybrid work to creating collaborative experiences—here’s what’s new in Microsoft 365

This article is contributed. See the original author and article here.

Now that hybrid work is just work, the challenge for organizations is to balance employee demands for flexibility with business needs. This month we made improvements to help employees work smarter and more efficiently, with integrated technology that brings people together across every role and function so they can connect and collaborate effectively in the flow of work.

The post From enabling hybrid work to creating collaborative experiences—here’s what’s new in Microsoft 365 appeared first on Microsoft 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Introducing the Microsoft Digital Contact Center Platform: A comprehensive, flexible customer care solution

Introducing the Microsoft Digital Contact Center Platform: A comprehensive, flexible customer care solution

This article is contributed. See the original author and article here.

In today’s digital world, brand reputation is synonymous with customer experience, including the quality of customer care. Consumers expect effortless, consistent, and secure experiences across any point of contact they choosein fact, their brand perception and customer loyalty depend on it. With the stakes this high, companies need a comprehensive yet flexible solution to modernize their customer care experience.

We are thrilled to introduce the Microsoft Digital Contact Center Platform, an open, extensible, and collaborative contact center solution designed to deliver seamless customer journeys.

Microsoft Digital Contact Center Platform powered with Nuance AI, Teams, and Dynamics 365

With the Microsoft Digital Contact Center Platform, contact centers are equipped with modern digital tools to engage customers across voice, video, and other digital engagement channelspowered by Microsoft Dynamics 365, Microsoft Teams, Microsoft Power Platform, and the newest member of the Microsoft family, Nuance.

The platform brings together a comprehensive yet flexible solution for contact centers, delivering best-in-class AI that powers self-service experiences, live customer engagements, collaborative agent experiences, business process automation, advanced telephony, and fraud prevention capabilities.  

The addition of Nuance brings a new level of conversational AI, security, and automation to the contact center. This gives both customers and agents tools to resolve issues faster and with more personalized service, thus reducing resolution times while improving customer satisfaction. It also enables contact centers to offer targeted incentives to build brand loyalty and upsell opportunities to boost revenue.

We recognize that the complexity and cost of upgrading technology can hold back innovation required to transform customer service from being a cost center to becoming a revenue driver. The open nature of our platform enables companies to build on what they already have and easily add any combination of capabilities they need to take their contact center to the next level. It integrates with a variety of contact center infrastructures and customer relationship management (CRM) systems. Companies can start small or go big, on their terms, and add capabilities at the right time. We are partnering with leaders in contact center infrastructureincluding Accenture-Avanade, Avaya, Genesys, HCL, NICE, and TTECto ensure interoperability and compatibility with contact center systems and components companies use or plan to implement now and in the future.

Enable omnichannel engagement and intelligent self-service

The average consumer uses multiple channels to communicate with a brand. The Microsoft Digital Contact Center Platform makes it easy to meet consumers in the channels they use every dayfrom voice to digital messagingwith secure and protected interactions. With the platform, companies can:

  • Resolve customer needs quickly and easily with customer self-service and automation, enabling scale through automation of repeatable tasks as well as sophisticated transactions.
  • Intelligently connect customers to virtual and live agents with the best-suited skills, experience, capacity, and availability, and provide agents with AI-powered recommendations.
  • Deliver hyper-personalized omnichannel service across voice and digital engagement channels, including support for major social messaging platforms. Provide richer service engagement with Teams voice and video embedded within Dynamics 365 Customer Service.

HP customer service chat on phone with customer asking about warranty coverage.
Figure 1: The Microsoft Digital Contact Center Platform enables automated and live hyper-personalized omnichannel service engagement across voice and digital channels.

Personalize and protect customer interactions

Consumers today expect brands to provide tailored experiences based on their engagement with the company. Delivering personalized experiences starts with using AI to identify and authenticate consumers seamlessly and securely, and requires unlocking the power of data to understand, customize, and optimize customer journeys.

The Microsoft Digital Contact Center Platform uses AI and deep analytics to anticipate customer requests, predict intent, and provide rapid resolution, which streamlines service and increases satisfaction. Customer experiences are protected with integrated biometric identification, authentication, and fraud prevention to build and maintain brand trust. The platform:

  • Uses biometric authentication to authenticate customers in seconds based on inherent biometrics and other factors.
  • Secures every customer and employee interaction, and prevents fraud while uncovering fraud patterns and attack vectors.
  • Provides insights on how consumers interact with the brand throughout their journey with customer journey analytics to improve customer acquisition and tailor personalized offers.
  • Understands why customers are calling and customizes the experience to anticipate their needs with AI intent prediction.

Customer on the phone with virtual agent looking to upgrade their plan. Customer gets verified through biometric authentication.
Figure 2: Biometric authentication capabilities create quick and secure connections for customers.

Improve agent productivity and modernize case management

The Microsoft Digital Contact Center Platform empowers agents to better serve customers by bringing the right information, people, and insights directly into the flow of work with Context IQ. It provides intelligent next-best response recommendations and sentiment analysis to enable fast resolutions. What’s more, this creates a learning loop so automated solutions continually evolve and become smarter. The platform:

  • Provides agents with a 360-degree view of the customer and their journey. Agents can manage customer requests seamlessly from any channel, even while handling multiple sessions at the same time.
  • Empowers agents with personalized conversational intelligence, including sentiment analysis, to truly understand customer emotions and needs. Next-best response and offer recommendations help create valuable upsell and cross-sell opportunities.
  • Assists the agent in identifying the resolution with AI-recommended knowledge articles.
  • Automates how agents quickly and efficiently bring together experts to resolve an open case through intelligent case swarming. With a single click, agents can collaborate with experts matched based on skillset and expertise.

Dynamics 365 agent dashboard showing customer sentiment and suggested actions for the agent to use in conversation with a customer.
Figure 3: Agents can view a real-time call transcript, see the customer’s details, recent cases, and suggested knowledge articles and similar cases to help resolve customer issues more quickly.

Increase customer acquisition and revenue

Rich real-time insights and analytics enable data-driven decisions to improve customer satisfaction, with conversational analytics providing instant visibility into trends across engagement channels. With the Microsoft Digital Contact Center Platform, companies can:

  • Enable agents to increase conversions and drive upsell through real-time offers.
  • Help customers find and select products through personalized offer recommendations, driving upsell and cross-sell revenue.
  • Track user behavior and data to quickly identify and offer optimal engagement opportunities through predictive targeting,thereby improving satisfaction and increasing revenue.
  • Preemptively notify customers of special promotions and updates, which accelerates their purchase intent, and boosts revenue and long-term value.

Drive infrastructure simplicity, flexibility, and innovation

The Microsoft Digital Contact Center Platform simplifies implementation and support of contact center infrastructure, removing complex IT integrations while maintaining flexibility for customers and partners seeking comprehensive Contact Center and Customer Engagement solutions.

Contact center tasks and workflows ranging in complexity from routine conversations to sophisticated transactions can easily be automated using no-code, low-code, or pro-code experiences. Powerful chatbots equipped with conversational AI can be created to converse with customers intelligently and efficiently across engagement channels. Consumers can self-service a wide variety of cases, getting connected with a live agent when needed for support with complex issues.

The platform is also cloud-scale and elastic to accommodate seasonal or surging demand. It automatically adjusts to changes in contact volume, agent counts, wait times, and service levels without performance impact.

Transform the contact center with our extensive partner network

Accenture-Avanade, a customer experience (CX) transformation partner, will deliver its Customer Engagement solutions starting with the Microsoft Digital Contact Center Platform to help customers reimagine their entire customer experience and deliver business results. Additional launch partners include systems integrators EY, HCL, Hitachi, KPMG, PwC, TCS, and TTEC, and ISVs such as Avaya, Genesys, and NICE. With this robust set of launch partners, customers around the globe will be positioned to create new and sophisticated solutions to address specific contact center challenges.

Learn more

Learn more about how to transform customer and agent experiences with the Microsoft Digital Contact Center Platform and explore the full set of capabilities.

Join us at Microsoft Inspire on July 1920 to learn how to unleash customer service innovations with Dynamics 365, Teams, and Nuance.

The post Introducing the Microsoft Digital Contact Center Platform: A comprehensive, flexible customer care solution appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Microsoft Purview Information Protection now includes enhanced security for detection of credentials

Microsoft Purview Information Protection now includes enhanced security for detection of credentials

This article is contributed. See the original author and article here.

Hybrid work environments have introduced new vulnerable access points to organizations’ data and credentials, requiring improvements in credential security to help prevent the risk of cyber-attacks. In addition, the associated costs of security incidents that involve remote work are over $1 million more expensive on average than incidents that don’t involve remote work.1 Sixty-one percent of data breaches involve credentials, making them the most compromised data type in breaches.2 Cyber attackers often leverage compromised credentials to access personal data like medical history and banking information, which they can later sell on the “dark web.”


 


At Microsoft, our goal is to provide a built-in, intelligent, unified, and extensible solution to protect sensitive data across your digital estate – in Microsoft 365 cloud services, on-premises, third-party SaaS applications, and more. With Microsoft Purview Information Protection, we are building a unified set of capabilities for data classification, labeling, and protection not only in Office Apps, but also in other popular productivity services where information resides (e.g., SharePoint Online, Exchange Online, and Microsoft Teams), as well as endpoint devices.  


 


There are currently over 250 pre-built Sensitive Information Types available (e.g., PII identifiers, social security, credit card, bank account numbers, etc.). We are pleased to announce that we are now starting public preview* of 42 new Sensitive Information Types (SITs) enabling organizations to identify, classify, and protect credentials found in documents across OneDrive, SharePoint, Teams, Office Web Apps, Outlook, Exchange Online, Defender for Cloud Apps, and Windows devices. These credential SITs can be included in information protection auto-labeling and data loss prevention policies to help organizations discover a wide range of digital authentication credential types (aka “secrets”), such as user credentials (username and passwords), default passwords, and Azure cloud resources (e.g., Storage Account Keys, SQL Server Connection Strings, and SAS). Also included are new SITs for Amazon S3 Client Secret Access Key, X.509 Certificate Private Key, GitHub Personal Access Token, ASP.NET Machine Key, Slack Access Token, Google API, Ansible Vault, and more. Note that many of these SITs are credentials that provide access to cloud development and other resources, which have been the target of sophisticated attacks on DevOps pipelines within organizations.


 


List of all 42 new SITs:


 












































































Amazon S3 Client Secret Access Key



Azure Subscription Management Certificate



Azure SQL Connection String



Azure Service Bus Shared Access Signature



Azure Redis Cache Connection String Password



Azure IoT Shared Access Key



Azure Storage Account Shared Access Signature



Azure Storage Account Shared Access Signature for High-Risk Resources



Azure Logic App Shared Access Signature



Azure Storage Account Access Key



Azure COSMOS DB Account Access Key



Azure App Service Deployment Password



Azure DevOps Personal Access Token



Azure DevOps App Secret



Azure Function Master / API Key



Azure Shared Access Key / Web Hook Token



Azure AD Client Access Token



Azure AD User Credentials



Azure AD Client Secret



Azure Bot Service App Secret



Azure Databricks Personal Access Token



Azure Container Registry Access Key



Azure Batch Shared Access Key



Azure SignalR Access Key



Azure EventGrid Access Key



Azure Machine Learning Web Service API Key



Azure Cognitive Search API Key



Azure Cognitive Service Key



Azure Maps Subscription Key



Azure Bot Framework Secret Key



X.509 Certificate Private Key



User Login Credentials



ASP.NET Machine Key



General Password



Http Authorization Header



Client Secret / API Key



General Symmetric Key



GitHub Personal Access Token



Google API key



Microsoft Bing Maps Key



Slack Access Token



SIT that includes all 41 previous SITs



 


New credential SITs key capabilities



  • Within the Microsoft Purview compliance portal, these new credential SITs can be added to auto-labeling and DLP policies to quickly and accurately detect and classify complex digital authentication credentials

  • System administrators can test the accuracy of individual SITs against sample data

  • These new credential SITs will be visible in Content Explorer and Activity Explorer, enabling users to:

    • Locate documents that contain sensitive credentials within their environment

    • Identify activity involving the use of credential data within their environment




Public preview also includes:





































Support for: Microsoft Purview solutions
Sensitivity labels Information Protection
Auto-labeling** Data Loss Prevention (DLP) policies 
Exact Data Match SITs Insider Risk Management
  Data Lifecycle Management
  Records Management
  eDiscovery
  Microsoft Priva

 


*Note: Rollout has begun as of July 18th and is expected to be fully completed within a 24-hour window (July 19th).


**Note: Office client-side labeling is currently not supported, but it will be available sometime in CY22H2. Please stay tuned for additional updates on this capability. 


 


In-Product Screenshot(s)


 


__________________________0-1656626825649.png


Figure 1: Detection of general passwords using Credential SIT. Note that an E5 or A5 license is required for accessing Credential SITs, which will be in public preview within the next few weeks for commercial cloud customers and government clouds (GCC, GCC-High, Department of Defense).


 


Learn more about Microsoft Purview Information Protection and Credential SITs here. We are constantly extending our product capabilities to help organizations more easily classify and protect sensitive data.


 


Get Started 


We are happy to share that there is now an easier way for you to try Microsoft Purview solutions directly in the Microsoft Purview compliance portal with a trial. By enabling the trial in the Purview compliance portal, you can quickly access the new Credential SITs and Easy Trials, and start using all capabilities of Microsoft Purview, including Insider Risk Management, Records Management, Audit, eDiscovery, Communication Compliance, Information Protection, Data Lifecycle Management, Data Loss Prevention, and Compliance Manager. Visit your Microsoft Purview compliance portal for more details or check out the Microsoft Purview solutions trial (an active M365 E3 subscription is required as a prerequisite).


 


With Information Protection Easy Trials, users can apply default labels and get label recommendations on items containing sensitive data such as credit card numbers and activate features with a single click. System admins can review items containing credit card numbers and decide whether to automatically apply a label to them. Also, get further information on how to set up recommended information protection features and how to create auto-labeling policies.


 


We look forward to hearing your feedback! 



1 IBM Security and Ponemon Institute, “Cost of a Data Breach Report 2021,” July 2021


2 Verizon “2021 Data Breach Investigations Report”, May 2021

Lesson Learned #225: Has an unresolved reference to object using Linked Server or External Table

This article is contributed. See the original author and article here.

We used to have cases when our customers are trying to export their database using SQLPackage or Export service in the Portal having, for example, the following error message: Error SQL71562: Error validating element Synonym: [dbo].[MyView] has an unresolved reference to object [linkedserver].[databasename].[schemaname].[tablename]. External references are not supported when creating a package from this platform. In this post I would like to suggest an alternative to export this data.


 


The first thing that we need to know that SQLPackage validates that we don’t have any of the following points in our database that we want to export:


 



  • Reference using 4 parts, for example, databasename.schemaname.tablename

  • Using an external table.

  • Calling a table using a linked server, for example, select * from mylinkedserver.databasename.schema.table

  • Calling a synonyms that uses a linked server, for example, CREATE SYNONYM [dbo].[ExternalTable1] FOR [linkedserver].[databasename].[schemaname].[tablename]


If we have any of these scenarios we are going to have the following error message exporting the data:


 



  • One or more unsupported elements were found in the schema used as part of a data package.
    Error SQL71562: Error validating element Synonym: [dbo].[MyView] has an unresolved reference to object [linkedserver].[databasename].[schemaname].[tablename]. External references are not supported when creating a package from this platform.



  • One or more unsupported elements were found in the schema used as part of a data package.
    Error SQL71562: Error validating element [dbo].[ExternalTable1]: Synonym: [dbo].[ExternalTable1] has an unresolved reference to object [linkedservername].[databasename].[schemaname].[tablename]. External references are not supported when creating a package from this platform.




 


In order to be able to export the data, I developed the following stored procedure that basically, runs the following code. The goal is to create dynamically the external table and/or view or synonym that is calling external tables,


 



  • Parameters:

    • @TableName = will be the name of the synonym or external table to create. 

    • @Action = will be the operation to perform, CREATE or DROP the synonym




 


 

CREATE PROCEDURE dbo.DeployMyExternalTable(@TableName varchar(400),@Action VARCHAR(10))
AS

 IF @TableName = 'ExternalTable1' 
 BEGIN
  IF @Action = 'CREATE' 
    BEGIN 
      IF NOT EXISTS( SELECT TOP 1 NAME FROM SYS.synonyms WHERE Name='ExternalTable1' )
	  	 EXEC SP_EXECUTESQL N'CREATE SYNONYM [dbo].[ExternalTable1] FOR [LinkedServerName].[DatabaseName].[SchemaName].[ExternalData1]' 
    END
  IF @Action = 'DROP' 
    BEGIN 
	 IF EXISTS( SELECT TOP 1 NAME FROM SYS.synonyms WHERE Name='ExternalTable1' )
	    EXEC SP_EXECUTESQL N'DROP SYNONYM [dbo].[ExternalTable1]' 
    END
 END
 
 IF @TableName = 'ExternalTable2' 
 BEGIN
  IF @Action = 'CREATE' 
    BEGIN 
     IF NOT EXISTS( SELECT TOP 1 NAME FROM SYS.synonyms WHERE Name='ExternalTable2' )
    	 EXEC SP_EXECUTESQL N'CREATE SYNONYM [dbo].[ExternalTable2] CREATE SYNONYM [dbo].[ExternalTable2] FOR [LinkedServerName].[DatabaseName].[SchemaName].[ExternalData2]' 
    END
  IF @Action = 'DROP' 
    BEGIN 
	 IF EXISTS( SELECT TOP 1 NAME FROM SYS.synonyms WHERE Name='ExternalTable2' )
	    EXEC SP_EXECUTESQL N'DROP SYNONYM [dbo].[ExternalTable2]' 
    END
 END

 


 


The idea is if you need to run any query against this synonym or external table is to run the following code: 


 


 

exec dbo.DeployMyExternalTable 'ExternalTable1', 'CREATE'

SELECT * FROM [dbo].[ExternalTable1]

 


 


Or if you need to delete it


 


 

exec dbo.DeployMyExternalTable 'ExternalTable1', 'DROP'

 


 


Basically, if you need to export the data, you could call these stored procedure for all synonyms or external tables, export the data and after it your application/database will create again them without modifying your code. 


 


Enjoy!