Category: Microsoft
Category Archives: Microsoft
Can’t Download Files Completely from One Drive
Hi, I tried to download dataset files online for model training, but there is a file where I keep on encountering errors, where the files had 8000+ file inside, but it can’t download completely. The file is around 22.6GB but whenever I tried to download, it is able to download. But even it shows download complete, it is actually not complete. Instead, it shows a txt file showing the error, as shown below. Does anyone knows ways to solve this problem?
Anyone knows how to solve this error?
Hi, I tried to download dataset files online for model training, but there is a file where I keep on encountering errors, where the files had 8000+ file inside, but it can’t download completely. The file is around 22.6GB but whenever I tried to download, it is able to download. But even it shows download complete, it is actually not complete. Instead, it shows a txt file showing the error, as shown below. Does anyone knows ways to solve this problem?Anyone knows how to solve this error? Read More
Copilot Snacks! Copilot for Payers – How Copilot for Sales can be used by Agents and Brokers
Unlocking the Potential of AI in Health Insurance Sales with Copilot for Sales
This discussion offers a glimpse into the future of health insurance sales, where AI-powered tools like Copilot for Sales empower agents to deliver exceptional service while maximizing their productivity. For sales agents and brokers looking to stay ahead in the competitive health insurance market, this video is a must-watch.
Revolutionizing Health Insurance Sales with Copilot for Sales
Integration: Seamlessly connects productivity tools with CRM systems, enhancing data flow and efficiency
Productivity: Offers sales-specific workflows, improving agent efficiency and customer engagement
Personalization: Utilizes AI to tailor customer interactions, summarizing email threads and drafting responses
Competitive Intelligence: Provides real-time competitive insights, aiding agents in offering the best solutions
Efficiency: Streamlines preparation, consolidating information in one place for quicker, more effective meetings
To see all HLS Copilot Snacks video click here.
Special thanks to Ashley Keimach for her expertise and making this video possible
Microsoft Tech Community – Latest Blogs –Read More
Passing File IDs from Power Apps to Power Automate and merging into PDF, then send an email
Hello,
I’m working on a PowerApps application that allows users to select specific files from a gallery (connected a sharepoint library), display them on a table for confirmation and then merge into a pdf to send to themselves. The process involves passing the IDs of the selected files from PowerApps to Power Automate, filtering the files based on these IDs, extracting the file content and merging them into a PDF.
I’m struggling with passing the IDs from Power Apps to automate. The flow reads the entire library (200+ items) instead of just the selected.
The configuration for my PowerApp button to call the flow is:
Hello, I’m working on a PowerApps application that allows users to select specific files from a gallery (connected a sharepoint library), display them on a table for confirmation and then merge into a pdf to send to themselves. The process involves passing the IDs of the selected files from PowerApps to Power Automate, filtering the files based on these IDs, extracting the file content and merging them into a PDF. I’m struggling with passing the IDs from Power Apps to automate. The flow reads the entire library (200+ items) instead of just the selected. The configuration for my PowerApp button to call the flow is:MergePDF.Run(Concat(SelectedItems, (ID),”,”);Notify(“Export process started. You will receive an email once complete.”, NotificationType.Success, 3000)). Please help ASAP!! Read More
Update formatting on Offer Listing
I want to update my already published offer with formatted text. During publishing, all the formatting and white space were stripped out.
I want to update my already published offer with formatted text. During publishing, all the formatting and white space were stripped out. Read More
PVA and Azure bot
Why Power Virtual Agent is better than Microsoft Azure Bot
A comparison of the features, offering and efficiency of two chatbot platforms
Chatbots are becoming more and more popular as a way to provide customer service, answer queries, and automate tasks. But how do you choose the right chatbot platform for your needs? In this blog post, we will compare two of the most popular chatbot platforms from Microsoft: Power Virtual Agent (PVA) and Azure Bot Service (ABS). We will look at their features, costs, and efficiency, and show you why PVA is a better choice for most scenarios.
Features
PVA and ABS both allow you to create chatbots that can interact with users through various channels, such as websites, mobile apps, social media, and Microsoft Teams. However, PVA has some advantages over ABS in terms of ease of use, functionality, and integration.
PVA is a low-code, no-code platform that lets you create chatbots using a graphical interface, without writing any code. You can design your chatbot’s conversation flow using a visual canvas, and use pre-built templates and entities to handle common scenarios. ABS, on the other hand, requires you to code your chatbot’s logic using C#, JavaScript, or Python, and use the Bot Framework SDK to build and deploy your chatbot. This means that you need to have some programming skills and knowledge of the SDK to use ABS.
PVA has a built-in natural language processing (NLP) engine that can understand user intents and entities, and handle complex and ambiguous user inputs. You can also train your chatbot to recognize custom intents and entities, and use synonyms and phrases to improve its accuracy. ABS does not have a native NLP engine, and you need to use a separate service, such as LUIS or QnA Maker ( integrated and called CLU now), to enable your chatbot to understand natural language. This adds another layer of complexity and cost to your chatbot development.
PVA has a seamless integration with Microsoft Power Platform, which is a suite of tools that can help you create and automate business solutions. You can easily connect your chatbot to Power Apps, Power Automate, Power BI, and Dataverse, and access data and actions from these services. You can also use Power Automate to create workflows and triggers for your chatbot, and use Dataverse to store and manage your chatbot’s data. ABS does not have a direct integration with Power Platform, and you need to use connectors and APIs to access data and actions from other services.
Extensive Pre-Built Connectors
Power Virtual Agents (PVA) stands out with its extensive collection of pre-built connectors, which significantly simplifies the process of integrating with various services and systems. PVA offers over 450 connectors, allowing users to easily connect their chatbots to a wide range of data sources and applications without the need for custom development1. This includes seamless integration with Microsoft Power Platform, enabling connections to Power Apps, Power Automate, Power BI, and Dataverse.
On the other hand, Azure Bot Service (ABS) does not come with a similar range of pre-built connectors. While ABS provides a robust framework for building and deploying chatbots, it requires users to develop custom connectors or use additional services like Logic Apps or Azure Functions to achieve similar integrations. This adds complexity and development effort, making PVA a more accessible and efficient choice for users who need quick and easy integrations.
Seamless Integration with Microsoft Ecosystem
Power Virtual Agents (PVA) offers seamless integration with the Microsoft ecosystem, making it an ideal choice for businesses that rely on Microsoft tools and services. PVA is designed to work effortlessly with the Microsoft Power Platform, which includes Power Apps, Power Automate, Power BI, and Dataverse. This integration allows users to create comprehensive business solutions by connecting their chatbots to various data sources and applications within the Microsoft ecosystem. For example, you can use Power Automate to create workflows and triggers for your chatbot, and Dataverse to store and manage your chatbot’s data.
On the other hand, Azure Bot Service (ABS) does not have the same level of seamless integration with the Microsoft ecosystem. While ABS provides a robust framework for building and deploying chatbots, it requires users to develop custom connectors or use additional services like Logic Apps or Azure Functions to achieve similar integrations. This adds complexity and development effort, making PVA a more accessible and efficient choice for users who need quick and easy integrations.
Efficiency
PVA and ABS both offer high-performance and scalable chatbot solutions that can handle large volumes of traffic and requests. However, PVA has some benefits over ABS in terms of speed, reliability, and maintenance.
PVA allows you to create and deploy chatbots in minutes, without any coding or infrastructure setup. You can use the PVA portal to design, test, and publish your chatbot, and monitor its performance and analytics. You can also update your chatbot’s content and logic at any time, without affecting its availability. ABS, on the other hand, requires you to code, build, and deploy your chatbot using the Bot Framework SDK and Azure services. This can take more time and effort, and you may encounter errors and bugs along the way. You also need to manage and update your chatbot’s code and dependencies, and ensure that your chatbot is compatible with the latest SDK and Azure versions.
PVA provides a reliable and secure chatbot platform that is hosted on Microsoft’s cloud infrastructure. You do not need to worry about the availability, scalability, or security of your chatbot, as Microsoft handles these aspects for you. You can also leverage Microsoft’s compliance and data protection policies, and choose the region where your chatbot’s data is stored and processed. ABS, on the other hand, gives you more control and flexibility over your chatbot’s infrastructure, but also more responsibility and risk. You need to configure and manage your chatbot’s hosting, scaling, and security settings, and ensure that your chatbot meets the compliance and data protection requirements of your region and industry.
In conclusion, PVA is a better choice than ABS for most chatbot scenarios, as it offers more features, lower costs, and higher efficiency. PVA is ideal for business users, non-developers, and anyone who wants to create chatbots quickly and easily, without coding or infrastructure hassles. ABS is more suitable for developers, advanced users, and anyone who wants to create chatbots with custom code and complex logic, and have more control and flexibility over their chatbot’s infrastructure.
Microsoft Tech Community – Latest Blogs –Read More
Outlook contact business cards partially covered by black bars
The Microsoft agent on the Microsoft Outlook Community Forum suggested I cross-post the issue here so it can be fixed.
Please see the full discussion at: https://answers.microsoft.com/en-us/outlook_com/forum/outlk_win-outtop_classic-outsub_ofh/outlook-contact-business-cards-partially-covered/0386d601-1193-435e-801a-68392cf8b7c6?messageId=f6e3b6f5-863c-4450-87d8-cb272dd9c139
Here is a copy:
For many years, though several versions of Outlook for Windows and on multiple machines running everything from Windows 7 through Windows 11, I’ve been putting up with big black bars covering the bottom parts of many of my contacts’ business cards. This never happens with the contacts at the top of my list, but it always happens with the contacts near the bottom. (I have ~5,000 contacts, and the bars start to appear as I scroll down past the 2,500 mark or so.)
Some are worse than others:
Here’s the overall view near the end of the alphabet. Notice that some rows of business cards have thicker bars than others, but as you scroll down further in the alphabet, all rows get the bars. (Ignore the grey boxes. I added those to obscure the details. It’s the black boxes that I’m talking about. They’re what I see.)
It never happens near the top of the alphabet:
This has been reported by many other users over the years, but never solved:
…and…
…and elsewhere.
I’ve tried all of the various suggestions about disabling animations and hardware acceleration, but nothing works. And since I’ve observed this on multiple systems with different graphics cards, different monitors, different OSs, different Office versions, and both laptops and desktops, I have to assume this is an inherent Office bug that has something to do with very long contact lists in the business card view.
I’m running Microsoft® Outlook® 2019 MSO (Version 2406 Build 16.0.17726.20078) 64-bit on Windows 11 Pro 64-bit, but as I wrote above, I’ve had the same problem as far back as Windows 7 or 8 and Office 2010 or 2013.
From the discussion on the Community Forum, it became clear that scaling the contact cards at or below 85% (Contacts > View > View Settings > Other Settings… > Card size %) and restarting Outlook makes the black bars go away, but then the cards are too small to be useful. It also was confirmed there that effect is currently visible and reproducible across at least two users and platforms. So, this is some kind of a scaling issue, and it’s a bug.
Can this be fixed?
Thank you.
The Microsoft agent on the Microsoft Outlook Community Forum suggested I cross-post the issue here so it can be fixed. Please see the full discussion at: https://answers.microsoft.com/en-us/outlook_com/forum/outlk_win-outtop_classic-outsub_ofh/outlook-contact-business-cards-partially-covered/0386d601-1193-435e-801a-68392cf8b7c6?messageId=f6e3b6f5-863c-4450-87d8-cb272dd9c139 Here is a copy: For many years, though several versions of Outlook for Windows and on multiple machines running everything from Windows 7 through Windows 11, I’ve been putting up with big black bars covering the bottom parts of many of my contacts’ business cards. This never happens with the contacts at the top of my list, but it always happens with the contacts near the bottom. (I have ~5,000 contacts, and the bars start to appear as I scroll down past the 2,500 mark or so.) Some are worse than others: Here’s the overall view near the end of the alphabet. Notice that some rows of business cards have thicker bars than others, but as you scroll down further in the alphabet, all rows get the bars. (Ignore the grey boxes. I added those to obscure the details. It’s the black boxes that I’m talking about. They’re what I see.) It never happens near the top of the alphabet: This has been reported by many other users over the years, but never solved:https://answers.microsoft.com/en-us/outlook_com/forum/all/outlook-contacts-black-line/efaf4d45-98cd-48ec-95a9-d9c40ebb0978…and…https://answers.microsoft.com/en-us/outlook_com/forum/all/busines-card-view-corruption-in-outlook-2016-64/6195cb49-a461-4aaa-b233-511aa4d5fb4f…and elsewhere. I’ve tried all of the various suggestions about disabling animations and hardware acceleration, but nothing works. And since I’ve observed this on multiple systems with different graphics cards, different monitors, different OSs, different Office versions, and both laptops and desktops, I have to assume this is an inherent Office bug that has something to do with very long contact lists in the business card view. I’m running Microsoft® Outlook® 2019 MSO (Version 2406 Build 16.0.17726.20078) 64-bit on Windows 11 Pro 64-bit, but as I wrote above, I’ve had the same problem as far back as Windows 7 or 8 and Office 2010 or 2013. From the discussion on the Community Forum, it became clear that scaling the contact cards at or below 85% (Contacts > View > View Settings > Other Settings… > Card size %) and restarting Outlook makes the black bars go away, but then the cards are too small to be useful. It also was confirmed there that effect is currently visible and reproducible across at least two users and platforms. So, this is some kind of a scaling issue, and it’s a bug.Can this be fixed? Thank you. Read More
Storage Account Private Endpoint with Compute Gallery
Hopefully this is the right group to pose this question. I have a Compute Gallery with some VM Applications in it. I have the Storage Account with the blobs configured with a Private Endpoint. When I try to turn off Public Network Access, the VM Apps in the Gallery no longer function, citing access issues.
I’m assuming the Compute Gallery won’t access my Storage Account over a Private Link inside my vNET, so my question is how do I lock down the Storage Account to not have things wide open? Is there specific IPs that the Compute Gallery will use when accessing the Storage Account?
Hopefully this is the right group to pose this question. I have a Compute Gallery with some VM Applications in it. I have the Storage Account with the blobs configured with a Private Endpoint. When I try to turn off Public Network Access, the VM Apps in the Gallery no longer function, citing access issues.I’m assuming the Compute Gallery won’t access my Storage Account over a Private Link inside my vNET, so my question is how do I lock down the Storage Account to not have things wide open? Is there specific IPs that the Compute Gallery will use when accessing the Storage Account? Read More
OneNote Web App Text Box width
When using OneNote Web app and pasting in a block of text, the text box is created about 2 feet wide, scrolling off the screen to the right. If you scroll over to the right edge and try to resize the box by dragging it to the left, then the text itself, which was its original width, gets severely narrowed to the point it is unusable.
To Reproduce, paste this block (or any similar) of text into OneNote web app, then notice the width of the text box and try to resize it:
Why attack surface reduction rules are important
Your organization’s attack surface includes all the places where an attacker could compromise your organization’s devices or networks. Reducing your attack surface means protecting your organization’s devices and network, which leaves attackers with fewer ways to perform attacks. Configuring attack surface reduction rules in Microsoft Defender for Endpoint can help!
Attack surface reduction rules target certain software behaviors, such as:
Launching executable files and scripts that attempt to download or run filesRunning obfuscated or otherwise suspicious scriptsPerforming behaviors that apps don’t usually initiate during normal day-to-day work
Such software behaviors are sometimes seen in legitimate applications. However, these behaviors are often considered risky because they’re commonly abused by attackers through malware. Attack surface reduction rules can constrain software-based risky behaviors and help keep your organization safe.
For a sequential, end-to-end process of how to manage attack surface reduction rules, see:
Attack surface reduction rules deployment overviewPlan attack surface reduction rules deploymentTest attack surface reduction rulesEnable attack surface reduction rulesOperationalize attack surface reduction rules
When using OneNote Web app and pasting in a block of text, the text box is created about 2 feet wide, scrolling off the screen to the right. If you scroll over to the right edge and try to resize the box by dragging it to the left, then the text itself, which was its original width, gets severely narrowed to the point it is unusable. To Reproduce, paste this block (or any similar) of text into OneNote web app, then notice the width of the text box and try to resize it: Why attack surface reduction rules are importantYour organization’s attack surface includes all the places where an attacker could compromise your organization’s devices or networks. Reducing your attack surface means protecting your organization’s devices and network, which leaves attackers with fewer ways to perform attacks. Configuring attack surface reduction rules in Microsoft Defender for Endpoint can help!Attack surface reduction rules target certain software behaviors, such as:Launching executable files and scripts that attempt to download or run filesRunning obfuscated or otherwise suspicious scriptsPerforming behaviors that apps don’t usually initiate during normal day-to-day workSuch software behaviors are sometimes seen in legitimate applications. However, these behaviors are often considered risky because they’re commonly abused by attackers through malware. Attack surface reduction rules can constrain software-based risky behaviors and help keep your organization safe.For a sequential, end-to-end process of how to manage attack surface reduction rules, see:Attack surface reduction rules deployment overviewPlan attack surface reduction rules deploymentTest attack surface reduction rulesEnable attack surface reduction rulesOperationalize attack surface reduction rules Read More
How to view 2 weeks in new calendar
This was so easy in the old calendar. All I did was hold the CTRL button and highlight the days I needed to view, I would then be able to see 2 weeks on my screen and all the details of each day within that 2 week timeframe. I have tried everything in the new outlook and cannot figure out how to do this. Please help??? (This is a key feature I use for my business)
This was so easy in the old calendar. All I did was hold the CTRL button and highlight the days I needed to view, I would then be able to see 2 weeks on my screen and all the details of each day within that 2 week timeframe. I have tried everything in the new outlook and cannot figure out how to do this. Please help??? (This is a key feature I use for my business) Read More
Recover Multiple VMs from Azure Backup in Less Time
In the dynamic world of cloud computing, time is often a critical factor, especially when it comes to recovering from disasters like ransomware attacks or rolling back after a problematic security update. Imagine waking up to find your entire set of Azure VMs compromised by ransomware or discovering that a recent security update has left your systems inoperable. The clock starts ticking, and the longer it takes to restore your VMs, the greater the impact on your business.
The Problem
Azure Backup is a robust solution for protecting your Azure VMs, providing peace of mind with its ability to create and manage backup policies, configure backup schedules, and perform reliable restores. However, the features available for Azure Backup in the Portal UI today only allow the restoration of individual VMs one at a time. Restoring many VMs manually through the Azure Portal can be extremely time-consuming and inefficient, especially when you need to restore an entire set of VMs quickly.
Native Capabilities of Azure Backup
Azure Backup offers extensive features for protecting your VMs:
Automated backup schedules and retention policies – A backup policy can protect multiple Azure VMs consisting of a schedule (daily/weekly) and retention (daily, weekly, monthly, yearly).
Cross-region restore capabilities – Allows you to restore data in a secondary, Azure paired region. This can be useful to conduct BCDR drills or if there’s a disaster in the primary region.
Ransomware protection – Features such as irreversible soft-delete, immutable storage and multi-user authorization can be set at the vault level to safeguard backup data.
Despite these powerful features, there is always room for improvement. For now, there is currently no functionality in the Azure Portal to batch restore multiple VMs simultaneously. This limitation becomes a bottleneck in scenarios where speed and efficiency are paramount.
Az PowerShell Module – A Good Solution
To address this gap, we turn to PowerShell scripting, a versatile and powerful tool for managing Azure resources. Microsoft’s Az PowerShell module provides a comprehensive suite of cmdlets to automate and manage Azure tasks, including VM backups and restores.
Here’s a practical approach: a PowerShell script that enables the parallel restoration of multiple VMs from Azure Backup. This script leverages Az.RecoveryServices to streamline the recovery process, significantly reducing the time required to get your systems back online.
Sample PowerShell Script
Below is a summary of how one example script works. You can find the full example here.
Define Variables:
The script starts by defining the necessary variables, including the resource group, recovery services vault, and cache storage account.
$resourceGroup = “rg-webservers”
$recoveryServicesVault = “rsv-vmbackup”
$cacheStorageAccount = “unique626872”
$cacheStorageAccountResourceGroup = “rg-webservers”
Get the Vault and Backup Container:
It then retrieves the Recovery Services Vault and Backup Container containing multiple VMs that need to be restored in parallel.
$vault = Get-AzRecoveryServicesVault -ResourceGroupName $resourceGroup -Name $recoveryServicesVault
$container = Get-AzRecoveryServicesBackupContainer -ContainerType “AzureVM” -VaultId $vault.ID
Loop Through the Backup Items:
The script iterates over each backup item in the container, performing a shutdown and kicking off an in-place restore from the latest recovery points.
foreach ($item in $container) {
# Get the Backup Item from the Vault
$backupItem = Get-AzRecoveryServicesBackupItem -BackupManagementType “AzureVM” -WorkloadType “AzureVM” -VaultId $vault.ID -Name $item.Name
# Get the resource group & VM name for this backupItem
$vmResourceGroup = $backupItem.VirtualMachineId.Split(‘/’)[4]
$vmName = $backupItem.VirtualMachineId.Split(‘/’)[8]
# Shut down the protected VM before restoring it
Stop-AzVM -ResourceGroupName $vmResourceGroup -Name $vmName -Force -SkipShutdown -NoWait
# Get the latest recovery point for the backup item from the last 7 days
$recoveryPoints = Get-AzRecoveryServicesBackupRecoveryPoint -Item $backupItem -VaultId $vault.ID -StartDate (Get-Date).AddDays(-7).ToUniversalTime() -EndDate (Get-Date).ToUniversalTime()
# Restore the Azure VM from the latest recovery point to the original location (replace the source VM)
$OriginalLocationRestoreJob = Restore-AzRecoveryServicesBackupItem -RecoveryPoint $recoveryPoints[0] -StorageAccountName $cacheStorageAccount -StorageAccountResourceGroupName $cacheStorageAccountResourceGroup -VaultId $vault.ID -VaultLocation $vault.Location
}
By using this script, you can dramatically reduce the time required to restore multiple VMs, enhancing your ability to recover from critical incidents swiftly.
Conclusion
In this post, we’ve discussed the limitations in the Azure Portal for handling multiple VM restores and introduced a practical workaround using PowerShell scripting. This solution enables you to restore your VMs in parallel, significantly cutting down recovery time and minimizing business disruption.
We encourage you to modify the sample script, try it out in your test environment and see the benefits for yourself. Your feedback is invaluable, so please share your experiences and let us know your thoughts on this approach. Together, we can continue to improve and innovate in the realm of Azure Business Continuity.
Call to Action
Modify the sample script and try it out in your test environment for parallel VM restoration.
Share your feedback and experiences with us.
Stay tuned for more tips and tricks on maximizing your Azure capabilities.
Happy scripting, and may your recoveries be swift and seamless!
Microsoft Tech Community – Latest Blogs –Read More
Vlookup, Index, Match
Excel idiot here…..
In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left. i.e. If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76. Any help is appreciated!!!
Excel idiot here…..In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left. i.e. If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76. Any help is appreciated!!! Read More
Is it possible to cleanly decommission Windows CA?
So, I have a pain point I am currently dealing with. I joined the company I am with after the AD environment had already been established. There was a fair amount of turnover before I joined and part of that was that the previous System Admins were not thorough with documentation and they did things on a whim. To that, when I joined the PDC was also a CA that, as far as I could tell, was not actively being used by any systems other than the DCs to issue certs. The running theory is that the previous system admins were planning to use CA to do 802.1x type security for Wifi and VPN but never got around to completing the setup.
Obviously, it was not great that they installed the CA role onto the PDC. But I have since corrected that. I was able to extract the CA role and migrate it to a different server and I can see that it is able to issues certs to the DCs. (Looks like it has only issued Kerberos Authentication, DC Authentication, and Directory Email Replication certs since being migrated, and only on DCs). However, I don’t want the CA role around at all because it is one more server we have to maintain and we are not using it in any meaningful way.
I know there is documentation on how to actually decommission a CA from the network (How to decommission a Windows enterprise certification authority and remove all related objects ) but my question is; should/can I decommission it? Throughout my career, every time I have talked to another System Admin or gone through any training, I have always heard that I need to be extremely careful when deciding to add a CA role to a windows network. Because once it is established and issuing certs, it becomes next to impossible to fully/safely remove. Is that the case? Has anyone successfully removed a CA from their windows domain without breaking everything?
So, I have a pain point I am currently dealing with. I joined the company I am with after the AD environment had already been established. There was a fair amount of turnover before I joined and part of that was that the previous System Admins were not thorough with documentation and they did things on a whim. To that, when I joined the PDC was also a CA that, as far as I could tell, was not actively being used by any systems other than the DCs to issue certs. The running theory is that the previous system admins were planning to use CA to do 802.1x type security for Wifi and VPN but never got around to completing the setup. Obviously, it was not great that they installed the CA role onto the PDC. But I have since corrected that. I was able to extract the CA role and migrate it to a different server and I can see that it is able to issues certs to the DCs. (Looks like it has only issued Kerberos Authentication, DC Authentication, and Directory Email Replication certs since being migrated, and only on DCs). However, I don’t want the CA role around at all because it is one more server we have to maintain and we are not using it in any meaningful way. I know there is documentation on how to actually decommission a CA from the network (How to decommission a Windows enterprise certification authority and remove all related objects ) but my question is; should/can I decommission it? Throughout my career, every time I have talked to another System Admin or gone through any training, I have always heard that I need to be extremely careful when deciding to add a CA role to a windows network. Because once it is established and issuing certs, it becomes next to impossible to fully/safely remove. Is that the case? Has anyone successfully removed a CA from their windows domain without breaking everything? Read More
Need Ability to Force Native Resolution on Remote Desktop HTML5 Web Client
Hello,
Not sure if this forum is also for the HTML 5 RD web client but if so, I’d like to request a feature or ask if there’s a way to force the clients to use native resolution. We can force it to use web (vs .RDP) and suppress telemetry but not the native resolution slider. I tried a few DWORDS in HKLMSoftwareMicrosoftRemoteDesktopWeb but no luck.
When we roll this out to hundreds of users, they’ll all have to check that box. Would be nice if we could force it on the admin side with a reg key or the Set-RDWebClientDeploymentSetting cmdlet.
thanks,
Dan
Hello, Not sure if this forum is also for the HTML 5 RD web client but if so, I’d like to request a feature or ask if there’s a way to force the clients to use native resolution. We can force it to use web (vs .RDP) and suppress telemetry but not the native resolution slider. I tried a few DWORDS in HKLMSoftwareMicrosoftRemoteDesktopWeb but no luck. When we roll this out to hundreds of users, they’ll all have to check that box. Would be nice if we could force it on the admin side with a reg key or the Set-RDWebClientDeploymentSetting cmdlet. thanks,Dan Read More
Formula trouble
I want to do this thing, but I have no idea where to start or what type of formulas to try:
I’m tracking evaluations in my company
Column E is the type of evaluation: Initial F, and Initial E.
Column G is the date their evaluation process was initiated
Column H is the date their evaluation process closes out.
People designated “Initial F” in column E have a close out date (Column H) that is 60 days after their initiation date (Column G)
People designated “Initial E” in column E have a close out date (Column H) that is 45 days after their initiation date (Column G)
I want column H to automatically generate a date that is respectively, 45 or 60 days after the date in column G based on the condition in column E.
I want to do this thing, but I have no idea where to start or what type of formulas to try:I’m tracking evaluations in my company Column E is the type of evaluation: Initial F, and Initial E. Column G is the date their evaluation process was initiatedColumn H is the date their evaluation process closes out. People designated “Initial F” in column E have a close out date (Column H) that is 60 days after their initiation date (Column G)People designated “Initial E” in column E have a close out date (Column H) that is 45 days after their initiation date (Column G) I want column H to automatically generate a date that is respectively, 45 or 60 days after the date in column G based on the condition in column E. Read More
Bookings Emails Deleting automatically
I am an IT admin for Bookings at our organization. One of our staff members noticed her Bookings meeting confirmations are automatically directed to her trash. I assume this is because the meeting invite is accepted automatically on her behalf. Unfortunately, pertinent information is on those emails (such as notes and customer responses). We have tried to make mailbox rules as well as toggle “ignored” emails off but to no avail. Please advise.
I am an IT admin for Bookings at our organization. One of our staff members noticed her Bookings meeting confirmations are automatically directed to her trash. I assume this is because the meeting invite is accepted automatically on her behalf. Unfortunately, pertinent information is on those emails (such as notes and customer responses). We have tried to make mailbox rules as well as toggle “ignored” emails off but to no avail. Please advise. Read More
Formula to autofill a PO #
I have a workbook with 2 sheets.
Sheet 1, column A is where the formula needs to go – based off the information in the sheet called Customer list.
Example: Customer List – Column A is customer name – Column B is the PO# Starting String. This is specific to the customer.
I want to open Sheet 1 and type a customer name in B2 and a PO number automatically fill in based off the criteria mentioned above. So if my Customer name is Asset Living (on sheet: Customer List – A2) and I type Asset Living in Sheet 1, B2, the the PO# that populates in Sheet 1 A2 should be AL(from Customer List, B2) followed by random numbers (preferrably 3 digits).
I have a workbook with 2 sheets.Sheet 1, column A is where the formula needs to go – based off the information in the sheet called Customer list.Example: Customer List – Column A is customer name – Column B is the PO# Starting String. This is specific to the customer.I want to open Sheet 1 and type a customer name in B2 and a PO number automatically fill in based off the criteria mentioned above. So if my Customer name is Asset Living (on sheet: Customer List – A2) and I type Asset Living in Sheet 1, B2, the the PO# that populates in Sheet 1 A2 should be AL(from Customer List, B2) followed by random numbers (preferrably 3 digits). Read More
xlookup with table issue
Hello!
I am working on a file that requires use of xlookup. to keep things organized and for ease of reviewal, i use the table headers in the formulas (instead of just column letter). I realized that my formulas are not working properly. when I set the formula up, it only seems to return the value that appears first in the lookup array.
For example, I am trying to find and return three different things: call them A, B, and C. In the table that I am doing the lookup from, if A, B, and C are listed in that order, then my lookups will only have one that works, and it will return A. During trouble shooting, I deleted the rows that had A and B, leaving only C. Once I did this, the C was the first lookup value in the lookup table, and the formula worked (it returned C). This informs me that it is not an error of difference of spelling / spaces / etc. in lookup value and items in lookup array.
Also during troubleshooting, I used the column letters as opposed to the table header names in the formula, and it worked perfect.
Has anyone experienced this before / does anyone have any tips???
Hello! I am working on a file that requires use of xlookup. to keep things organized and for ease of reviewal, i use the table headers in the formulas (instead of just column letter). I realized that my formulas are not working properly. when I set the formula up, it only seems to return the value that appears first in the lookup array. For example, I am trying to find and return three different things: call them A, B, and C. In the table that I am doing the lookup from, if A, B, and C are listed in that order, then my lookups will only have one that works, and it will return A. During trouble shooting, I deleted the rows that had A and B, leaving only C. Once I did this, the C was the first lookup value in the lookup table, and the formula worked (it returned C). This informs me that it is not an error of difference of spelling / spaces / etc. in lookup value and items in lookup array. Also during troubleshooting, I used the column letters as opposed to the table header names in the formula, and it worked perfect. Has anyone experienced this before / does anyone have any tips??? Read More
Drive Encryption through Endpoint Security no longer showing option to backup information in Entra
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug?
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug? Read More
Improve your forms with Copilot suggestions
Copilot has always been helpful at crafting forms and fine-tuning questions. Now, it also serves as an intelligent assistant throughout your journey, offering additional smart suggestions. By using these tips, you can make your form/quiz more attractive and easier to complete, leading to better results with less effort. Let’s check it now!
How to activate
For any newly created or existing forms/quizzes, a banner at the top will remind you that Copilot has suggestions for you. You can just click ‘View’ to check the details.
Theme suggestion
Responder’s first impression of your form is crucial, and a visually appealing design can certainly capture their attention. Copilot will start by offering several theme options based on your topic, helping you choose a look that grabs their interest.
Setting suggestion
Based on your content, Copilot will suggest settings to make your form more effective. For example, it might remind you to allow responders to save and edit their responses for more accurate feedback or set a timer for improved time management.
Distribution suggestion
Additionally, Copilot will guide you through sending out your form to help you gather more responses. Without needing to open ‘Collect Responses,’ Copilot will draft a personalized message to boost responses and help set the appropriate permissions. You only need to enter the responders’ details and send out the form.
Copilot in Forms assistant will start rolling out to commercial users (including Enterprise, SMB and EDU) in late July 2024. A Copilot for Microsoft 365 license is required to access Copilot in Forms. Discover more about Copilot for Microsoft 365 here.
Microsoft Tech Community – Latest Blogs –Read More