We have been frequently receiving alerts regarding the Mellanox ConnectX-4 Lx Virtual Ethernet Adapter being disabled and re-enabled within a short time span. The alert is triggered each time the adapter is disabled and then enabled, causing unnecessary noise in the system.

Specifically, the current alert triggers too quickly, and I would like to adjust the alert configuration to wait for a longer period before triggering. Ideally, the system should monitor the NIC adapter’s status and only generate an alert if the adapter remains disabled for a longer period of time. If it is re-enabled within the adjusted time frame, the alert should not be triggered.

I have checked the rules and overrides in the System Center Operations Manager (SCOM) but couldn’t find any option to modify the time interval for triggering the alert. Below is a sample of the alert details:

Alert Information:
Mellanox ConnectX-4 Lx Virtual Ethernet Adapter device is successfully stopped.

SCOM Data:
AlertId: b4456b37-5b12-4b56-9e1e-779ec6cccd6c
RuleId: 2f840cdd-71b6-05b4-da8e-9cb1a5b124d4
MonitorName: Microsoft.Windows.Server.10.0.Storage.StorageSpacesDirect.BadBlock
MonitorDisplayName: SCOM S2D: The Device has a Bad Block
Management Pack: Storage Spaces Direct Management Pack:1.0.47.4
MonitoringObjectDisplayName: ABCCCC.Domain.com
MonitoringObjectFullName: Microsoft.Windows.Computer

.Domain.com

​We have been frequently receiving alerts regarding the Mellanox ConnectX-4 Lx Virtual Ethernet Adapter being disabled and re-enabled within a short time span. The alert is triggered each time the adapter is disabled and then enabled, causing unnecessary noise in the system.Specifically, the current alert triggers too quickly, and I would like to adjust the alert configuration to wait for a longer period before triggering. Ideally, the system should monitor the NIC adapter’s status and only generate an alert if the adapter remains disabled for a longer period of time. If it is re-enabled within the adjusted time frame, the alert should not be triggered.I have checked the rules and overrides in the System Center Operations Manager (SCOM) but couldn’t find any option to modify the time interval for triggering the alert. Below is a sample of the alert details:Alert Information:Mellanox ConnectX-4 Lx Virtual Ethernet Adapter device is successfully stopped.SCOM Data:AlertId: b4456b37-5b12-4b56-9e1e-779ec6cccd6cRuleId: 2f840cdd-71b6-05b4-da8e-9cb1a5b124d4MonitorName: Microsoft.Windows.Server.10.0.Storage.StorageSpacesDirect.BadBlockMonitorDisplayName: SCOM S2D: The Device has a Bad BlockManagement Pack: Storage Spaces Direct Management Pack:1.0.47.4MonitoringObjectDisplayName: ABCCCC.Domain.comMonitoringObjectFullName: Microsoft.Windows.Computer .Domain.com   Read More

​

Hi, does anyone have any ideas on how I could reference/link values which occur in text >255 characters. e.g  below, I would like to link the figures and years quoted below to an input sheet.

The net profit for the year after tax is R999 million for the group and R777 million for the company (2022: R800 million for the group and R600 million for the company). The tax amounts to R99 million for the group and R77 million for the company (2022: R80 million for the group and R60 million for the company).

​Hi, does anyone have any ideas on how I could reference/link values which occur in text >255 characters. e.g  below, I would like to link the figures and years quoted below to an input sheet. The net profit for the year after tax is R999 million for the group and R777 million for the company (2022: R800 million for the group and R600 million for the company). The tax amounts to R99 million for the group and R77 million for the company (2022: R80 million for the group and R60 million for the company).  Read More

​

I have a folder with thousands of files all of which have different extensions.  I need to change all the extensions to “jpg” and looked at Rename and replace, but since every extension is different I cannot provide all for the replace function.  Sounds weird but the files were produced by a vendors application and all extensions are numeric, “001”, “002”, “003” and on.  

