I work in the NHS as an admin for a country wide network.

We add users from accross the United Kingdom into Teams Channels we have created for cross-working.

I have come accross an issue where when trying to add a user to a Teams channel (Created in Manchester, I am the owner) I recieve an error saying 0 of 1 members were added, there was an error.

My colleague (also an owner) can’t add them either but when accessing MS Teams on their phone app can see that the individual is already added to the channel, but can’t see them in desktop.

The user cannot access the Teams channel and when either trying to switch accounts to Manchester University (where the channel is accessible for all other users) or following a link to the channel they receive an error stating their log in credentials are invalid and their account is locked.

I haved tried reaching out to our IT team and they are unable to assist, any ideas on what could be causing the issue?

Thanks

​I work in the NHS as an admin for a country wide network.We add users from accross the United Kingdom into Teams Channels we have created for cross-working.I have come accross an issue where when trying to add a user to a Teams channel (Created in Manchester, I am the owner) I recieve an error saying 0 of 1 members were added, there was an error.My colleague (also an owner) can’t add them either but when accessing MS Teams on their phone app can see that the individual is already added to the channel, but can’t see them in desktop.The user cannot access the Teams channel and when either trying to switch accounts to Manchester University (where the channel is accessible for all other users) or following a link to the channel they receive an error stating their log in credentials are invalid and their account is locked.I haved tried reaching out to our IT team and they are unable to assist, any ideas on what could be causing the issue?Thanks    Read More

​

Hi all,

I have two doubts I would like to share to the wider community for help. I am trying to enable multiple dependent drop-down forms with multiple selections (combining some VBA code) to collect some data. Nonetheless, I am facing two issues when doing so.

I have a drop-down in which you can select from 1 to 9 options. This should trigger a second drop-down based on the concatenated sub-categories made in those selections on the next column (e.g.: If you selected “fish” and “vegetables”; in the next column you should have all fishes and all vegetables inside the dropdown [mackerel, salmon, cucumber, spinach]). This, which can be intuitive, has been a nightmare on the backend:I had to go to a programming language (R in my case) to create all the different 511 possible combinations of items from the selections, putting all titles alphabetically ordered and in named_ranges style.I pasted that creation to Excel, the 511 different named ranges and automatically created a formula for crafting 511 named ranges taking into account the different lengths.Finally, I created on the main table a helper column ordering the first selection alphabetically (with yet again another VBA formula) so that I could match with =INDIRECT(“helper_column_cell”) the different possible concatentations. A long journey given the fact I did not see a way to seamlessly join different named ranges…A second issue has to do with the multiple selection. I achieved having the dropdown with the right data depending on the first 1 to 9 combinations input; enabling me to select multiple items from the resulting list, concatenating them with commas and not allowing repetitions. Nonetheless, each input requires reopening the drop-down again, and I would like that to be done in one shot. I thought about a user form, but it looks as adapting the options to the 511 possible combinations is dreamland. Below you see the code I do have for now:Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDataMapping As Range
Dim Oldvalue As String
Dim Newvalue As String
Dim arr() As String
Dim Output As String
Dim i As Integer

‘ Set the range for the multiple drop-down (columns O and R in this case)
Set rngDataMapping = Intersect(Me.Range(“O:O, R:R, S:S”), Target)

If Not rngDataMapping Is Nothing Then
Application.EnableEvents = False
On Error GoTo Exitsub
If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then GoTo Exitsub Else
If Target.Value = “” Then GoTo Exitsub Else
Application.Undo
Oldvalue = Target.Value
Application.Undo
Newvalue = Target.Value

‘ Check if the new value already exists
If InStr(1, Oldvalue, Newvalue) = 0 Then
If Oldvalue = “” Then
Target.Value = Newvalue
Else
arr = Split(Oldvalue, “, “)
Output = “”
For i = LBound(arr) To UBound(arr)
If arr(i) <> Newvalue Then
If Output = “” Then
Output = arr(i)
Else
Output = Output & “, ” & arr(i)
End If
End If
Next i
If Output = “” Then
Output = Newvalue
Else
Output = Newvalue & “, ” & Output
End If
Target.Value = Output
End If
End If
End If

Exitsub:
Application.EnableEvents = True
Exit Sub
End Sub

Do you have any recommendation on better and more efficient solutions to Problem 1? Is there any way to sort out the issue on problem 2 to allow the users to do multiple selections without the drop-down collapsing with any new input? I would really appreciate your mastery and comments!

