Month: August 2024
Help reformatting schedule template
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.
1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).
2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.
-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.
3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.
-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.
-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank.
4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings.
Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.
If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated?
Sorry this is a lot of info and hopefully makes sense.
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank. 4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings. Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated? Sorry this is a lot of info and hopefully makes sense. Read More
Is there a way to speed up this looped code
Hi all,
I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop.
I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible.
I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet.
Any assistance would be appreciated.
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell
Hi all, I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop. I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible. I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet. Any assistance would be appreciated. Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell Read More
Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Conditional Access Policy Block Downloads (Preview)
Hello Community,
I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.
Here’s the situation:
Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.
Problem:
In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.
I’ve tried the following troubleshooting steps:
Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.
Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.
Has anyone encountered this issue before, or does anyone have suggestions for resolving this?
Thanks in advance for your help!
Hello Community,I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.Here’s the situation:Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.Problem:In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.I’ve tried the following troubleshooting steps:Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.Has anyone encountered this issue before, or does anyone have suggestions for resolving this?Thanks in advance for your help! Read More
Connection error popup low virtual memory
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources.
Remote Desktop
This computer can’t connect to the remote computer.
The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support.
Joe
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources. Remote DesktopThis computer can’t connect to the remote computer.The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support. Joe Read More
Teams left toolbar menu apps not showing
Hello guys,
Since today afternoon 29/08/2024 i have some issues with Teams left toolbar.
This is how it appear
And these are my configuration settings set by policy
As u can see my menu it’s completely messed up, and until yesterday night was ok… now i have tried to modify and apply config but nothing changes…
Any idea?
Versione
Hello guys,Since today afternoon 29/08/2024 i have some issues with Teams left toolbar. This is how it appearAnd these are my configuration settings set by policyAs u can see my menu it’s completely messed up, and until yesterday night was ok… now i have tried to modify and apply config but nothing changes… Any idea?VersioneHai la versione di Microsoft Teams 24215.1007.3082.1590.È stata ricevuta la versione più recente. È stato controllato l’ultima volta in data 29/08/2024.La versione client è 49/24080212008.Accesso in anteprima Read More
TSI Partner Community Update | August 2024
Hello Partners,
Get the latest update on Azure resources, the Dynamics 365 price promotion, Copilot for Microsoft 365 playbook and pitch deck for Nonprofits and the Digital Natives Partner Program. Be sure to attend the Copilot for Microsoft 365 CSP Activation event on September 5th and Save the Date for the Tech for Social Impact Partner Virtual Summit on September 30th!
Download the TSI August Community Update
Hello Partners,
Get the latest update on Azure resources, the Dynamics 365 price promotion, Copilot for Microsoft 365 playbook and pitch deck for Nonprofits and the Digital Natives Partner Program. Be sure to attend the Copilot for Microsoft 365 CSP Activation event on September 5th and Save the Date for the Tech for Social Impact Partner Virtual Summit on September 30th!
Download the TSI August Community Update
Read More
What’s New for Planner in Teams in August 2024
The Planner team is excited to share some fresh new updates in the Planner app for Microsoft Teams. We thank you for your valuable feedback that helps shape feature updates, and hope these capabilities significantly enhance your experience managing tasks and coordinating team initiatives.
Resize columns in Grid view
Customize your task view by resizing columns, making it easier to focus on what’s important. Try it out by navigating to Grid view in My Day, My Tasks, or any plan and hovering over any column to increase or decrease its width.
Discover Recommended Plans
We’re excited to introduce the Recommended Plans feature in the new Planner in Teams. This feature helps you quickly find relevant plans for your work by highlighting any new plans with tasks assigned to you that you haven’t yet viewed.
You’ll find the Recommended Plans view in My Plans, alongside other views like Recent, Shared, Private, and Pinned. Remember, the Recommended Plans view will only appear if there are new plans with tasks assigned to you that haven’t already been listed under Recent Plans.
An improved experience for copying plan links
Copying the link to a plan now pastes the link with the plan’s name, making it easier for you and your teammates to identify the linked plan. Select ‘Copy link to plan’ from the overflow menu of any plan and paste the link to check out this capability.
Use Copilot in Planner (preview)
While final pricing has not been announced, users with a Project Plan 3 or Project Plan 5 license can preview Copilot in Planner capabilities. Copilot in Planner (preview) can supercharge your project planning, task managing, and progress tracking processes. For more information on Copilot in Planner (preview), see: Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams – Microsoft Community Hub.
If you’d like to try this feature but don’t have a Project license, you can start a free 30-day trial of a Project Plan 3 license by selecting the diamond icon within the Planner app in Teams.
Access Planner in GCC
Government Community Cloud (GCC) users can now access the Planner app in Teams, ensuring secure and efficient task management. To learn more about this update, check out: The new Microsoft Planner in Teams is now available in GCC – Microsoft Community Hub.
Open premium plans faster
We’ve recently made several changes so you can open your premium plans 15% faster than before. We know that app performance is important to complete your work successfully and this is one of many enhancements we plan to make in this area. Try it out and let us know if you can feel the difference!
Share your feedback
Your feedback helps inform our feature updates and we look forward to hearing from you as you try out Planner’s new and existing capabilities! To share your feedback about the new Planner app in Teams, including bugs you’ve observed in our product, you can navigate to the ? icon in the Planner app and select ‘Feedback’ as seen in the GIF below. We also encourage you to share any features you would like to see in the app by adding it to our Planner Feedback Portal.
Learn more about the new Planner
Register now for our 9/17 inside look at the new Planner The new Microsoft Planner: What’s New and What’s Coming Next and AMA
Watch our first Meet the Makers and AMA
Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Tea…
Read about our investments for organizations using the new Planner with frontline workers.
Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams
Check out the new Planner adoption website and explore new resources such as Day in the Life Guides to use Planner for task management, collaborative work management and project management.
We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
For future updates coming to the new Planner app, please view the Microsoft 365 roadmap here.
Learn about Planner and Project plans and pricing here.
Read the FAQs here.
Microsoft Tech Community – Latest Blogs –Read More
New Microsoft Copilot Dashboard Features Now Available – August 2024
Introducing exciting new features to help you better understand and improve adoption and impact of Copilot for Microsoft 365 through the Copilot Dashboard. These features will help you track Copilot adoption trends, estimate impact, interpret results, delegate access to others for improved visibility, and query Copilot assisted hours more effectively. This month, we have released four new features:
Updates to Microsoft Copilot Dashboard:
Trendlines
Copilot Value Calculator
Metric guidance for Comparison
Delegate Access to Copilot Dashboard
We have also expanded the availability of the Microsoft Copilot Dashboard. As recently announced, the Microsoft Copilot Dashboard is now available as part of Copilot for Microsoft 365 licenses and no longer requires a Viva Insights premium license. The rollout of the Microsoft Copilot Dashboard to Copilot for Microsoft 365 customers started in July. Customers with over 50 assigned Copilot for Microsoft 365 licenses or 10 assigned premium Viva Insights licenses have begun to see the Copilot Dashboard. Customers with fewer than 50 assigned Copilot for Microsoft 365 licenses will continue to have access to a limited Copilot Dashboard that features tenant-level metrics.
Let’s take a closer look at the four new features in the Copilot Dashboard as well as an update to more advanced reporting options in Viva Insights.
Trendline Feature
Supercharge your insights with our new trendline feature. Easily track your company’s Copilot adoption trends over the past 6 months. See overall adoption metrics like the number of Copilot-licensed employees and active users. Discover the impact of Copilot over time – find out how many hours Copilot has saved, how many emails were sent with its assistance, and how many meetings it summarized. Stay ahead with trendline and see how Copilot usage changes over time at your organization. For detailed views of Copilot usage within apps and Copilot impact across groups for timeframes beyond 28 days, use Viva Insights Analyst Workbench (requires premium Viva Insights license). Learn more here.
Copilot Value Calculator
Customize and estimate the value of Copilot at your organization. This feature estimates Copilot’s impact over a given period by multiplying Copilot-assisted hours by an average hourly rate. By default, this rate is set to $72, based on data from the U.S. Bureau of Labor Statistics. You can customize it by updating and saving your own average hourly rate and currency settings to get a personalized view. This feature is enabled by default, but your Global admin can manage it using Viva feature access management. See our Learn article for more information on Copilot-assisted hours and value.
Metric Guidance for Comparisons
Discover research-backed metric guidance when comparing different groups of Copilot usage, for example, Copilot active users and non-Copilot users. This guidance is based on comprehensive research compiled in our e-book and helps users interpret changes to meetings, email and chat metrics. For the best results, compare two similar groups, such as employees with similar job functions or ranks. Use our in-product metric guidance to interpret results and make informed decisions with confidence. Click here for more information.
Delegate Access to Copilot Dashboard
Leaders can now delegate access to their Microsoft Copilot Dashboard to others in their company to improve visibility and efficiency. Designated delegates, such as the leader’s chief of staff or direct reports, will be able to view Copilot Dashboard insights and use them to make data-driven decisions. Learn more about the delegate access feature here. Admins can control access to the delegation feature by applying feature management policies.
Go Deeper with Viva Insights – Copilot Assisted Hours Metric in Analyst Workbench
For customers wanting a more advanced, customizable Copilot reporting experience, Viva Insights is available with a premium Viva Insights license. With Viva Insights, customers can build custom views and reports, view longer data sets of Copilot usage, compare usage against third party data, and customize the definition of active Copilot users and other metrics.
The Copilot assisted hours metric featured in the Microsoft Copilot Dashboard is now also available to query in the Viva Insights Analyst Workbench. When running a person query and adding new metrics, Viva Insights analysts will be able to find this metric under the “Microsoft 365 Copilot” metric category. The metric is computed based on your employees’ actions in Copilot and multipliers derived from Microsoft’s research on Copilot users. Use this new available metric for your own custom Copilot reports.
Summary
We hope you enjoy these new enhancements to Copilot reporting to help you accelerate adoption and impact of AI at your organization. We’ll keep you posted as more enhancements become available to measure Copilot.
Microsoft Tech Community – Latest Blogs –Read More
Effortless Private Endpoint Management in Azure Landing Zones: A Streamlined and Compliant Approach
1. Challenge
In Azure Landing Zones, the network infrastructure, including components like VNET Gateways and ExpressRoute circuits, is part of the platform landing zone. However, in line with the subscription democratization principle, workload owners should be empowered to deploy infrastructure as needed while remaining compliant with corporate policies.
To achieve this in Azure Landing Zones, a custom Subscription Owner role grants workload (VNET) owners full access, excluding role assignments and networking. While this setup generally works, it poses a challenge for Private Endpoints. Registering a Private Endpoint into the required Private DNS Zone, which is centrally managed in the platform landing zone, is not possible because workload subscription owners lack access to these Private DNS Zones. Although they can be granted access using the Private DNS Zone Contributor role, assigned to the “connectivity” subscriptions or management groups, this role provides too much access, such as editing or deleting records. Ideally, only the (de-)registration of the CNAME record for the Private Endpoint should be allowed. This article describes a simple solution to this problem while ensuring compliance with Azure Landing Zone policies.
MS Learn outlines an approach for “Private Link and DNS integration at scale”, but it has several drawbacks:
The policies can quickly become large and complex.
Each Private Link Resource type requires dedicated code in the policy.
This method is incompatible with several resource types such as AKS and PostgreSQL Flexible Server.
The approach described in this article is easy to deploy and provides a seamless, Azure Landing Zones-compliant solution.
2. AZURE Landing Zones
The diagram below shows the resource structure in an AZURE Landing Zone. A subscription in the “Landing Zones” management group serves as boundary for a single workload. The owners of the workload are assigned the “Subscription Owner” role on the subscription. The Private DNS Zones however, reside in the “Connectivity” subscription, part of the “Platform” management group.
Deploying a Private Endpoint in the workload subscription requires creating a CNAME record in the correct Private DNS Zone (in the platform landing zone), not accessible by “Subscription Owners”.
3. Role Based Access Control
To register a Private Endpoint’s CNAME record, the identity (user, service principal, or managed identity) must have the “Microsoft.Network/privateDnsZones/join/action” permission on the Private DNS Zone. While this is the only essential action, for a seamless experience across PowerShell, CLI, and the portal, at least two additional actions are necessary:
Microsoft.Resources/subscriptions/resourceGroups/read: This allows browsing the resource groups in the portal, with no access to the resources in the group. The portal requires this to allow browsing to the Private DNS Zone.
Optionally you can add Microsoft.Network/privateDnsZones/*/read: This allows reading the records in Private DNS Zone. It’s not a must, but allows validating presence of the CNAME records.
4. Custom Role
The simplest and recommended way to assign rights for a specific set of actions to an identity is through a custom role. Note that this requires an Entra ID P2 license, which is also necessary for the Azure Landing Zone (ALZ) recommended custom roles. The Bicep code below lists the role definition and facilitates easy deployment of the role into the landing zone environment:
targetScope = ‘managementGroup’
metadata name = ‘PrivateEndpointDnsContributor Role’
metadata description = ‘Role for registring a Prviate Endpoint in a Private DNS Zone’
var varRole = {
name: ‘[${managementGroup().name}] PrivateEndpointDnsContributor’
description: ‘Role for Contributing to Private Endpoint DNS Configuration’
}
resource resRoleDefinition ‘Microsoft.Authorization/roleDefinitions@2022-04-01’ = {
name: guid(varRole.name, managementGroup().name)
properties: {
roleName: varRole.name
description: varRole.description
type: ‘CustomRole’
permissions: [
{
actions: [
‘Microsoft.Resources/subscriptions/resourceGroups/read’
‘Microsoft.Network/privateDnsZones/read’
‘Microsoft.Network/privateDnsZones/*/read’
‘Microsoft.Network/privateDnsZones/join/action’
]
notActions: []
dataActions: []
notDataActions: []
}
]
assignableScopes: [
tenantResourceId(‘Microsoft.Management/managementGroups’, managementGroup().name)
]
}
}
output outRoleDefinitionId string = resRoleDefinition.id
This BICEP template has to be deployed into the “Intermediate Root ” management group (“Contoso” in the diagram in the previous paragraph). Below you find a PowerShell snippet showing how to deploy the bicep code:
Connect-AzAccount
$inputObject = @{
DeploymentName = ‘PrivateEndpointDnsContributor-{0}’ -f (-join (Get-Date -Format ‘yyyyMMddTHHMMssffffZ’)[0..63])
Location = “eastus”
ManagementGroupId = “contoso”
TemplateFile = “./PrivateEndpointDnsContributor.bicep”
}
New-AzManagementGroupDeployment @inputObject
5. Role assignments
After deployment, there’s one additional step: assign this role to every identity that needs permission to deploy Private Endpoints for workload subscriptions (also known as “Application Landing Zones”). The role assignment must be scoped to the “Connectivity” Management Group within the platform landing zone. This process is illustrated in the diagram below:
Microsoft Tech Community – Latest Blogs –Read More
Windows news you can use: August 2024
Windows 11 is getting better and better by the month! Get started with the latest improvements to Windows client and server security, device and app management, and productivity boosters. Join us as we celebrate three years of Windows 365 and the public preview of hotpatching on Windows Server 2025.
New in Windows security
[MFA] Start planning and enable mandatory Microsoft Entra multifactor authentication (MFA) today. This will be required to sign in to the Microsoft Azure portal, Microsoft Entra admin center, and Microsoft Intune admin center starting on or after October 15, 2024. If you use Intune admin center to access other services, such as Windows 365 Cloud PC, the same level of protection will apply.
[Windows 365] Check out new Windows 365 features that help provide a more secure workspace. As part of these innovations, configure single sign-on using Microsoft Entra authentication and try out new functionality in in-session passwordless authentication, faster re-authentication, new mobile application management (MAM) customizations, as well as watermarking and screen capture protection. You can also control your organization’s encryption keys with Microsoft Purview Customer Key, set up Microsoft Purview forensic evidence, and ensure unidirectional clipboard transfer.
New in update and device management
[AUTOPATCH] Check out auto-remediation PowerShell scripts to help resolve policy conflicts that might impact Windows updates in Windows Autopatch. This solution is for you if you currently use Microsoft Intune and don’t use third-party application patching solutions with Microsoft Configuration Manager.
[INTUNE] Identify and address performance issues caused by CPU or RAM spikes with the new Resource performance report within Intune Advanced Analytics. Use it to evaluate device performance across models, make informed decisions about hardware replacements, and even negotiate with original equipment manufacturers (OEMs).
[APPS] Did you know you can use Windows Package Manager (WinGet) to install and manage Microsoft Store apps on your Windows 11 devices? First, download WinGet 1.8, run the command winget upgrade winget, or update App Installer from the Microsoft Store. Then download the app that you want to distribute offline to another device with a similar command: winget download Calculator -s msstore. Finally, use the following PowerShell cmdlet to install this app on another device: Add-AppxPackage -Path C:Usersusernamedownloads9WZDNCRFHVN5Calculator.appx.
[Windows 365] New GPU-enabled Cloud PCs are now generally available for Windows 365 Enterprise and Frontline editions. Browse the FAQ section to see what this opportunity means for your context. For those who already use Cloud PCs and Microsoft Intune, check out the Cloud PC recommendations report with newly added AI-driven insights.
New in Windows Server
[Windows Server 2025][PREVIEW] You can now preview hotpatching on Windows Server 2025 Evaluation VMs in Azure. Just create a virtual machine (VM) using the “Windows Server 2025 Preview” image from Microsoft Server Operating Systems Preview. Hotpatching will be enabled by default in the image unless it was disabled at provision time. To learn more about hotpatching, read our documentation.
[AZURE][PREVIEW] Try Windows Server Datacenter: Azure Edition in the desktop experience.
New in productivity and collaboration
The August 13, 2024 security update brings the following improvements to your Windows 11 devices, which are rolled out gradually.
[TASKBAR] Drag apps from the Pinned section of the Start menu and pin them to the taskbar. Try WIN + T shortcut to bring the keyboard into focus, then press the first letter of an open app to switch to it right away. You can also press Home and End to focus on the first and last items in the taskbar.
[FILE EXPLORER] Right-click a tab in your File Explorer to see an option to duplicate it.
[WINDOWS APP][PREVIEW] Connect to any of your Windows devices through a new Windows App (in preview). Use it to connect to Azure Virtual Desktop, Windows 365, Microsoft Dev Box, Remote Desktop Services, and Remote PC from a variety of operating systems and web browsers. Note: This app replaces the Windows 365 app in the Microsoft Store. Once installed, just turn on the Preview toggle.
Install the August 27, 2024 non-security update to preview what’s coming next month! Here are some highlights:
[WINDOWS SHARE] Pair your Android device to your Windows PC to facilitate content sharing through Windows Share.
[ACCESSIBILITY] Enjoy a faster and better Narrator and Voice access experience, among other improvements.
[WIDGETS] If you’re in the European economic area (EEA) region, use widgets more securely and create them more effectively with improved APIs.
Windows Insider Preview news
Here’s a summary of this month’s new experiences available to you as a Windows Insider. Remember to visit Windows Insider Blog for complete details. Note that many new features are rolled out gradually and belong to different build versions.
[DEV][PREVIEW] Check out a few improvements to the taskbar, settings, and more. As these features roll out, find the Widgets entry-point to the left of the system tray on the taskbar in build 26120.1542. With build 26120.1340, set your mouse pointer precision and scrolling direction in Settings > Bluetooth & devices > Mouse. Improve your energy savings by turning off HDR under System > Power & battery > Energy recommendations. Additionally, you’ll now get a pop-up notification when your laptop battery reaches 20% if your Energy Saver is set to “Always on.” With build 26120.1350, it’s now safer to install an MSIX package with added source verification procedure, as well as to share content between your Android device and your Windows PC. And, if you run Windows 11 build version 22407.xxxx.x and higher, visit Microsoft Store for an updated experience.
[BETA][PREVIEW] Take advantage of the simplified system tray on your taskbar. If you see undesirable jump lists when you hover your mouse cursor over apps on the taskbar, you can turn them off under Taskbar behaviors in Settings > Personalization > Taskbar in build 22635.4010. Likewise, you can disable undesired notifications from certain apps in Settings > System > Notifications > Notification suggestions in build 22635.4082.
[CANARY][PREVIEW] The Windows 11 Insider Preview build 27686 brings you the new Windows Sandbox Client Preview. Inside it, use the ellipsis icon (…) to access runtime clipboard redirection, audio/video input control, and the ability to share folders with the host at runtime.
Want to stand out from the crowd? Don’t wait to get started with these Windows 11 opportunities. As you preview these features and capabilities, send your technical feedback through Feedback Hub (WIN + F). Let us know what you’re trying out this month in the comments below!
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Where are “files installed for your end user” are saved in the installation directory using compiler?
I have a few matrices that I want to load in the app using the load command.
Temporarily the files are saved like this:
load C:UserssepandDocumentsMATLABBY.mat;
what path should I set them to so that they would be accessible to the main program after compilation?I have a few matrices that I want to load in the app using the load command.
Temporarily the files are saved like this:
load C:UserssepandDocumentsMATLABBY.mat;
what path should I set them to so that they would be accessible to the main program after compilation? I have a few matrices that I want to load in the app using the load command.
Temporarily the files are saved like this:
load C:UserssepandDocumentsMATLABBY.mat;
what path should I set them to so that they would be accessible to the main program after compilation? matlab compiler MATLAB Answers — New Questions
Confirming a confirmed track for GNN tracker
Hi, I am currently working with a GNN tracker with radar data. I have a tracker working for range and angle information.
After gettting the confirmed tracks, I would like to check make another check with some detections and then keep the old track alive. How can I achieve this? I saw that there is a trackStateLogic which is appended with a zero everytime a track does not get a detection. But I was uable to change it for a confirmed track.
Can someone please help me in this?Hi, I am currently working with a GNN tracker with radar data. I have a tracker working for range and angle information.
After gettting the confirmed tracks, I would like to check make another check with some detections and then keep the old track alive. How can I achieve this? I saw that there is a trackStateLogic which is appended with a zero everytime a track does not get a detection. But I was uable to change it for a confirmed track.
Can someone please help me in this? Hi, I am currently working with a GNN tracker with radar data. I have a tracker working for range and angle information.
After gettting the confirmed tracks, I would like to check make another check with some detections and then keep the old track alive. How can I achieve this? I saw that there is a trackStateLogic which is appended with a zero everytime a track does not get a detection. But I was uable to change it for a confirmed track.
Can someone please help me in this? gnn tracker MATLAB Answers — New Questions
Efficient Code for Filling Rows of an Array involving Indices Ranges
Hello,
I have an array A of zeros. I need to set a range of column indices for each row of A to ones. These ranges are determined by elements of another vector B, specifying start and end indices for the ranges for each row. For example, this is what I’m trying to figure out:
<</matlabcentral/answers/uploaded_files/18907/matrixA.jpg>>
<</matlabcentral/answers/uploaded_files/18908/matrixB.jpg>>
<</matlabcentral/answers/uploaded_files/18909/matrixA2.jpg>>
The first row of B indicates that the first row of A should have ones from columns 1 to 3. The second row of B indicates that the second row of A should have ones from columns 2 to 4 etc.
I could code this with a for-loop that goes through each of the rows and creates indices with the colon operator however, I’m hoping for a smarter, more efficient way to do it than that.
Can anyone help me with this or any suggestions?
Thanks.Hello,
I have an array A of zeros. I need to set a range of column indices for each row of A to ones. These ranges are determined by elements of another vector B, specifying start and end indices for the ranges for each row. For example, this is what I’m trying to figure out:
<</matlabcentral/answers/uploaded_files/18907/matrixA.jpg>>
<</matlabcentral/answers/uploaded_files/18908/matrixB.jpg>>
<</matlabcentral/answers/uploaded_files/18909/matrixA2.jpg>>
The first row of B indicates that the first row of A should have ones from columns 1 to 3. The second row of B indicates that the second row of A should have ones from columns 2 to 4 etc.
I could code this with a for-loop that goes through each of the rows and creates indices with the colon operator however, I’m hoping for a smarter, more efficient way to do it than that.
Can anyone help me with this or any suggestions?
Thanks. Hello,
I have an array A of zeros. I need to set a range of column indices for each row of A to ones. These ranges are determined by elements of another vector B, specifying start and end indices for the ranges for each row. For example, this is what I’m trying to figure out:
<</matlabcentral/answers/uploaded_files/18907/matrixA.jpg>>
<</matlabcentral/answers/uploaded_files/18908/matrixB.jpg>>
<</matlabcentral/answers/uploaded_files/18909/matrixA2.jpg>>
The first row of B indicates that the first row of A should have ones from columns 1 to 3. The second row of B indicates that the second row of A should have ones from columns 2 to 4 etc.
I could code this with a for-loop that goes through each of the rows and creates indices with the colon operator however, I’m hoping for a smarter, more efficient way to do it than that.
Can anyone help me with this or any suggestions?
Thanks. matrix manipulation MATLAB Answers — New Questions
Uigetdir to pick multiple directories
I was wondering if anyone knows a simple way how to use uigetdir to select multiple directory paths in a similar way to using uigetfile with ‘multiselect’,’on’
ThanksI was wondering if anyone knows a simple way how to use uigetdir to select multiple directory paths in a similar way to using uigetfile with ‘multiselect’,’on’
Thanks I was wondering if anyone knows a simple way how to use uigetdir to select multiple directory paths in a similar way to using uigetfile with ‘multiselect’,’on’
Thanks uigetdir, uigetfile, multiselect, directory MATLAB Answers — New Questions
Sharepoint site sharing for people with edit permission doesn’t work
Hello everybody,
the site share settings are set to “site owners and members… People with Edit permissions can share files and folders.”
We introduced several SharePoint Groups with the Permission level “Edit without delete” which is just a copy of permission level edit without delete items and delete versions.
Users which are members of theses Sharepoint Groups can add folders, files to the Sharepoint document library. But if they try to share a file they get the message as soon as they enter a name
The person the share is addressed to is member of one of the sharepoint groups as well.
My question: Why can’t people with apparent edit permission share a file. This is a contradiction to the setting people with edit permission can share … and the user’s ability to add folders and files.
We use Sharepoint online.
I think this behaviour is some sort of bug.
This really causes us quite a bit of strain.
Any advice/help is very welcomed.
Kind regards
Hello everybody, the site share settings are set to “site owners and members… People with Edit permissions can share files and folders.”We introduced several SharePoint Groups with the Permission level “Edit without delete” which is just a copy of permission level edit without delete items and delete versions. Users which are members of theses Sharepoint Groups can add folders, files to the Sharepoint document library. But if they try to share a file they get the message as soon as they enter a nameThe person the share is addressed to is member of one of the sharepoint groups as well. My question: Why can’t people with apparent edit permission share a file. This is a contradiction to the setting people with edit permission can share … and the user’s ability to add folders and files. We use Sharepoint online. I think this behaviour is some sort of bug. This really causes us quite a bit of strain. Any advice/help is very welcomed. Kind regards Read More
New Outlook Spam filter
Hello,
I need some help in understanding how the spam filtering works.
whilst most want to filter spam out and not get bothered with it I need to take a different approach.
I get tons of spam emails filtered into my SPAM folder. Again, whilst most are happy with this I am NOT!
Because those spam emails filling up the Spam folder and also getting too many good (not spam) emails filtered into that same folder, I end up seeing myself spending too much time looking for non spam emails.
My idea is to filter spam myself.
In outlook in the manage rules menu and Junk Email section there is the Incoming mail handling and I can only select the Standard radio button as the minimum spam filter. How can I completely switch it off?
I also have an office 365 desktop suite with Outlook where I can switch it off filtering completely but I think this is only a filter that looks at the emails when these are called into the application and not in the cloud, right? I believe that Microsoft does a ‘standard’ filtering regardless of the filtering level set by the user, or is there a way to control this?
Hello,I need some help in understanding how the spam filtering works.whilst most want to filter spam out and not get bothered with it I need to take a different approach.I get tons of spam emails filtered into my SPAM folder. Again, whilst most are happy with this I am NOT!Because those spam emails filling up the Spam folder and also getting too many good (not spam) emails filtered into that same folder, I end up seeing myself spending too much time looking for non spam emails.My idea is to filter spam myself. In outlook in the manage rules menu and Junk Email section there is the Incoming mail handling and I can only select the Standard radio button as the minimum spam filter. How can I completely switch it off?I also have an office 365 desktop suite with Outlook where I can switch it off filtering completely but I think this is only a filter that looks at the emails when these are called into the application and not in the cloud, right? I believe that Microsoft does a ‘standard’ filtering regardless of the filtering level set by the user, or is there a way to control this? Read More
Multiple IF/AND Formula
Hi there,
I am trying to do a formula based on a tiered system. So an employee gets paid out per deal based on how many deals they get. See example below. So for February they would get paid out $300*4=$1,200 based on hitting tier 2 for 3 or more deals but less than tier 3 for DCI Deals and $400*10=$4,000 for Certainli Deals for hitting tier 3, 10 deals or higher giving them a total of $5,200 bonus that month. Any help is appreciated, thank you so much!!
Tier 1Tier 2Tier 3DCI $ 150.00 $ 300.00 $ 600.00Certainli $ 100.00 $ 200.00 $ 400.00 Tier 1Tier 2Tier 3DCI036Certainli0510 JanuaryFebruaryMarchAprilMayJuneJulyAugustDCI Deals34642313Certainli Deals510523521
Hi there,I am trying to do a formula based on a tiered system. So an employee gets paid out per deal based on how many deals they get. See example below. So for February they would get paid out $300*4=$1,200 based on hitting tier 2 for 3 or more deals but less than tier 3 for DCI Deals and $400*10=$4,000 for Certainli Deals for hitting tier 3, 10 deals or higher giving them a total of $5,200 bonus that month. Any help is appreciated, thank you so much!! Tier 1Tier 2Tier 3DCI $ 150.00 $ 300.00 $ 600.00Certainli $ 100.00 $ 200.00 $ 400.00 Tier 1Tier 2Tier 3DCI036Certainli0510 JanuaryFebruaryMarchAprilMayJuneJulyAugustDCI Deals34642313Certainli Deals510523521 Read More
Cannot identify data for drop down list
I have a spreadsheet which was created by a predecessor (so I cannot ask them), it has multiple drop down menus, but no tab with data lists to show where these are pulled from, that I can see of. I need to edit the drop down menus to include some more options, it looks like a lookup is in place. The formula is =Lookups!$A$3:$A$17 . How do I go about editing this to allow further drop list options?
I have a spreadsheet which was created by a predecessor (so I cannot ask them), it has multiple drop down menus, but no tab with data lists to show where these are pulled from, that I can see of. I need to edit the drop down menus to include some more options, it looks like a lookup is in place. The formula is =Lookups!$A$3:$A$17 . How do I go about editing this to allow further drop list options? Read More
Windows 2008 NIC issue
I have a vmware Virtual Windows 2008 r2 standard server and the NIC does not show update on the OS. Also the Device Manager is blank.
I have a vmware Virtual Windows 2008 r2 standard server and the NIC does not show update on the OS. Also the Device Manager is blank. Read More