Any help would be appreciated.

​I have a folder with thousands of files all of which have different extensions.  I need to change all the extensions to “jpg” and looked at Rename and replace, but since every extension is different I cannot provide all for the replace function.  Sounds weird but the files were produced by a vendors application and all extensions are numeric, “001”, “002”, “003” and on.  Any help would be appreciated.  Read More

​

While connecting to Sharepoint 2019 On Premises using app only authentication specifying sharepoint url, client id and client secret but getting issue provided below

Error Message: The remote server returned an error: (400) Bad Request. – {“error”:”invalid_request”,”error_description”:”AADSTS90002: Tenant ‘xxxxxx’ not found. Check to make sure you have the correct tenant ID and are signing into the correct cloud. Check with your subscription administrator, this may happen if there are no active subscriptions for the tenant. Trace ID: xxxxxx Correlation ID: xxxxxx Timestamp: 2024-09-13 14:47:27Z”,”error_codes”:[90002],”timestamp”:”2024-09-13 14:47:27Z”,”trace_id”:”xxxxxx”,”correlation_id”:”xxxxxx”,”error_uri”:”https://accounts.accesscontrol.windows.net/error?code=90002“}
Inner Exception: The remote server returned an error: (400) Bad Request.

​While connecting to Sharepoint 2019 On Premises using app only authentication specifying sharepoint url, client id and client secret but getting issue provided below Error Message: The remote server returned an error: (400) Bad Request. – {“error”:”invalid_request”,”error_description”:”AADSTS90002: Tenant ‘xxxxxx’ not found. Check to make sure you have the correct tenant ID and are signing into the correct cloud. Check with your subscription administrator, this may happen if there are no active subscriptions for the tenant. Trace ID: xxxxxx Correlation ID: xxxxxx Timestamp: 2024-09-13 14:47:27Z”,”error_codes”:[90002],”timestamp”:”2024-09-13 14:47:27Z”,”trace_id”:”xxxxxx”,”correlation_id”:”xxxxxx”,”error_uri”:”https://accounts.accesscontrol.windows.net/error?code=90002″}Inner Exception: The remote server returned an error: (400) Bad Request.  Read More

​

Hi everyone, I’ve been messing with Azure OpenAI for a few days and find it pretty cool.  One issue I have though is I will give it example prompts, and fill in the “Give the model instructions and context” section which works great, but when you add a data source like Azure Blob, it ONLY uses that and ignores all instructions.

I have “limit responses to your data content” under data source disabled.

Is this normal behaviour?

The second issue is that even with this unchecked above, it still only responds based on the documents.  For example, I’ll ask about a product and it responds based on my documents.  I’ll then ask if a competitor company also offers this product, and it will say that it doesn’t know as that wasn’t found in the documents.  I tell it to search online and it says it’s not capable of searching online and can only provide information based on the documents I’ve provided.”

Just a bit confused by that since using ChatGPT directly would have answered that question.

My goal is to have it be a general AI like ChatGPT, as in, it will answer general questions, but ALSO reference our documents.  Is that not possible, like is it one or the other?

​Hi everyone, I’ve been messing with Azure OpenAI for a few days and find it pretty cool.  One issue I have though is I will give it example prompts, and fill in the “Give the model instructions and context” section which works great, but when you add a data source like Azure Blob, it ONLY uses that and ignores all instructions. I have “limit responses to your data content” under data source disabled. Is this normal behaviour? The second issue is that even with this unchecked above, it still only responds based on the documents.  For example, I’ll ask about a product and it responds based on my documents.  I’ll then ask if a competitor company also offers this product, and it will say that it doesn’t know as that wasn’t found in the documents.  I tell it to search online and it says it’s not capable of searching online and can only provide information based on the documents I’ve provided.” Just a bit confused by that since using ChatGPT directly would have answered that question. My goal is to have it be a general AI like ChatGPT, as in, it will answer general questions, but ALSO reference our documents.  Is that not possible, like is it one or the other?  Read More

​

Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I want to do some further analysis of bikes for my (fictional) company. At the request of some, I have attached the workbook I used for this and previous posts.

Bike sales table showing columns for Year, Category, Product, Sales and Rating.

I’d like to dive deeper into the ratings for bike products. I ask copilot:

chart ratings by year for bikes

Copilot in Excel pane showing the above prompt and a chart showing the average rating of bikes for the years 2015-2017.

The ratings are poor and I’d like to expand to the product level, so I ask Copilot:

now show ratings by year by product for the bikes category

Copilot in Excel pane showing a chart of ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.

I click on the Add to a new sheet button in the pane and the following is inserted into a new sheet:

Excel PivotTable and Chart showing ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.

All products improved for 2017, but ratings for Touring bikes are very low.

Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I want to do some further analysis of bikes for my (fictional) company. At the request of some, I have attached the workbook I used for this and previous posts.
Bike sales table showing columns for Year, Category, Product, Sales and Rating.
 
I’d like to dive deeper into the ratings for bike products. I ask copilot:
chart ratings by year for bikes
 
Copilot in Excel pane showing the above prompt and a chart showing the average rating of bikes for the years 2015-2017.
 
The ratings are poor and I’d like to expand to the product level, so I ask Copilot:
now show ratings by year by product for the bikes category
 
Copilot in Excel pane showing a chart of ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.
 
I click on the Add to a new sheet button in the pane and the following is inserted into a new sheet:
 
Excel PivotTable and Chart showing ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.
 
All products improved for 2017, but ratings for Touring bikes are very low.
 
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​

I print a set of forms monthly for hand completion by about 40 building sites. Each form is identical but for Site names and codes and foreman names, which can require editing each month; and the week-ending date for which the from will be used. Forms are printed monthly, either four or five week’s worth, meaning a workbook with four or five sheets, depending on how many weeks are in that reporting month. This there can be 200 forms per month to be printed and sent out.

Previously, each sheet within each workbook was revised manually, and printed by manual instruction.

I now update any site information via a separate single data entry file; likewise the date, which I carry though to subsequent weeks’ sheets using “date + 7”.

I still have a number of areas where it can be improved:

1) If I insert a line into my data entry file then it displaces those below it so that the cell reference used in a given form becomes incorrect.

2) I haven’t been able to print all thirty workbooks automatically, because Excel’s default print setting is “Print Active Sheets” rather than “Print Entire Workbook”. So, I can highlight the required files from the File Directory but when I do, only the first sheet in the workbook for each file gets printed.