​Hi all, I have two doubts I would like to share to the wider community for help. I am trying to enable multiple dependent drop-down forms with multiple selections (combining some VBA code) to collect some data. Nonetheless, I am facing two issues when doing so. I have a drop-down in which you can select from 1 to 9 options. This should trigger a second drop-down based on the concatenated sub-categories made in those selections on the next column (e.g.: If you selected “fish” and “vegetables”; in the next column you should have all fishes and all vegetables inside the dropdown [mackerel, salmon, cucumber, spinach]). This, which can be intuitive, has been a nightmare on the backend:I had to go to a programming language (R in my case) to create all the different 511 possible combinations of items from the selections, putting all titles alphabetically ordered and in named_ranges style.I pasted that creation to Excel, the 511 different named ranges and automatically created a formula for crafting 511 named ranges taking into account the different lengths.Finally, I created on the main table a helper column ordering the first selection alphabetically (with yet again another VBA formula) so that I could match with =INDIRECT(“helper_column_cell”) the different possible concatentations. A long journey given the fact I did not see a way to seamlessly join different named ranges…A second issue has to do with the multiple selection. I achieved having the dropdown with the right data depending on the first 1 to 9 combinations input; enabling me to select multiple items from the resulting list, concatenating them with commas and not allowing repetitions. Nonetheless, each input requires reopening the drop-down again, and I would like that to be done in one shot. I thought about a user form, but it looks as adapting the options to the 511 possible combinations is dreamland. Below you see the code I do have for now:Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDataMapping As Range
Dim Oldvalue As String
Dim Newvalue As String
Dim arr() As String
Dim Output As String
Dim i As Integer

‘ Set the range for the multiple drop-down (columns O and R in this case)
Set rngDataMapping = Intersect(Me.Range(“O:O, R:R, S:S”), Target)

If Not rngDataMapping Is Nothing Then
Application.EnableEvents = False
On Error GoTo Exitsub
If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then GoTo Exitsub Else
If Target.Value = “” Then GoTo Exitsub Else
Application.Undo
Oldvalue = Target.Value
Application.Undo
Newvalue = Target.Value

‘ Check if the new value already exists
If InStr(1, Oldvalue, Newvalue) = 0 Then
If Oldvalue = “” Then
Target.Value = Newvalue
Else
arr = Split(Oldvalue, “, “)
Output = “”
For i = LBound(arr) To UBound(arr)
If arr(i) <> Newvalue Then
If Output = “” Then
Output = arr(i)
Else
Output = Output & “, ” & arr(i)
End If
End If
Next i
If Output = “” Then
Output = Newvalue
Else
Output = Newvalue & “, ” & Output
End If
Target.Value = Output
End If
End If
End If

Exitsub:
Application.EnableEvents = True
Exit Sub
End SubDo you have any recommendation on better and more efficient solutions to Problem 1? Is there any way to sort out the issue on problem 2 to allow the users to do multiple selections without the drop-down collapsing with any new input? I would really appreciate your mastery and comments!  Read More

​

For an inventory script, I use servicePrincipals?$expand=appRoleAssignedTo to get all serviceprinciples including “approleassignedTo” info.

To make an inventory of the approle assignments, I loop through all apps (~2250) and for each app, I loop through approles, and foreach approle I loop through appRoleAssignedTo data.

In my environment this results in ~3000 approle assignments.

When I analyze the result, I estimate 5% of role assignments are missing.
I do see all roles, just not all roleassignments. When I look up a missing assignments in the Entra portal I do see them.
The missing role assignment aren’t special, they are assigned to normal Entra ID groups like other assigned approles.

When I rerun the script, the same assignments are missing each time.

When I don’t use $expand query parameter, but query the data directly using ‘servicePrincipals/{id}/appRoleAssignedTo’, I do get all assignments.

Did I run into a bug?

​For an inventory script, I use servicePrincipals?$expand=appRoleAssignedTo to get all serviceprinciples including “approleassignedTo” info.To make an inventory of the approle assignments, I loop through all apps (~2250) and for each app, I loop through approles, and foreach approle I loop through appRoleAssignedTo data.In my environment this results in ~3000 approle assignments. When I analyze the result, I estimate 5% of role assignments are missing.I do see all roles, just not all roleassignments. When I look up a missing assignments in the Entra portal I do see them.The missing role assignment aren’t special, they are assigned to normal Entra ID groups like other assigned approles. When I rerun the script, the same assignments are missing each time. When I don’t use $expand query parameter, but query the data directly using ‘servicePrincipals/{id}/appRoleAssignedTo’, I do get all assignments. Did I run into a bug?  Read More

​

Ihor Zahorodnii 

