Category: Microsoft
Category Archives: Microsoft
text to date
Need to transform the string which contain start and end date to seperat cell
Need to transform the string which contain start and end date to seperat cell Read More
sum of cpu cost present in every node in the actual query plan vs, STATISTICS TIME ON, are not same.
i run the query with stats on,
cpu time i’m getting from STATISTICS TIME and sum of cpu cost in each node present STATISTICS XML plan have huge difference. this happed for every query that i’m running why this case. usually it should be similar right?
i got very low cpu time in STATISTICS TIME and high time in sum up all the node cpu time.
i run the query with stats on,SET STATISTICS XML ON;SET STATISTICS TIME ON;cpu time i’m getting from STATISTICS TIME and sum of cpu cost in each node present STATISTICS XML plan have huge difference. this happed for every query that i’m running why this case. usually it should be similar right?i got very low cpu time in STATISTICS TIME and high time in sum up all the node cpu time.ref Read More
MSExchange Front End HTTP Proxy error: [Ecp] An internal server error occurred.
Hello,
i get this multiple error message on exchange 2019 last cu and security update.
S.O: windows 2022
Log Name: Application
Source: MSExchange Front End HTTP Proxy
Date: 23/04/2024 09:12:25
Event ID: 1003
Task Category: Core
Level: Error
Keywords: Classic
User: N/A
Computer: mail-server.
Description:
[Ecp] An internal server error occurred. The unhandled exception was: System.ArgumentException: Invalid input value
Nome parametro: input
in Microsoft.Exchange.Data.ApplicationLogic.Cafe.BackEndServer.FromString(String input)
in Microsoft.Exchange.HttpProxy.BEResourceRequestHandler.ResolveAnchorMailbox()
in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.InternalBeginCalculateTargetBackEnd(AnchorMailbox& anchorMailbox)
in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.<BeginCalculateTargetBackEnd>b__279_0()
in Microsoft.Exchange.Common.IL.ILUtil.DoTryFilterCatch(Action tryDelegate, Func`2 filterDelegate, Action`1 catchDelegate)
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event“>
<System>
<Provider Name=”MSExchange Front End HTTP Proxy” />
<EventID Qualifiers=”49152″>1003</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>1</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime=”2024-04-23T07:12:25.0793088Z” />
<EventRecordID>267303</EventRecordID>
<Correlation />
<Execution ProcessID=”0″ ThreadID=”0″ />
<Channel>Application</Channel>
<Computer>mail-server.</Computer>
<Security />
</System>
<EventData>
<Data>Ecp</Data>
<Data>System.ArgumentException: Invalid input value
Nome parametro: input
in Microsoft.Exchange.Data.ApplicationLogic.Cafe.BackEndServer.FromString(String input)
in Microsoft.Exchange.HttpProxy.BEResourceRequestHandler.ResolveAnchorMailbox()
in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.InternalBeginCalculateTargetBackEnd(AnchorMailbox& anchorMailbox)
in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.<BeginCalculateTargetBackEnd>b__279_0()
in Microsoft.Exchange.Common.IL.ILUtil.DoTryFilterCatch(Action tryDelegate, Func`2 filterDelegate, Action`1 catchDelegate)</Data>
</EventData>
</Event>
Hello,i get this multiple error message on exchange 2019 last cu and security update.S.O: windows 2022 Log Name: ApplicationSource: MSExchange Front End HTTP ProxyDate: 23/04/2024 09:12:25Event ID: 1003Task Category: CoreLevel: ErrorKeywords: ClassicUser: N/AComputer: mail-server.Description:[Ecp] An internal server error occurred. The unhandled exception was: System.ArgumentException: Invalid input valueNome parametro: inputin Microsoft.Exchange.Data.ApplicationLogic.Cafe.BackEndServer.FromString(String input)in Microsoft.Exchange.HttpProxy.BEResourceRequestHandler.ResolveAnchorMailbox()in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.InternalBeginCalculateTargetBackEnd(AnchorMailbox& anchorMailbox)in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.<BeginCalculateTargetBackEnd>b__279_0()in Microsoft.Exchange.Common.IL.ILUtil.DoTryFilterCatch(Action tryDelegate, Func`2 filterDelegate, Action`1 catchDelegate)Event Xml:<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”><System><Provider Name=”MSExchange Front End HTTP Proxy” /><EventID Qualifiers=”49152″>1003</EventID><Version>0</Version><Level>2</Level><Task>1</Task><Opcode>0</Opcode><Keywords>0x80000000000000</Keywords><TimeCreated SystemTime=”2024-04-23T07:12:25.0793088Z” /><EventRecordID>267303</EventRecordID><Correlation /><Execution ProcessID=”0″ ThreadID=”0″ /><Channel>Application</Channel><Computer>mail-server.</Computer><Security /></System><EventData><Data>Ecp</Data><Data>System.ArgumentException: Invalid input valueNome parametro: inputin Microsoft.Exchange.Data.ApplicationLogic.Cafe.BackEndServer.FromString(String input)in Microsoft.Exchange.HttpProxy.BEResourceRequestHandler.ResolveAnchorMailbox()in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.InternalBeginCalculateTargetBackEnd(AnchorMailbox& anchorMailbox)in Microsoft.Exchange.HttpProxy.ProxyRequestHandler.<BeginCalculateTargetBackEnd>b__279_0()in Microsoft.Exchange.Common.IL.ILUtil.DoTryFilterCatch(Action tryDelegate, Func`2 filterDelegate, Action`1 catchDelegate)</Data></EventData></Event> Read More
How to add attachements to new outlook programmatically?
Default Mail App – is New Outlook
Do you have any ideas to add attachement to new outlook ?
We use the following code :
protected async void SendMail(Email mail)
{
try
{
var emailMessage = new Windows.ApplicationModel.Email.EmailMessage();
emailMessage.AllowInternetImages = true;
emailMessage.To.Add(new Windows.ApplicationModel.Email.EmailRecipient(mail.Destinataire));
emailMessage.Subject = mail.Sujet;
emailMessage.Body = mail.Corps;
var stream = Windows.Storage.Streams.RandomAccessStreamReference.CreateFromFile(mail.fichier);
var attachment = new Windows.ApplicationModel.Email.EmailAttachment(fichier.Name, stream);
emailMessage.Attachments.Add(attachment);
await Windows.ApplicationModel.Email.EmailManager.ShowComposeNewEmailAsync(emailMessage);
}
catch (Exception ex)
{
}
}
Regards,
Thibaud
Hello, We have developped C# UWP application that send an email with attachement file through Courier app and its work fine). Our customers migrate from Courier to New Outlook and our programs still open New Outlook mail message with Recipient, Subject, and body, but attachement files not appears !Default Mail App – is New OutlookDo you have any ideas to add attachement to new outlook ?We use the following code : protected async void SendMail(Email mail)
{
try
{
var emailMessage = new Windows.ApplicationModel.Email.EmailMessage();
emailMessage.AllowInternetImages = true;
emailMessage.To.Add(new Windows.ApplicationModel.Email.EmailRecipient(mail.Destinataire));
emailMessage.Subject = mail.Sujet;
emailMessage.Body = mail.Corps;
var stream = Windows.Storage.Streams.RandomAccessStreamReference.CreateFromFile(mail.fichier);
var attachment = new Windows.ApplicationModel.Email.EmailAttachment(fichier.Name, stream);
emailMessage.Attachments.Add(attachment);
await Windows.ApplicationModel.Email.EmailManager.ShowComposeNewEmailAsync(emailMessage);
}
catch (Exception ex)
{
}
} Regards,Thibaud Read More
Display start and end of tasks
Hello,
If anyone can help, I have a table of tasks and a row showing days, and below that row are rows with the completion of tasks, which is marked with an “x”. How to display information in column “B” with start day and in column “C” with end day for the given task.
As an example, I am attaching a photo in which the columns in which I want to extract the information with formulas are marked in yellow, and I have given the manually entered data for the first two tasks as an example.
Thanks!
Hello,If anyone can help, I have a table of tasks and a row showing days, and below that row are rows with the completion of tasks, which is marked with an “x”. How to display information in column “B” with start day and in column “C” with end day for the given task.As an example, I am attaching a photo in which the columns in which I want to extract the information with formulas are marked in yellow, and I have given the manually entered data for the first two tasks as an example.Thanks! Read More
List Member joined/added date in MS Team/365 Groups
Other than using Graph API auditLogs, is there another API in MS Graph to find a user (member) was added to a MS Team?
I’m trying to get this info in a Power Automate flow for reporting purpose which will be in Power BI.
Other than using Graph API auditLogs, is there another API in MS Graph to find a user (member) was added to a MS Team?I’m trying to get this info in a Power Automate flow for reporting purpose which will be in Power BI. Read More
How to stop getting results from Brazil?
I keep getting results from Brazil despite never been in there, I am in Portugal which is part of Europe and the European Union!!
Why does Edge (and other MS products) insists in presenting (IRRELEVANT) results and suggestions when the region, market and system language (En-US & PT-pT) dont even match?
Its like news feed, its full of suggestions from brazilian sources, why????!!!!!
I keep getting results from Brazil despite never been in there, I am in Portugal which is part of Europe and the European Union!!Why does Edge (and other MS products) insists in presenting (IRRELEVANT) results and suggestions when the region, market and system language (En-US & PT-pT) dont even match?Its like news feed, its full of suggestions from brazilian sources, why????!!!!! Read More
Power BI Azure Maps visual – reference layer & Power BI Embedded support
Reference layer enhancements
We are thrilled to announce a major update to the Power BI Azure Maps visual reference layer, driven by our commitment to user feedback and adherence to the latest industry standards. This update significantly broadens the scope of supported data formats for the reference layer. Alongside the existing GeoJSON support, users can now incorporate data in KML (Keyhole Markup Language), WKT (Well-Known Text), and SHP (Shapefile) formats.
In a stride towards greater flexibility, we have introduced the URL option as an additional data source, complementing the traditional file upload method. This enhancement empowers users to import spatial data into Power BI with ease, regardless of whether it’s stored in GeoJSON, KML, WKT, SHP formats, or accessible via a URL. The Power BI Azure Maps visual is designed to integrate these diverse formats smoothly, offering a robust and dynamic geospatial analysis toolkit.
Power BI Embedded Support
Responding to the high demand, we’ve expanded the availability of the Azure Maps visual to Power BI Embedded, further enhancing its accessibility. Efforts are underway to extend this feature to ‘publish to web’ options as well.
The Azure Maps Power BI visual is now accessible across a variety of platforms:
Service/App
Availability
Power BI Desktop
Yes
Power BI service (app.powerbi.com)
Yes
Power BI mobile applications
Yes
Power BI publish to web
No, currently in development
Power BI Embedded
Yes
Power BI service embedding (PowerBI.com)
Yes
Azure Maps Visual Data Residency
In recognition of the critical importance of data privacy and residency for our enterprise clients, we have made significant improvements to the Azure Maps visual. Now, the visual automatically connects to the most appropriate geographic endpoints based on the user’s Power BI tenant location. For example, European tenants will have their data routed through eu.atlas.microsoft.com, in compliance with European regulations. Similarly, data for tenants in the United States will be processed within the US region via us.atlas.microsoft.com. This enhancement not only boosts user satisfaction but also ensures strict adherence to data residency regulations. For an in-depth understanding of this feature, explore Microsoft’s documentation on Azure Maps Power BI visual Data Residency and the Azure Maps service’s geographic scope.
Microsoft Tech Community – Latest Blogs –Read More
Subscriptions changes – Defender for Business
Good morning,
Any advice on how to convert subscriptions previously using E5 licenses and a combination of licenses to Defender for business?
(The change subscription option is not present on the tenants)
Sitting with the following challenges:
1) I have one client using only Business premium licenses whose Security portal only reflects as per the screenshot below. How do I change this to Defender for Business?
2) I have another client using 4 * E5 licenses and 150 * Business Premium licenses. How do I change this to Defender for Business?
Any advice will be appreciated.
Good morning, Any advice on how to convert subscriptions previously using E5 licenses and a combination of licenses to Defender for business? (The change subscription option is not present on the tenants)Sitting with the following challenges:1) I have one client using only Business premium licenses whose Security portal only reflects as per the screenshot below. How do I change this to Defender for Business?2) I have another client using 4 * E5 licenses and 150 * Business Premium licenses. How do I change this to Defender for Business? Any advice will be appreciated. Read More
Access denied, used to be public to organisation
Hi, I have recently taken over a SharePoint page for my organisation, this was set up originally by head office and hasn’t been used since. Before I was “owner” on the page I was able to view the SharePoint site with no issues. However, I was playing with permissions yesterday and I’ve broken it! Now, when others try to access they get an access denied message, if I turn on access requests then people can request access but I don’t want to have to approve everyone, I want the site to be visible for anyone within my organisation. I’ve spent about 5hrs googling trying to fix this but I have no idea what to do. PLEASE HELP! Note: I have checked the SharePoint version, it is ‘SharePoint in Microsoft 365’
Hi, I have recently taken over a SharePoint page for my organisation, this was set up originally by head office and hasn’t been used since. Before I was “owner” on the page I was able to view the SharePoint site with no issues. However, I was playing with permissions yesterday and I’ve broken it! Now, when others try to access they get an access denied message, if I turn on access requests then people can request access but I don’t want to have to approve everyone, I want the site to be visible for anyone within my organisation. I’ve spent about 5hrs googling trying to fix this but I have no idea what to do. PLEASE HELP! Note: I have checked the SharePoint version, it is ‘SharePoint in Microsoft 365’ Read More
Exchange 2019 CU 14. EAC problem Mail App Apple (Iphone, Ipda)
Hello dear friends.
I have strange problems with EAC on iphones and iPads.
The essence of the problem is that if there is an attached photo inside the body of the letter, it does not open immediately but loads for about a minute or two and only then opens, and you understand that the user is very worried at this moment.
There are no such problems on Android devices, everything works smoothly, all attachments open without delay. EAC published via MS WAP, but, i thing problem not with wap server.
Perhaps, some of you have already encountered a similar problem and can help me solve it.
Thank you.
Hello dear friends.I have strange problems with EAC on iphones and iPads. The essence of the problem is that if there is an attached photo inside the body of the letter, it does not open immediately but loads for about a minute or two and only then opens, and you understand that the user is very worried at this moment.There are no such problems on Android devices, everything works smoothly, all attachments open without delay. EAC published via MS WAP, but, i thing problem not with wap server.Perhaps, some of you have already encountered a similar problem and can help me solve it.Thank you. Read More
Error when consuming a SOAP service in APP .Net Maui only with Android emulator
I developed a .NET MAUI application to consume a SOAP service.
Testing this application on emulators on the same machine, connected to the SOAP provider via VPN, I am successful in the request when using the Windows Machine emulator and not successful when using the Android emulator.
What am I doing wrong?
I developed a .NET MAUI application to consume a SOAP service.Testing this application on emulators on the same machine, connected to the SOAP provider via VPN, I am successful in the request when using the Windows Machine emulator and not successful when using the Android emulator.What am I doing wrong? Read More
The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)
I have a problem with my Reporting Services 2012, on a Windows Server 2022 Standard.
I need Reporting Services 2012, so I installed SQL 2012,
Reporting Services – Native
Reporting Services – SharePoint
Reporting Services Add-in for SharePoint Products.
I installed all of those with a specific Windows Domain account and made the user member of the following User Groups, Administrators, ISS_IUSRS
But when I try to open the Web Service URL, or the Report Manager URL, i get this error:
The permissions granted to user ” are insufficient for performing this operation. (rsAccessDenied)
I have tried to reinstall the services, but nothing seems to help.
I have a problem with my Reporting Services 2012, on a Windows Server 2022 Standard. I need Reporting Services 2012, so I installed SQL 2012,Reporting Services – NativeReporting Services – SharePointReporting Services Add-in for SharePoint Products. I installed all of those with a specific Windows Domain account and made the user member of the following User Groups, Administrators, ISS_IUSRS But when I try to open the Web Service URL, or the Report Manager URL, i get this error:The permissions granted to user ” are insufficient for performing this operation. (rsAccessDenied)I have tried to reinstall the services, but nothing seems to help. Read More
Old Usage-Based Pricelists
Dear Community,
We are an Indirect Provider in CSP, and we are facing an issue that has its roots in the past. Based on this, we need to find past usage-based pricelists of Azure.
Does anyone of you perhaps keep historical records of the Azure prices excel as it gets published every month by Microsoft? We need the 3 Pricelist Excels published between August-October (inclusive) 2022 for charges to occur between September-November (inclusive) 2022, respectively!
We would definetely be eternally grateful if you have them! Much appreciated in advance for your help.
Best,
Nick
Dear Community,We are an Indirect Provider in CSP, and we are facing an issue that has its roots in the past. Based on this, we need to find past usage-based pricelists of Azure.Does anyone of you perhaps keep historical records of the Azure prices excel as it gets published every month by Microsoft? We need the 3 Pricelist Excels published between August-October (inclusive) 2022 for charges to occur between September-November (inclusive) 2022, respectively!We would definetely be eternally grateful if you have them! Much appreciated in advance for your help.Best,Nick Read More
Microsoft office
Do laptop n tab has its own ms office no need to purchase or subscribe?
Do laptop n tab has its own ms office no need to purchase or subscribe? Read More
copy selected fields and insert into table
Good morning, I am looking for advice on how to start with a problem I have.
I have a sheet where users input information. The data is stored in 6 rows, E7:I12 with each row being a new record.
I would like a macro which can achieve three things
1. Only copy rows where the E column is not blank
2. Copy and insert the non blank rows into a table as new rows, called TblTest
3. Copy and insert a value from cell F16, in an additional column in the tblTest along side each non blank record.
The user input information is contained on worksheet “Calc”, tbltest is in worksheet “MyTotal”
What is the best way to achieve this?
I look forward to and appreciate any assistance.
Smillie
Good morning, I am looking for advice on how to start with a problem I have. I have a sheet where users input information. The data is stored in 6 rows, E7:I12 with each row being a new record. I would like a macro which can achieve three things 1. Only copy rows where the E column is not blank2. Copy and insert the non blank rows into a table as new rows, called TblTest3. Copy and insert a value from cell F16, in an additional column in the tblTest along side each non blank record. The user input information is contained on worksheet “Calc”, tbltest is in worksheet “MyTotal” What is the best way to achieve this? I look forward to and appreciate any assistance. Smillie Read More
Release: Azure SQL Migration extension for Azure Data Studio v1.5.4
We’re delighted to announce the release of the latest version of the Azure SQL Migration extension for Azure Data Studio, v1.5.4.
This release provides you with Azure Database Migration Service’s new features like:
Single-click SHIR – download, installation, and configuration.
SKU recommendation fix for different cultural regions.
Optional Cancellation feedback
What is new in v1.5.4?
This latest version (1.5.4) of the extension supports the following features:
1) Single-click SHIR:
There are migration scenarios where you would require to download, install, and register the Self-hosted Integration runtime (SHIR) against your Azure Database Migration Service, example – when your database backup/s resides on SMB local network share, or in case of migration to target Azure SQL DB. User needs to manually perform download of the Self-hosted IR binaries, do the installation and then follow the registration steps to map it with your Azure database migration service.
Now with this feature, all the steps required for Self-hosted IR configuration will be done with a Single-click. This allows the users to choose if they want to configure the current node (running Azure Data Studio) or a remote node to be configured as a Self-hosted IR node by using PowerShell script.
The PowerShell script will take care of downloading the script, then installing it and then registering it against the Azure Database Migration Service.
Note: At present Single-Click SHIR is supported only on Azure Data Studio extension of DMS i.e. Azure SQL Migration v1.5.4 onwards.
Prerequisites:
Below are the prerequisites required for this Single-click SHIR feature –
PowerShell should be present on the machine.
Machine should have access to internet.
Permission to download and install or administrator rights are needed on the machine.
Steps:
Below are the steps you need to follow:
Once you start your migration using ADS extension – Azure SQL Migration v1.5.4 onwards, after you done with assessment and SKU recommendation, followed by Target selection and reached the step 5: Azure Database Migration Service. If you select a scenario where SHIR is required like – migration from backup location hosted on local network share or migrating to Azure SQL DB, you will be present with option of “Configure Integration Runtime” as shown below. It also shows you the current SHIR nodes registered against your selected DMS service with details like node names, Status, IP address and IR version.
Once you click on “configure Integration Runtime”, a side plane will open. Here you will get two options:
Setup SHIR on your current local machine: If you wish to setup SHIR on your current local machine, select this option and on the bottom, click Execute Script. This will open the PowerShell and start the script execution.
ii. Setup SHIR on a remote machine: If you wish to setup SHIR on your remote machine or add/register more nodes to the DMS, select the second option. Here you have two ways to proceed:
Save the script and move it to the desired remote machine and open the PowerShell, and then execute it.
Follow manual steps given on the side plane and download, install and register the SHIR using either of the Authentication Keys.
You can monitor progress on PowerShell window. Once complete, you can go back to the ADS extension – Azure SQL Migration and refresh the SHIR nodes to view the newly added nodes.
Learn more:
Create a self-hosted integration runtime – Azure Data Factory & Azure Synapse | Microsoft Learn
Migrate databases by using the Azure SQL Migration extension for Azure Data Studio | Microsoft Learn
2) SKU recommendation fix for different cultural region:
Every region has its own standard and convention for representing numbers. Similarly decimal point representation varies from region to region, example: frequently used decimal separator are the comma (, U+002C) and the dot (. U+002E).
This fix allows to correctly present and parse the decimal point separation based upon the region. Hence presenting the SKU recommendation data in the correct format.
Refer: Format numbers – Globalization | Microsoft Learn
3) Cancellation feedback:
Now user can provide feedback (optional) while cancelling the Azure data studio’s extension – Azure SQL migration session or migration. Users can now provide the reason for the cancellation of the current migration.
Resources
For more information about the extension and Azure Database Migration Service, see the following resources.
Azure Database Migration Service documentation
Migrate databases using the Azure SQL Migration extension
One-click SQL Migration PoC environment
Microsoft Tech Community – Latest Blogs –Read More
Comparing multiple cells, if one cell has value, then name this cell another cell
Hi All,
I am tracking manufacturing of items for a project. I have multiple variations of the same object.
Example: I allocate which office cubicle is needing a particular type of filing cabinet. (one drawer, two drawer, three drawer etc, is needed for “Office A”).
I am needing to create a formula to check a row of cells, whichever one of these has a value of “1”, then pull the name of a corresponding cell.
The reason I do this is so on other worksheets, when manufacturing the filing cabinets, it lists the needed cabinet, which I determine if I need to pull from inventory, fabricate or purchase. (I also track the various components and object manufacturing status.)
The name of the object can change, so I wish for the ability to name the cells in green.
I have screen captured what I am intending. The formula I am looking for (in layman’s terms)
Check cells C5, D5, E5, F5, G5. If any of these =1. Then Name cell B5 as the Text based cell I select.
Any assistance would be appreciated.
Hi All,I am tracking manufacturing of items for a project. I have multiple variations of the same object. Example: I allocate which office cubicle is needing a particular type of filing cabinet. (one drawer, two drawer, three drawer etc, is needed for “Office A”). I am needing to create a formula to check a row of cells, whichever one of these has a value of “1”, then pull the name of a corresponding cell. The reason I do this is so on other worksheets, when manufacturing the filing cabinets, it lists the needed cabinet, which I determine if I need to pull from inventory, fabricate or purchase. (I also track the various components and object manufacturing status.) The name of the object can change, so I wish for the ability to name the cells in green. I have screen captured what I am intending. The formula I am looking for (in layman’s terms)Check cells C5, D5, E5, F5, G5. If any of these =1. Then Name cell B5 as the Text based cell I select. Any assistance would be appreciated. Read More