My aim is to make all monthly revisions by means of a single data entry file, and to automate printing of all workbooks together. There are other forms we print for monthly hand-completion that could benefit in the same way. 

​I print a set of forms monthly for hand completion by about 40 building sites. Each form is identical but for Site names and codes and foreman names, which can require editing each month; and the week-ending date for which the from will be used. Forms are printed monthly, either four or five week’s worth, meaning a workbook with four or five sheets, depending on how many weeks are in that reporting month. This there can be 200 forms per month to be printed and sent out. Previously, each sheet within each workbook was revised manually, and printed by manual instruction. I now update any site information via a separate single data entry file; likewise the date, which I carry though to subsequent weeks’ sheets using “date + 7”. I still have a number of areas where it can be improved: 1) If I insert a line into my data entry file then it displaces those below it so that the cell reference used in a given form becomes incorrect. 2) I haven’t been able to print all thirty workbooks automatically, because Excel’s default print setting is “Print Active Sheets” rather than “Print Entire Workbook”. So, I can highlight the required files from the File Directory but when I do, only the first sheet in the workbook for each file gets printed. My aim is to make all monthly revisions by means of a single data entry file, and to automate printing of all workbooks together. There are other forms we print for monthly hand-completion that could benefit in the same way.     Read More

​

In this blog series dedicated to Microsoft’s technical articles, we’ll highlight our MVPs’ favorite article along with their personal insights.