Microsoft Azure Tools for FinOps:

Microsoft Azure offers a variety of tools that can help you implement FinOps principles and practices in your organization. These tools can help you gain visibility into your cloud costs enforce policies and standards, analyze and report on your spending patterns, optimize your resource utilization, communicate and collaborate with your stakeholders, and learn and improve your cloud skills. Here are some of the tools that I recommend:

Microsoft Cost Management: Monitor, allocate, and optimize your Azure costs with this powerful tool. You can track your spending by various dimensions such as resource group, subscription, service type, location, tag, or any other dimension. You can also create budgets and alerts to manage your spending limits and thresholds. You can also generate reports and dashboards to visualize and share your cost data with others.

Azure Policy: Enforce rules and standards for your Azure resources with this useful tool. You can create policies that define what actions are allowed or denied for your resources based on criteria such as location, size, type, tag, or configuration. You can also audit your compliance status and remediate any violations.

Microsoft Power BI: Analyze and report on your Azure data with this great tool. You can connect to various data sources such as the Cost Management Connector, which provides access to your cost and usage data from Cost Management, or the Azure Retail Prices REST API, which provides access to the retail prices of Azure services. You can use these data sources to create interactive reports and dashboards to explore and visualize your data. You can also share your insights and collaborate with others using Power BI.

Azure Monitor Workbooks: Create custom visualizations and dashboards for your Azure data with this handy tool. You can combine text, metrics, logs, queries and parameters to create rich and interactive reports. You can also use it to troubleshoot issues, perform root cause analysis, and optimize your performance.

Microsoft Teams: Communicate and collaborate with your teams and stakeholders with this tool. You can chat, call, meet, and share files and documents with others. You can also integrate with other Azure tools such as Cost Management, Power BI, Monitor Workbooks, Advisor, or Learning paths, and access them from within Teams.

Azure Advisor: Optimize your Azure resources and reduce your costs with this tool. It provides personalized recommendations based on your usage and configuration data. It also helps you improve your performance, security, reliability, and operational excellence.

Microsoft Azure Learning paths: Learn and improve your Azure skills with this tool. It provides curated collections of online courses, videos, labs, quizzes, and certifications that cover various topics and levels of Azure. You can use it to gain the knowledge and expertise you need to implement FinOps in Azure.
Well-Architected Review: Assess your Azure workloads and identify areas for improvement with this tool. It provides a framework of best practices and principles that cover five pillars: cost optimization, operational excellence, performance efficiency, reliability, and security. You can use it to evaluate your current state, identify gaps and risks, and prioritize actions.

Azure savings offers: Save money on your Azure spending with these tools. They include Reservations, Compute Savings Plan, Hybrid Benefit and other discounts and incentives that you can take advantage of to lower your cloud costs.

​Ihor Zahorodnii  Microsoft Azure Tools for FinOps:Microsoft Azure offers a variety of tools that can help you implement FinOps principles and practices in your organization. These tools can help you gain visibility into your cloud costs enforce policies and standards, analyze and report on your spending patterns, optimize your resource utilization, communicate and collaborate with your stakeholders, and learn and improve your cloud skills. Here are some of the tools that I recommend:Microsoft Cost Management: Monitor, allocate, and optimize your Azure costs with this powerful tool. You can track your spending by various dimensions such as resource group, subscription, service type, location, tag, or any other dimension. You can also create budgets and alerts to manage your spending limits and thresholds. You can also generate reports and dashboards to visualize and share your cost data with others.Azure Policy: Enforce rules and standards for your Azure resources with this useful tool. You can create policies that define what actions are allowed or denied for your resources based on criteria such as location, size, type, tag, or configuration. You can also audit your compliance status and remediate any violations.Microsoft Power BI: Analyze and report on your Azure data with this great tool. You can connect to various data sources such as the Cost Management Connector, which provides access to your cost and usage data from Cost Management, or the Azure Retail Prices REST API, which provides access to the retail prices of Azure services. You can use these data sources to create interactive reports and dashboards to explore and visualize your data. You can also share your insights and collaborate with others using Power BI.Azure Monitor Workbooks: Create custom visualizations and dashboards for your Azure data with this handy tool. You can combine text, metrics, logs, queries and parameters to create rich and interactive reports. You can also use it to troubleshoot issues, perform root cause analysis, and optimize your performance.Microsoft Teams: Communicate and collaborate with your teams and stakeholders with this tool. You can chat, call, meet, and share files and documents with others. You can also integrate with other Azure tools such as Cost Management, Power BI, Monitor Workbooks, Advisor, or Learning paths, and access them from within Teams.Azure Advisor: Optimize your Azure resources and reduce your costs with this tool. It provides personalized recommendations based on your usage and configuration data. It also helps you improve your performance, security, reliability, and operational excellence.Microsoft Azure Learning paths: Learn and improve your Azure skills with this tool. It provides curated collections of online courses, videos, labs, quizzes, and certifications that cover various topics and levels of Azure. You can use it to gain the knowledge and expertise you need to implement FinOps in Azure.Well-Architected Review: Assess your Azure workloads and identify areas for improvement with this tool. It provides a framework of best practices and principles that cover five pillars: cost optimization, operational excellence, performance efficiency, reliability, and security. You can use it to evaluate your current state, identify gaps and risks, and prioritize actions.Azure savings offers: Save money on your Azure spending with these tools. They include Reservations, Compute Savings Plan, Hybrid Benefit and other discounts and incentives that you can take advantage of to lower your cloud costs.  Read More

