Tag Archives: microsoft
What is Quick.Books Error OL-222 and how can it be resolved?
I’m encountering Quick.Books Error OL-222 when trying to import my bank transactions. It says something about an unsupported format. How can I resolve this issue and successfully import my bank data?
I’m encountering Quick.Books Error OL-222 when trying to import my bank transactions. It says something about an unsupported format. How can I resolve this issue and successfully import my bank data? Read More
MS cloud defender- Machines should have vulnerability findings resolved -Update Openssl
Can someone help me with how I can get rid from Update Openssl version to latest vulnerable version. attached are the screenshots and these issues are coming in Visual Studio 2022, Visual Studio 2017, and pluginsmicrosoft.azure.security.azurediskencryption2.4.0.23azureattestskr
I am not seeing any way to update it.
Can someone help me with how I can get rid from Update Openssl version to latest vulnerable version. attached are the screenshots and these issues are coming in Visual Studio 2022, Visual Studio 2017, and pluginsmicrosoft.azure.security.azurediskencryption2.4.0.23azureattestskr
I am not seeing any way to update it.
Govern your Azure Firewall configuration with Azure Policies
Introduction:
In the rapidly evolving digital landscape, securing cloud environments is more critical than ever. Azure Firewall emerges as a pivotal defense mechanism, offering stateful, cloud-native, and intelligent network firewall security services. It’s designed to protect Azure Virtual Network resources and maintain the integrity of cloud workloads. With its high availability and unrestricted cloud scalability, Azure Firewall ensures robust protection against a myriad of cyber threats.
However, the true strength of Azure Firewall lies not only in its protective capabilities but also in its governability. The configuration of Azure Firewall is a vital aspect that demands meticulous management to ensure that security policies are not only enforced but also aligned with the organization’s compliance and governance standards. This is where Azure Policy comes into play, providing a framework to enforce organizational standards and to assess compliance at scale. Its compliance dashboard offers an aggregated view to evaluate the overall environment state, allowing drill-down analysis at the per-resource and per-policy level.
In this blog, we will unravel how Azure Policy can be leveraged to govern Azure Firewall configurations, ensuring a fortified and compliant network security posture.
Azure Policy for Azure Firewall:
Azure Policy is a service in Azure that allows you to create, assign, and manage policies. These policies enforce different rules and effects over your resources, so those resources stay compliant with your corporate standards and service level agreements. Azure Policy does this by evaluating your resources for non-compliance with assigned policies. For example, you can have a policy to allow only a certain SKU size of virtual machines in your environment or to enforce a specific tag on resources.
Azure Policy can be used to govern Azure Firewall configurations by applying policies that define what configurations are allowed or disallowed. This helps ensure that the firewall settings are consistent with organizational compliance requirements and security best practices.
Available Policies for Azure Firewall:
Enable Threat Intelligence in Azure Firewall Policy: This policy makes sure that any Azure Firewall configuration without threat intel enabled will be marked as non-compliant.
Deploy Azure Firewall across Multiple Availability Zones: The policy restricts Azure Firewall deployment to be only allowed with Multiple Availability Zone configuration.
Upgrade Azure Firewall Standard to Premium: This policy recommends the upgradation of Azure Firewall Standard Deployments to Premium so that all the Next Gen Protection firewalls of the Premium SKU can be utilized. This will further enhance the security posture of the environment.
Azure Firewall Policy Analytics should be enabled: This policy ensures that the Policy Analytics is enabled on the firewall to effectively tune and optimize firewall rules.
Azure Firewall should only allow Encrypted Traffic: This policy analyses existing rules and ports in azure firewall policy and audits firewall policy to make sure that only encrypted traffic is allowed into the environment.
Azure Firewall should have DNS Proxy Enabled: This Policy Ensures that DNS proxy feature is enabled on Azure Firewall deployments.
Enable IDPS in Azure Firewall Premium Policy: This policy ensures that the IDPS feature is enabled on Azure Firewall deployments to effectively protect the environment from various threats and vulnerabilities.
Enable TLS inspection on Azure Firewall Policy: This policy mandates the enablement of TLS inspection feature to detect, alert, and mitigate malicious activity in HTTPS traffic.
Migrate from Azure Firewall Classic Rules to Firewall Policy: This policy recommends migrating from Firewall Classic Rules to Firewall Policy.
VNET with specific tag must have Azure Firewall Deployed: This policy finds all VNETs with a specified Tag and checks if there is an Azure Firewall deployed and flags as non-compliant if no Azure Firewall exists.
Using Azure Policy to Govern Azure Firewall Configuration: The following steps outline the process of creating and assigning a policy definition to a particular Resource Group within Azure.
Define the Policy: Start by defining the policy that aligns with your security requirements. This includes specifying the allowed firewall SKUs, required tags, and the necessary rules and settings. Check out the Policy Definition Structure and Aliases from Azure documentation to understand how a custom policy can be built. Additionally, you can leverage the pre-built policy definitions that are available in the Net Sec GitHub Repository to build a custom policy. Moreover, Azure offers built-in policies which are accessible from the Definitions tab in the Policy blade. These policies can be directly assigned to a scope as outlined in the process below. Note that most of the policies from the above-mentioned GitHub repository will soon be integrated as built-in policies within Azure.
Creating a New Policy Definition: The policy depicted in the image below performs an audit on the Azure Firewall Policy deployments in the specified scope. If Threat Intelligence is not enabled the policy marks the audited resource as ‘non-compliant’. This allows the Firewall Administrator to take the necessary action of enabling the required feature to address the compliance issues. Additionally, we can also deploy a policy that blocks any resources which do not match the specified condition.
Assign the Policy: Once the policy is defined, assign it to the relevant scope, such as a subscription, resource group, or individual resources. This determines where the policy will be enforced.
Monitor Compliance: Use Azure Policy’s compliance data to monitor and ensure that your Azure Firewall configurations remain compliant with the assigned policies. Non-compliant resources can be identified and remediated.
Audit and Enforce: Policies can be set to audit existing configurations and enforce new configurations, ensuring ongoing compliance and security of your Azure Firewall.
Conclusion: By leveraging Azure Policy in conjunction with Azure Firewall, you can maintain a strong security posture, automate compliance tasks, and ensure that your cloud environment adheres to the necessary regulations and standards. This integration simplifies the governance of your network security and helps protect your resources from potential threats.
Microsoft Tech Community – Latest Blogs –Read More
Supercharge your datacenters with Hyper-V and virtualized GPUs
Windows Server 2025 is the most secure and performant release yet! Download the evaluation now!
Looking to migrate from VMware to Windows Server 2025? Contact your Microsoft account team!
Looking to migrate from VMware to Windows Server 2025? Contact your Microsoft account team!
The 2024 Windows Server Summit was held in March and brought three days of demos, technical sessions, and Q&A, led by Microsoft engineers, guest experts from Intel®, and our MVP community. For more videos from this year’s Windows Server Summit, please find the full session list here.
This article talks about virtualized GPUs with Hyper-V in Windows Server 2025.
Supercharge your datacenters with Hyper-V and virtualized GPUs
This session will dive into new GPU features on Windows Server and Azure Stack HCI, including GPU failover clustering and GPU partitioning (GPU-P). GPU-P, or GPU virtualization, is a new feature that allows users to share a physical GPU-P device with multiple virtual machines. With GPU-P, each virtual machine (VM) gets a dedicated portion of the GPU capacity instead of the entire GPU. This translates into more cost efficiency for your organization as you can assign GPU resources where needed. Join us as we share more on this new feature and run through multiple exciting demos.
Microsoft Tech Community – Latest Blogs –Read More
Bringing Multiple Columns Over from VLOOKUP Table
Howdy folks,
Looking for advice on a VLOOKUP task and how you might handle it.
In this example, I have a template that has fixed values in the rows (Department names), and two columns (Charges and Receipts).
DepartmentChargesReceiptsCATEGORY III CODES EP OFFICE PREVENTATIVE JOINT INJECTION LESION/ABSCESS MEDICAL MISCELLANEOUS NP OFFICE NP PREVENTIVE PQRS PROCEDURES
I also have a pivot table that is formatted in the same way, but does not always have values for each Department row.
USE DEPTSum of ChargesSum of PaymentsEP OFFICE $116,499.00 $33,516.18MISCELLANEOUS $- $22.00NP OFFICE $6,776.00 $1,785.11PQRS $0.43 $0.01
Normally, what I would do, is in the first Charges cell on the empty table (B2) I would do a formula combining an iferror with a vlookup, reference the Department name in Column A on the first table with Department name in column A of my pivot table, to pull over the Charges in the second column. Then I would have to type almost the same formula again under the Receipts column, but pull from column 3.
I’m doing much larger tables than just this example set. Is there a way to quickly either drag the iferror(vlookup) formula, or copy and paste it, across multiple columns on the empty table, while changing the column number that it pulls from the pivot table to correspond?
I can lock in the lookup value and the table array values using $ to prevent them from shifting as the formula is copied or dragged across, but the index number always remains the same when doing that. In the example above, if I put my formula in the empty Charges column, used $ to lock in the lookup value to that column, selected my entire pivot table, and indexed on column two (charges), then copied that formula over to the next column (receipts) it would still pull the charges from the pivot.
I want to be able to copy/drag that vlookup across 50+ columns and hundreds of rows, without having to then manually change the index number in row one in every single column to match the column from the array, before then copying/dragging that down each subsequent column.
Clear? Confusing?
Thoughts?
Thanks in advance.
Travis
Howdy folks,Looking for advice on a VLOOKUP task and how you might handle it. In this example, I have a template that has fixed values in the rows (Department names), and two columns (Charges and Receipts).DepartmentChargesReceiptsCATEGORY III CODES EP OFFICE PREVENTATIVE JOINT INJECTION LESION/ABSCESS MEDICAL MISCELLANEOUS NP OFFICE NP PREVENTIVE PQRS PROCEDURES I also have a pivot table that is formatted in the same way, but does not always have values for each Department row.USE DEPTSum of ChargesSum of PaymentsEP OFFICE $116,499.00 $33,516.18MISCELLANEOUS $- $22.00NP OFFICE $6,776.00 $1,785.11PQRS $0.43 $0.01 Normally, what I would do, is in the first Charges cell on the empty table (B2) I would do a formula combining an iferror with a vlookup, reference the Department name in Column A on the first table with Department name in column A of my pivot table, to pull over the Charges in the second column. Then I would have to type almost the same formula again under the Receipts column, but pull from column 3.I’m doing much larger tables than just this example set. Is there a way to quickly either drag the iferror(vlookup) formula, or copy and paste it, across multiple columns on the empty table, while changing the column number that it pulls from the pivot table to correspond? I can lock in the lookup value and the table array values using $ to prevent them from shifting as the formula is copied or dragged across, but the index number always remains the same when doing that. In the example above, if I put my formula in the empty Charges column, used $ to lock in the lookup value to that column, selected my entire pivot table, and indexed on column two (charges), then copied that formula over to the next column (receipts) it would still pull the charges from the pivot. I want to be able to copy/drag that vlookup across 50+ columns and hundreds of rows, without having to then manually change the index number in row one in every single column to match the column from the array, before then copying/dragging that down each subsequent column. Clear? Confusing? Thoughts? Thanks in advance. Travis Read More
What troubleshooting steps can Quick-Books Data Migration Services resolve?
I’m experiencing issues with Quick-Books Data Migration Services. The migration process is failing, and I’m unable to transfer my data smoothly. What could be causing these problems, and how can I troubleshoot and resolve them to ensure a successful data migration?
I’m experiencing issues with Quick-Books Data Migration Services. The migration process is failing, and I’m unable to transfer my data smoothly. What could be causing these problems, and how can I troubleshoot and resolve them to ensure a successful data migration? Read More
i want to count the accrue interest for loan and tag either its new or recurring customer
hi to all the experts here..
i need your help to count the accrue interest and tag customer which its a new customer or recurring.
i need to count the accrue interest in column H with condition as below:
1. if the status in column “J” is “unpaid”, hence i need the formula of accrued interest running until the status changed to paid.
2. the loan tenor is 30 days, so the accrue interest should start from day 1 after disburse date until loan due date.
3. if the loan is unpaid until the due date, column H also need to calculate the late fee but with condition that if days past due (column K) is between day 1-5 it wont calculate the late fee, late fee only occurs in day 6, which is [1 day*0.05%*disburse amount], if the days past due (column K) is 7 hence the formula is [2 days*0.05%*disburse amount]
also for column I, i need to have a formula where if the customer name in column A is the first to came hence the status in column I is “New” but if the customer name cames up again for the 2nd time then its a “recurring”
let me know im not clear because english is not my 1st language, i can try to rephrase my word later..
thankyou!!!
hi to all the experts here..i need your help to count the accrue interest and tag customer which its a new customer or recurring. i need to count the accrue interest in column H with condition as below:1. if the status in column “J” is “unpaid”, hence i need the formula of accrued interest running until the status changed to paid.2. the loan tenor is 30 days, so the accrue interest should start from day 1 after disburse date until loan due date.3. if the loan is unpaid until the due date, column H also need to calculate the late fee but with condition that if days past due (column K) is between day 1-5 it wont calculate the late fee, late fee only occurs in day 6, which is [1 day*0.05%*disburse amount], if the days past due (column K) is 7 hence the formula is [2 days*0.05%*disburse amount] also for column I, i need to have a formula where if the customer name in column A is the first to came hence the status in column I is “New” but if the customer name cames up again for the 2nd time then its a “recurring” let me know im not clear because english is not my 1st language, i can try to rephrase my word later.. thankyou!!! Read More
How do i contact Q.B Desktop support number?
I’m encountering Quick-Books Error and need urgent assistance. Can someone provide the Quick-Books Desktop support number and any community resources for help? Your guidance would be greatly appreciated.
I’m encountering Quick-Books Error and need urgent assistance. Can someone provide the Quick-Books Desktop support number and any community resources for help? Your guidance would be greatly appreciated. Read More
Excel VLOOKUP with Multiple Criteria (Dynamic Price Tiers) to determine Markup Price
I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers).
I have tried these formulae with no success:
1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)
2. To get the % rate, I used: =LOOKUP(I3,tiers,customers)
I would appreciate any help.
Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel.
Again, I would appreciate your help in solving this problem.
I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers). I have tried these formulae with no success: 1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)2. To get the % rate, I used: =LOOKUP(I3,tiers,customers) I would appreciate any help. Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel. Again, I would appreciate your help in solving this problem. Read More
Access crashing directly on start
Hello,
since this morning Access is always crashing directly on start without any comment.
I had trouble since some month that Access was crashing during development several times a day. But i could accept that, as i always save the Db under different Version number, after some changes.
But the problem now is that i even can not start Access directly from the Start-menue, without selecting a specific file.
Any idea how i can fix this issue?
Hello,since this morning Access is always crashing directly on start without any comment.I had trouble since some month that Access was crashing during development several times a day. But i could accept that, as i always save the Db under different Version number, after some changes.But the problem now is that i even can not start Access directly from the Start-menue, without selecting a specific file. Any idea how i can fix this issue? Read More
Make a contact that we can call by phone number.
Hello
Please i need your help on this issue.
i have added a contact in our tenant, and i want it to default to dial the phone number if i place a call from Teams to this contact. Now it tries to call by e-mail address.
Hello Please i need your help on this issue. i have added a contact in our tenant, and i want it to default to dial the phone number if i place a call from Teams to this contact. Now it tries to call by e-mail address. Read More
How Can I Resolve Error PS038 in Quick-Books?
I’m encountering Error PS038 in Quick-Books when trying to update. It’s causing a lot of disruption in my workflow. What could be causing this error, and what steps can I take to troubleshoot and resolve it?
I’m encountering Error PS038 in Quick-Books when trying to update. It’s causing a lot of disruption in my workflow. What could be causing this error, and what steps can I take to troubleshoot and resolve it? Read More
PivotTable issue with duplicating field
Hello,
So a colleague of mine has set-up a pivot table for a consultation, with the entries of agree and disagree (and not answered). They’ve drawn this from imported data from a website we use for consultations.
They’ve added three additional responses, that fall under the “agree” category, however when they generated the pivot table, it’s generating a separate row for “Agree”. So say there are 15 agrees, 14 disagrees, 4 no responses and 3 agrees.
Is there a way to roll these 3 extraneous agrees into the larger set of agrees? I have a vague sense that it requires refreshing the “table” based on when I had a similar issue, but I can’t remember exactly sorry.
Thank you.
Hello, So a colleague of mine has set-up a pivot table for a consultation, with the entries of agree and disagree (and not answered). They’ve drawn this from imported data from a website we use for consultations. They’ve added three additional responses, that fall under the “agree” category, however when they generated the pivot table, it’s generating a separate row for “Agree”. So say there are 15 agrees, 14 disagrees, 4 no responses and 3 agrees. Is there a way to roll these 3 extraneous agrees into the larger set of agrees? I have a vague sense that it requires refreshing the “table” based on when I had a similar issue, but I can’t remember exactly sorry. Thank you. Read More
How do I contact Quick-Books Enterprise support number?
I’m experiencing issues with my Quick-Books Enterprise software and need to contact support. What is the Quick-Books Enterprise support number, and are there any troubleshooting steps I can try before reaching out to them?
I’m experiencing issues with my Quick-Books Enterprise software and need to contact support. What is the Quick-Books Enterprise support number, and are there any troubleshooting steps I can try before reaching out to them? Read More
File on SharePoint via teams app or shortcut is always locked for editing
Hello
Please i need your help on this issue.
We have setup Teams sharing for 2 @ users and synced to explorer – whenever i try open an excel file that has been closed for 30 mins it says its locked for editing and read only option is there
Hello Please i need your help on this issue. We have setup Teams sharing for 2 @ users and synced to explorer – whenever i try open an excel file that has been closed for 30 mins it says its locked for editing and read only option is there Read More
Exchange Upgrade Support
Dear Team,
Regarding the Exchange Server 2019 upgrade from 2016 versions, seeking confirmation on clarification on the best practices for migrating from 2016 to 2019 with the following setup.
We have Exchange server 2016 DAG with 2 servers and it has been configured with the hybrid setup. 2000 mailboxes already migrated and around 1500 mailboxes are in On-prem. We would like to migrate our existing Exchange Server environment to 2019 and The goal is to continue using the exchange infrastructure for a couple more years.Also, we are planning to deploy a load balancer in the primary site.As per our BCDR planning, the new environment will include a third DAG server in the DR site, with a decision pending on whether to extend to a fourth node. The load balancer will be implemented at the primary site only, not the DR site.
Dear Team, Regarding the Exchange Server 2019 upgrade from 2016 versions, seeking confirmation on clarification on the best practices for migrating from 2016 to 2019 with the following setup.We have Exchange server 2016 DAG with 2 servers and it has been configured with the hybrid setup. 2000 mailboxes already migrated and around 1500 mailboxes are in On-prem. We would like to migrate our existing Exchange Server environment to 2019 and The goal is to continue using the exchange infrastructure for a couple more years.Also, we are planning to deploy a load balancer in the primary site.As per our BCDR planning, the new environment will include a third DAG server in the DR site, with a decision pending on whether to extend to a fourth node. The load balancer will be implemented at the primary site only, not the DR site. Read More
Multiple forests with same local domain
Hello,
Before we drop this idea completely just wanted to check with the community if this setup is even possible. We have our main local domain which is configured with AD Connect and all devices are hybrid joined. This works well. Additionally, we have a multiple small separate domains, no trusts or connections between them and our main domain. User account and hostnames are unique and exist in single domain only. We wanted to use AD Connect to synchronize all of them into single Azure tenant and make all devices hybrid joined and enrolled into Intune. From what I understand, in this scenario you can only have one AD Connect server. This obstacle we can overcome. All separate domains have exactly same forest name in .local, let’s say example.local. I know .local domain is not allowed, so we can create additional UPN to match our main office UPN. But is it possible to add multiple, separate forests with same UPN suffix into Connector? Should I create unique UPN suffixes for each? A lot of users from those separate domain already have cloud only account because they use Exchange Online mailbox. Hope this is clear enough to give some answers.
Hello, Before we drop this idea completely just wanted to check with the community if this setup is even possible. We have our main local domain which is configured with AD Connect and all devices are hybrid joined. This works well. Additionally, we have a multiple small separate domains, no trusts or connections between them and our main domain. User account and hostnames are unique and exist in single domain only. We wanted to use AD Connect to synchronize all of them into single Azure tenant and make all devices hybrid joined and enrolled into Intune. From what I understand, in this scenario you can only have one AD Connect server. This obstacle we can overcome. All separate domains have exactly same forest name in .local, let’s say example.local. I know .local domain is not allowed, so we can create additional UPN to match our main office UPN. But is it possible to add multiple, separate forests with same UPN suffix into Connector? Should I create unique UPN suffixes for each? A lot of users from those separate domain already have cloud only account because they use Exchange Online mailbox. Hope this is clear enough to give some answers. Read More
Outgoing mail is considered spam
Hi,
I have a user in our tenant who sends emails to multiple people at one time. The maximum number is 200 recipients at a time per day. This concerns 1 email with, for example, 200 recipients. Now, after the email has been sent, this user is marked as Spam and the account is blocked. When I then look at the reason, it says Domain reputation.
The user also remains within Microsoft’s sent limits.
How can I find out or where can I within O365 what the exact reason is why this user is blocked and the email is considered spam.
There are several users who do this and do not receive any notifications.
Can someone help me with this?
Kind regards,
Jacob
Hi, I have a user in our tenant who sends emails to multiple people at one time. The maximum number is 200 recipients at a time per day. This concerns 1 email with, for example, 200 recipients. Now, after the email has been sent, this user is marked as Spam and the account is blocked. When I then look at the reason, it says Domain reputation. The user also remains within Microsoft’s sent limits.How can I find out or where can I within O365 what the exact reason is why this user is blocked and the email is considered spam.There are several users who do this and do not receive any notifications.Can someone help me with this? Kind regards,Jacob Read More
Enrolling devices over mobile network (QR Code)
Hi All,
I have been asked the question , can an Android device be enrolled over mobile networks if WiFi wasn’t available. Using a QR code scan.
I have done some Googling and the main answer is to amend the QR code to enable enrolment over mobile networks, but the post’s are from 2020.
Has a method been added to Intune to allow this kind of enrolment.?
I have tried on a device with an active sim card in but get stuck at the Wifi select screen.
Any help appreciated.
Hi All, I have been asked the question , can an Android device be enrolled over mobile networks if WiFi wasn’t available. Using a QR code scan. I have done some Googling and the main answer is to amend the QR code to enable enrolment over mobile networks, but the post’s are from 2020. Has a method been added to Intune to allow this kind of enrolment.? I have tried on a device with an active sim card in but get stuck at the Wifi select screen. Any help appreciated. Read More
Best way to download youtube playlist to mp3 on my computer?
I am very interested in a YouTube playlists, which contains dozens of my favorite songs. I hope I could download the whole YouTube playlist to MP3 so I can listen them on my Windows 11 PC and my car.
I need some advice on how to download YouTube playlist to MP3 on my computer. I have found some tools and methods online, but I’m not sure which ones are reliable and safe to use. Does anyone have any recommendations for software or websites that can do this effectively without any risk of malware or poor quality? I’m open to both free and paid options as long as they work well.Thank you
I am very interested in a YouTube playlists, which contains dozens of my favorite songs. I hope I could download the whole YouTube playlist to MP3 so I can listen them on my Windows 11 PC and my car. I need some advice on how to download YouTube playlist to MP3 on my computer. I have found some tools and methods online, but I’m not sure which ones are reliable and safe to use. Does anyone have any recommendations for software or websites that can do this effectively without any risk of malware or poor quality? I’m open to both free and paid options as long as they work well.Thank you Read More