Pratheep Sinnathurai, Microsoft Azure MVP, Switzerland

Azure Arc overview – Azure Arc | Microsoft Learn

“I always compare Azure Arc to the Lord of the Rings, seeing it as the one ring to rule them all. If you’re seeking a solution to manage all your Windows and Linux servers, Azure Arc could be the answer. It provides a unified management experience across diverse environments, whether on-premises, in Azure, or other clouds.

Using Azure Arc, I’ve also gained valuable insights into other technologies, such as Kubernetes (AKS) and AWS, through its Multi-Cloud Connector. This feature enhances your ability to manage and govern resources across multiple cloud platforms seamlessly.

In essence, if you’re looking for a comprehensive solution to manage your hybrid and multi-cloud infrastructure efficiently, Azure Arc offers the tools and capabilities you need.”

*Relevant Blog: In my blog post I explained how to use pre and post events fro Azure Update Manager on Azure Arc Enabled Servers.

Using Pre and Post events from Azure Update Manager on Azure Arc-Enabled Windows Server | by Pratheep Sinnathurai | Medium

Elton Bordim, Microsoft Azure MVP, Brazil

Bring Azure innovation to your hybrid environments with Azure Arc – Training | Microsoft Learn

“This content is comprehensive, helping with the solution support of Azure Arc and the supported resources. Understanding how to innovate with Azure Arc is essential nowadays, and by contributing Azure Arc content to the community, without a doubt, this training is the one I most like to recommend.”

*Relevant Activities:

– Blog: Encerramento da série: Azure Arc para iniciantes – Elton Bordim – MCT | AZ-104 | AZ-305 | SC-200 | AZ-800 e 801

– Video: Azure Arc – YouTube

Joe Carlyle, Microsoft Azure MVP, Ireland

Networking architecture design – Azure Architecture Center | Microsoft Learn

“Networking is core to Azure, and core to architecting excellent solutions. While the architecture center offers a range of guidance from foundational to niche, the networking section should be common to nearly all deployments. It is unique in its importance to Azure design.”

*Relevant Blog: A lot of my content would relate to Azure Networking, and I do have a recent blog highlighting this area – Exploring – Network Design in the Azure Architecture Center – wedoAzure

Luke Murray, Microsoft Azure MVP, New Zealand

Design review checklist for Reliability – Microsoft Azure Well-Architected Framework | Microsoft Learn

“Hyperscaler Cloud offerings, like Microsoft Azure, offer businesses worldwide to compete on a global stage, but with the ability to scale up business offerings comes more complexity and additional risk of outages. One of the key pillars (for good reason) of the Azure Well-Architected Framework is Resiliency, and Microsoft Learn offers a great way of checking off, using a data-validated approach, of not only your Resiliency at a Technical level, but Business as well, using resources, such as the Design review checklist for Reliability.”

*Relevant Blog: Running your own Azure Proactive Resiliency Assessment | luke.geek.nz

​Microsoft Tech Community – Latest Blogs –Read More 

On 15th September the build I have now installed will expire. But windows update can’t download the new version. it has been 0% for more than two weeks.

​On 15th September the build I have now installed will expire. But windows update can’t download the new version. it has been 0% for more than two weeks.    Read More

​

Among the Word templates is one for name tag labels.  Unfortunately, it provides for only 8 labels per page and therefore does not accord to the Avery shipping label (J8163) that you would use.  It permits 10 labels.  And I see no way to use the label template to prepare labels using the label tool under Mailing.  Any suggestions?

​Among the Word templates is one for name tag labels.  Unfortunately, it provides for only 8 labels per page and therefore does not accord to the Avery shipping label (J8163) that you would use.  It permits 10 labels.  And I see no way to use the label template to prepare labels using the label tool under Mailing.  Any suggestions?  Read More

​