​

When working with a large, multi-sheet Excel workbook on MacBook Pro (M1), I started encountering a strange issue when inserting rows on one of the worksheets. What happens is that some formulas “slip” or “miss” their intended references after some row insertion/deletion (not those rows having any relation to the affected formulas or references).

In my case the formulas mistakenly referenced a different row, often one row above the original target row. It is as if Excel is confused by (multiple) row deletions or insertions. 

Even worse – it was NOT possible to “undo” the action. I made a couple of tests with insert row actions. I could detect the exact moment it happens (in my case, the circular reference occurred because of the reference slip), but no “undo” could fix it. (I had to start from the last saved version, which I paranoiacally make every 15 min or so … luckily).

This makes the whole thing unusable. I took the same excel file and continued working on Windows – it doesn’t happen there.

Anyone had anything similar ever happen with Excel (on Mac)? 

​When working with a large, multi-sheet Excel workbook on MacBook Pro (M1), I started encountering a strange issue when inserting rows on one of the worksheets. What happens is that some formulas “slip” or “miss” their intended references after some row insertion/deletion (not those rows having any relation to the affected formulas or references). In my case the formulas mistakenly referenced a different row, often one row above the original target row. It is as if Excel is confused by (multiple) row deletions or insertions.  Even worse – it was NOT possible to “undo” the action. I made a couple of tests with insert row actions. I could detect the exact moment it happens (in my case, the circular reference occurred because of the reference slip), but no “undo” could fix it. (I had to start from the last saved version, which I paranoiacally make every 15 min or so … luckily). This makes the whole thing unusable. I took the same excel file and continued working on Windows – it doesn’t happen there. Anyone had anything similar ever happen with Excel (on Mac)?   Read More

​

​ Vú đẹp là mong ước của hầu hết tất cả các chị em. Để sở hữu khuôn ngực đầy đặn, căng tròn, quyến rũ để có vóc dáng thêm tự tin. Khi có cặp vú đẹp, việc lựa chọn áo đồ trở nên dễ dàng hơn. Những bộ váy hoặc áo đầm dáng vừa sẽ làm nổi bật và tôn lên vóc dáng thanh mảnh.  Vú đẹp là cách chỉ những chị em có vòng 1 căng tràn, tròn trịa, quyến rũ, có độ cong hoàn hảo, cân đối với vóc dáng giúp các nàng thêm phần hấp dẫnproseovip  Read More

​

Our Defender reports that the Intel iCLS driver uses an outdated and unsafe OpenSSL version.

After contacting Intel they told me to update to version 1.72.189.0.

I can find (and manually install) this driver at the MS catalog (https://www.catalog.update.microsoft.com/Search.aspx?q=intel%20icls%20windows%2011%20%201.72.189.0) but I do not whish to roll out a driver this way to 250+ devices.
The releasedate is march 7th. There are 5 files from 4 different companies (non of which is the manufacturer of my device (Dell))
My question is why the update is not pushed through Windows Update. I this something Microsoft should do or should I pressure Dell?

​Our Defender reports that the Intel iCLS driver uses an outdated and unsafe OpenSSL version.After contacting Intel they told me to update to version 1.72.189.0.I can find (and manually install) this driver at the MS catalog (https://www.catalog.update.microsoft.com/Search.aspx?q=intel%20icls%20windows%2011%20%201.72.189.0) but I do not whish to roll out a driver this way to 250+ devices.The releasedate is march 7th. There are 5 files from 4 different companies (non of which is the manufacturer of my device (Dell))My question is why the update is not pushed through Windows Update. I this something Microsoft should do or should I pressure Dell?  Read More

​