Category: Microsoft
Category Archives: Microsoft
What To Do When QuickBooks Not Opening company file After Windows update?
Troubleshooting Solutions : QuickBooks Not Opening company file
Experiencing difficulties with QuickBooks Not Opening company file can be frustrating, but several troubleshooting steps can help resolve the issue:
Check for System Requirements: Ensure that your computer meets the minimum system requirements to run QuickBooks. Inadequate system resources can cause performance issues.
Verify File Location and Permissions: Make sure that the company file is stored in a location where QuickBooks can access it. Additionally, check the file permissions to ensure that QuickBooks has the necessary permissions to open and modify the file.
Run QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool provided by Intuit to identify and resolve issues with company files. Running this tool can help detect and repair common file-related problems.
Update QuickBooks to the Latest Version: Ensure that you are using the latest version of QuickBooks. Intuit regularly releases updates and patches to address bugs and improve stability. Updating to the latest version may resolve the issue you’re experiencing.
Disable Antivirus or Firewall Software Temporarily: Sometimes, antivirus or firewall software can interfere with QuickBooks’ ability to access company files. Temporarily disabling these programs and then attempting to open the company file can help determine if they are the cause of the problem.
Use QuickBooks Clean Install Tool: The QuickBooks Clean Install Tool is designed to remove QuickBooks components and reinstall them cleanly. Performing a clean install can resolve issues related to corrupted installation files or settings.
Restore a Backup of the Company File: If you have a recent backup of the company file, try restoring it to see if the issue persists. This can help determine if the problem is specific to the current company file or if it is a more general QuickBooks issue.
Create a New Company File: As a last resort, creating a new company file and transferring data to it can help if the original file is irreparably damaged. Be sure to consult with a QuickBooks expert or refer to Intuit’s documentation for guidance on this process.
By following these troubleshooting solutions, you should be able to diagnose and resolve the issue of QuickBooks Not Opening company file. If the problem persists after trying these steps, it may be necessary to contact QuickBooks support for further assistance.
Troubleshooting Solutions : QuickBooks Not Opening company file Experiencing difficulties with QuickBooks Not Opening company file can be frustrating, but several troubleshooting steps can help resolve the issue: Check for System Requirements: Ensure that your computer meets the minimum system requirements to run QuickBooks. Inadequate system resources can cause performance issues.Verify File Location and Permissions: Make sure that the company file is stored in a location where QuickBooks can access it. Additionally, check the file permissions to ensure that QuickBooks has the necessary permissions to open and modify the file.Run QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool provided by Intuit to identify and resolve issues with company files. Running this tool can help detect and repair common file-related problems.Update QuickBooks to the Latest Version: Ensure that you are using the latest version of QuickBooks. Intuit regularly releases updates and patches to address bugs and improve stability. Updating to the latest version may resolve the issue you’re experiencing.Disable Antivirus or Firewall Software Temporarily: Sometimes, antivirus or firewall software can interfere with QuickBooks’ ability to access company files. Temporarily disabling these programs and then attempting to open the company file can help determine if they are the cause of the problem.Use QuickBooks Clean Install Tool: The QuickBooks Clean Install Tool is designed to remove QuickBooks components and reinstall them cleanly. Performing a clean install can resolve issues related to corrupted installation files or settings.Restore a Backup of the Company File: If you have a recent backup of the company file, try restoring it to see if the issue persists. This can help determine if the problem is specific to the current company file or if it is a more general QuickBooks issue.Create a New Company File: As a last resort, creating a new company file and transferring data to it can help if the original file is irreparably damaged. Be sure to consult with a QuickBooks expert or refer to Intuit’s documentation for guidance on this process. By following these troubleshooting solutions, you should be able to diagnose and resolve the issue of QuickBooks Not Opening company file. If the problem persists after trying these steps, it may be necessary to contact QuickBooks support for further assistance. Read More
Partner Center MPN ID
I was trying to access the solutions designation center on the partner center dashboard but got the following error:
I have read the how to guides to gain the Microsoft Partner Network ID but could not find that in the partner center dashboard.
Thanks & Regards
Siddhartha Sharma
I was trying to access the solutions designation center on the partner center dashboard but got the following error:I have read the how to guides to gain the Microsoft Partner Network ID but could not find that in the partner center dashboard. Thanks & RegardsSiddhartha Sharma Read More
“Transcript and captions” disappear from Audio settings list
Hello
I uploaded a .mp4 audio file to Sharepoint Stream, then I generated the caption/transcript and successfully downloaded it in word. However, when I checked it today, the “Transcript and captions” option is disappeared from the Audio settings list. The caption is still displaying on the audio but there is no way for me to download it again. Could you please help? Thanks.
The caption is still working on the audio:
No “Transcript and captions”:
Hello I uploaded a .mp4 audio file to Sharepoint Stream, then I generated the caption/transcript and successfully downloaded it in word. However, when I checked it today, the “Transcript and captions” option is disappeared from the Audio settings list. The caption is still displaying on the audio but there is no way for me to download it again. Could you please help? Thanks. The caption is still working on the audio: No “Transcript and captions”: Read More
Usage average should have returned zero
Hi Folks,
I am a bit puzzled why when using Average the result did not return (0)
There is two examples:
Example A: starts and ends with a value of 1000 and returns 0.027%
Example B: starts and ends with a value of 1000 and returns 0.000%
Should Example A not have returned 0.000% too?
Perhaps the ‘Average’ formula is wrong
The maths don’t seem to add up.xlsx
Hi Folks, I am a bit puzzled why when using Average the result did not return (0) There is two examples: Example A: starts and ends with a value of 1000 and returns 0.027% Example B: starts and ends with a value of 1000 and returns 0.000% Should Example A not have returned 0.000% too? Perhaps the ‘Average’ formula is wrong The maths don’t seem to add up.xlsx Read More
Is Your QuickBooks Desktop Running Slow? Learn How to Fix It
QuickBooks Desktop is a powerful tool for managing finances, but if it’s running slow, it can hinder productivity and frustrate users. Slow performance can be caused by various factors, from system issues to data file size. In this article, we’ll explore common reasons why QuickBooks Desktop may be running slow and provide practical solutions to optimize its performance, ensuring a smooth and efficient workflow.
Identifying the Problem:
Before diving into solutions, it’s essential to understand why QuickBooks Desktop might be running slow. Some common culprits include:
Large Data File Size: Over time, as your company file grows in size, it can impact QuickBooks performance.Insufficient System Resources: Inadequate RAM, processor speed, or hard drive space can contribute to sluggish performance.Network Issues: Slow network connectivity or an overloaded server can affect QuickBooks’ ability to access data.Outdated Software: Using an outdated version of QuickBooks Desktop or outdated hardware drivers can lead to compatibility issues and reduced performance.
Solutions to QuickBooks Desktop Running Slow:
Optimize Company File:
Condense large company files to remove outdated transactions and reduce file size.Run the Verify and Rebuild Data utility in QuickBooks to identify and fix data integrity issues.Archive old data into separate files to keep the current company file size manageable.
Upgrade Hardware and Software:
Ensure your computer meets QuickBooks’ system requirements, including RAM, processor speed, and hard drive space.Consider upgrading hardware components such as RAM or SSD for improved performance.Keep QuickBooks Desktop and your operating system up to date with the latest updates and patches.
Adjust Preferences and Settings:
Modify QuickBooks preferences to optimize performance, such as turning off automatic updates or reducing the number of open windows.Adjust backup settings to perform backups during off-peak hours to avoid impacting system performance during busy periods.
Optimize Network Configuration:
Ensure that your network infrastructure meets QuickBooks’ network requirements, including stable connectivity and sufficient bandwidth.Consider upgrading network hardware or using a wired connection instead of Wi-Fi for faster data transfer speeds.
Perform Regular Maintenance:
Clean up temporary files, cache, and unnecessary background processes on your computer to free up system resources.Defragment your hard drive regularly to improve data access speed and overall system performance.
Conclusion:
QuickBooks Desktop running slow can be a frustrating issue, but by identifying the underlying causes and implementing targeted solutions, you can optimize performance and streamline your workflow. Whether it’s optimizing your company file, upgrading hardware and software, adjusting preferences, optimizing network configuration, or performing regular maintenance, taking proactive steps to address performance issues will ensure that QuickBooks Desktop operates smoothly and efficiently, empowering you to focus on what matters most—managing your finances effectively. If you encounter persistent performance issues, consider reaching out to QuickBooks support for further assistance.
QuickBooks Desktop is a powerful tool for managing finances, but if it’s running slow, it can hinder productivity and frustrate users. Slow performance can be caused by various factors, from system issues to data file size. In this article, we’ll explore common reasons why QuickBooks Desktop may be running slow and provide practical solutions to optimize its performance, ensuring a smooth and efficient workflow. Identifying the Problem:Before diving into solutions, it’s essential to understand why QuickBooks Desktop might be running slow. Some common culprits include: Large Data File Size: Over time, as your company file grows in size, it can impact QuickBooks performance.Insufficient System Resources: Inadequate RAM, processor speed, or hard drive space can contribute to sluggish performance.Network Issues: Slow network connectivity or an overloaded server can affect QuickBooks’ ability to access data.Outdated Software: Using an outdated version of QuickBooks Desktop or outdated hardware drivers can lead to compatibility issues and reduced performance.Solutions to QuickBooks Desktop Running Slow:Optimize Company File:Condense large company files to remove outdated transactions and reduce file size.Run the Verify and Rebuild Data utility in QuickBooks to identify and fix data integrity issues.Archive old data into separate files to keep the current company file size manageable.Upgrade Hardware and Software:Ensure your computer meets QuickBooks’ system requirements, including RAM, processor speed, and hard drive space.Consider upgrading hardware components such as RAM or SSD for improved performance.Keep QuickBooks Desktop and your operating system up to date with the latest updates and patches.Adjust Preferences and Settings:Modify QuickBooks preferences to optimize performance, such as turning off automatic updates or reducing the number of open windows.Adjust backup settings to perform backups during off-peak hours to avoid impacting system performance during busy periods.Optimize Network Configuration:Ensure that your network infrastructure meets QuickBooks’ network requirements, including stable connectivity and sufficient bandwidth.Consider upgrading network hardware or using a wired connection instead of Wi-Fi for faster data transfer speeds.Perform Regular Maintenance:Clean up temporary files, cache, and unnecessary background processes on your computer to free up system resources.Defragment your hard drive regularly to improve data access speed and overall system performance.Conclusion: QuickBooks Desktop running slow can be a frustrating issue, but by identifying the underlying causes and implementing targeted solutions, you can optimize performance and streamline your workflow. Whether it’s optimizing your company file, upgrading hardware and software, adjusting preferences, optimizing network configuration, or performing regular maintenance, taking proactive steps to address performance issues will ensure that QuickBooks Desktop operates smoothly and efficiently, empowering you to focus on what matters most—managing your finances effectively. If you encounter persistent performance issues, consider reaching out to QuickBooks support for further assistance. Read More
Analyse browser-side performance with Web Driver Sampler on Azure Load Testing
Introduction
Performance testing is not always a walk in the park. Quite often, it can be challenging and time-consuming, especially when dealing with complex and dynamic web applications that rely on JavaScript, AJAX, or other browser-side technologies.
For testing browser latencies under heavy load, JMeter has a built-in component called Web Driver Sampler, which allows testers to use Selenium WebDriver to simulate real browser actions and interactions with web elements. Web Driver Sampler can complement the HTTP Request Sampler, which sends HTTP requests to the server, by adding the browser-side perspective and measuring the rendering time, page load time, and user actions. By running JMeter scripts on Azure Load Testing, you can reliably execute your performance tests without worrying about resources and scalability.
In this blog post, we will show you how to use Web Driver Sampler in JMeter for performance testing, upload your scripts on Azure Load Testing and analyse your performance metrics on the browser-side on Azure Load Testing.
We will use a sample web application called the Podcast App which is a demo site for searching and listening to podcasts.
Step 1: Create a JMeter script for generating backend load
The first step is to create a script in JMeter that mimics a user situation on the Podcast web application that puts its backend under high load.
For this example, we will create a script that performs requests for the homepage, searches for podcasts, and enlists relevant podcasts using the below samplers –
Step 2 – Create a Web Driver Sampler in the JMeter Script
To create a Web Driver Sampler script in JMeter, you need to follow these steps:
Download and install the JMeter Plugins Manager.
Navigate Plugins Manager, navigate to “Options” from JMeter IDE and click on Plugins Manager. Now click on the Available tab of Plugin Manager and type Selenium/Webdriver Support. And select Selenium/Webdriver Support, click on Apply changes and restart JMeter.
Add a new Thread Group to the above test plan and configure the number of threads, ramp-up time, and loop count according to your test scenario.
Add a Config Element > jp@gc – Chrome Driver Config to the Thread Group. This will configure the Chrome browser as the WebDriver for the Web Driver Sampler. You can also choose other browsers, such as Firefox, Edge, or Safari, by adding the corresponding driver config elements.
Add a Sampler > jp@gc – Web Driver Sampler to the Thread Group. This will allow you to write your Selenium WebDriver code in the Web Driver Sampler.
You can write your code in any supported language, such as Java, Groovy, JavaScript, or Python. For this example, we will use Groovy as the language.
Write your Selenium WebDriver code in the Script area of the Web Driver Sampler as shown below –
Step 3: Upload and run your JMeter script on Azure Load Testing
The next step is to upload your JMeter script on Azure Load Testing and run your load test. You can create a new load testing resource or use an existing one to create a test. To create a load test, you can refer to the documentation here.
Step 4: Analyse browser-side performance
After the load test is completed, you can view your results in the Results dashboard. The dashboard depicts graphs of client-side metrics corresponding to each sampler.
The browser-side performance of the application can be analysed by viewing the trends and aggregations in client-side metrics of the WebDriver Sampler. This can be seen in the graphs generated as shown below –
The response time of WebDriver Sampler represents the time it took for the browser to load when the backend of the application is under heavy load. Likewise, the requests/sec measures the throughput when the web application is tested with simulated browser actions.
One way to check if the browser loaded properly is to configure the elements in your selenium script that you want to verify. For example, you can use the findElement method to locate an element by its ID, name, class, or XPath, and then use the isDisplayed method to check if the element is visible on the page. By adding these checks in your selenium script, you can ensure that the browser rendered the web page correctly.
Conclusion
If you are new to Azure Load Testing, you can follow these instructions to set up your tests. Existing users can add the web-driver sampler in their scripts on Azure Load Testing.
We hope that this guide will help you to create realistic and robust performance tests for your web applications.
Microsoft Tech Community – Latest Blogs –Read More
How to Download Music from Spotify to Computer on Windows 11?
Hello everyone,
My Spotify Premium subscription has expired, and I did not renew it. However, I still wish to download some of my favorite music from Spotify to my computer without premium for offline listening. I understand that the official downloading feature is only available for Premium users.
Does anyone know of any alternative methods or third-party tools that could help with downloading songs from Spotify without a current Premium subscription? If anyone has experience or knowledge about this, could you please share your insights? I am looking for the most straightforward and compliant way to achieve this, if possible.
Regards,
Jesse
Hello everyone, My Spotify Premium subscription has expired, and I did not renew it. However, I still wish to download some of my favorite music from Spotify to my computer without premium for offline listening. I understand that the official downloading feature is only available for Premium users. Does anyone know of any alternative methods or third-party tools that could help with downloading songs from Spotify without a current Premium subscription? If anyone has experience or knowledge about this, could you please share your insights? I am looking for the most straightforward and compliant way to achieve this, if possible. Regards,Jesse Read More
Microsoft Project-PowerBI Integration
Good Day,
There is a need wherein we want to Visualize Microsoft Projects data on PowerBI Platform as KPI’s. It is possible to integrate both these platforms but is it possible to visualize or bring in the custom column data from Projects into PowerBI.
Thanks! for the help.
Good Day,There is a need wherein we want to Visualize Microsoft Projects data on PowerBI Platform as KPI’s. It is possible to integrate both these platforms but is it possible to visualize or bring in the custom column data from Projects into PowerBI.Thanks! for the help. Read More
Why is My QuickBooks Not Responding After Windows update?
Troubleshooting Solutions : QuickBooks Not Responding
QuickBooks Not Responding is a common issue that can stem from various causes. Follow these troubleshooting solutions to resolve the problem efficiently:
Restart QuickBooks and Your Computer: Often, a simple restart can resolve temporary glitches. Close QuickBooks and any related processes, then restart your computer. Relaunch QuickBooks and check if the issue persists.
Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Updates often include bug fixes and performance enhancements that can address compatibility issues causing QuickBooks to stop responding.
Check System Requirements: Verify that your computer meets QuickBooks’ system requirements. Inadequate hardware or outdated software can lead to performance issues, including QuickBooks freezing or becoming unresponsive.
Disable Background Programs: Background applications consuming system resources can interfere with QuickBooks’ functionality. Close unnecessary programs and processes running in the background, especially resource-intensive ones.
Run QuickBooks Diagnostic Tool: QuickBooks Diagnostic Tool can identify and fix common issues affecting QuickBooks performance. Download and run the tool to diagnose and resolve any underlying problems automatically.
Review Company File Size: Large company files can strain QuickBooks’ resources, leading to responsiveness issues. Consider condensing or archiving older data to reduce the file size and improve performance.
Check Network Connection: If QuickBooks is hosted on a network, unstable network connections can cause it to become unresponsive. Ensure a stable and reliable network connection to prevent interruptions.
Recreate QuickBooks Desktop Configuration: Corrupted QuickBooks configuration files can cause instability. Rebuild the QuickBooks Desktop configuration by renaming the configuration files, allowing QuickBooks to recreate them.
Repair QuickBooks Installation: A corrupted QuickBooks installation can lead to various issues, including unresponsiveness. Use the QuickBooks Install Diagnostic Tool or manually repair the installation through Control Panel > Programs and Features.
Restore a Backup: If the issue persists, restore a backup of your company file from a time when QuickBooks was functioning correctly. This can help isolate whether the problem lies within the current company file or the QuickBooks installation.
Seek Technical Support: If none of the above solutions resolve the issue, consider contacting QuickBooks technical support for further assistance. Provide detailed information about the problem and steps you’ve taken to troubleshoot it.
By following these troubleshooting solutions, you can effectively address the QuickBooks Not Responding issue and ensure uninterrupted use of QuickBooks for your business needs.
Troubleshooting Solutions : QuickBooks Not Responding QuickBooks Not Responding is a common issue that can stem from various causes. Follow these troubleshooting solutions to resolve the problem efficiently: Restart QuickBooks and Your Computer: Often, a simple restart can resolve temporary glitches. Close QuickBooks and any related processes, then restart your computer. Relaunch QuickBooks and check if the issue persists.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Updates often include bug fixes and performance enhancements that can address compatibility issues causing QuickBooks to stop responding.Check System Requirements: Verify that your computer meets QuickBooks’ system requirements. Inadequate hardware or outdated software can lead to performance issues, including QuickBooks freezing or becoming unresponsive.Disable Background Programs: Background applications consuming system resources can interfere with QuickBooks’ functionality. Close unnecessary programs and processes running in the background, especially resource-intensive ones.Run QuickBooks Diagnostic Tool: QuickBooks Diagnostic Tool can identify and fix common issues affecting QuickBooks performance. Download and run the tool to diagnose and resolve any underlying problems automatically.Review Company File Size: Large company files can strain QuickBooks’ resources, leading to responsiveness issues. Consider condensing or archiving older data to reduce the file size and improve performance.Check Network Connection: If QuickBooks is hosted on a network, unstable network connections can cause it to become unresponsive. Ensure a stable and reliable network connection to prevent interruptions.Recreate QuickBooks Desktop Configuration: Corrupted QuickBooks configuration files can cause instability. Rebuild the QuickBooks Desktop configuration by renaming the configuration files, allowing QuickBooks to recreate them.Repair QuickBooks Installation: A corrupted QuickBooks installation can lead to various issues, including unresponsiveness. Use the QuickBooks Install Diagnostic Tool or manually repair the installation through Control Panel > Programs and Features.Restore a Backup: If the issue persists, restore a backup of your company file from a time when QuickBooks was functioning correctly. This can help isolate whether the problem lies within the current company file or the QuickBooks installation.Seek Technical Support: If none of the above solutions resolve the issue, consider contacting QuickBooks technical support for further assistance. Provide detailed information about the problem and steps you’ve taken to troubleshoot it. By following these troubleshooting solutions, you can effectively address the QuickBooks Not Responding issue and ensure uninterrupted use of QuickBooks for your business needs. Read More
If cell is true return nothing
Hi,
Col B = contains dates in the range
Col L = contains dates in some cells in the range
At the moment I am using the following formula:
=TODAY()-B12
Now I want to put a condition into the formula.
Whenever a cell in col L contains a value then return nothing
Thank you for taking an interest.
Hi, Col B = contains dates in the rangeCol L = contains dates in some cells in the range At the moment I am using the following formula:=TODAY()-B12 Now I want to put a condition into the formula.Whenever a cell in col L contains a value then return nothing Thank you for taking an interest. Read More
Possible to install Windows 10 on an old MacBook Pro 2015?
I received an old MacBook Pro 2015 from my friend and want to install Windows 10 on it. I tried with the Bootcamp assistant app but it does not complete the installation process. Is there any alternative way to do that?
Currently, this Mac is running Monterey 12.6.3.
I received an old MacBook Pro 2015 from my friend and want to install Windows 10 on it. I tried with the Bootcamp assistant app but it does not complete the installation process. Is there any alternative way to do that? Currently, this Mac is running Monterey 12.6.3. Read More
Sorting/filtering excellence
Hello
I have a massive amount of data to sort. I have tried to simplify the setup below with an example. Is there any expert that can find a solution?
Thanks to @Martin_Angosto that showed me a first smart step!
HelloI have a massive amount of data to sort. I have tried to simplify the setup below with an example. Is there any expert that can find a solution? Thanks to @Martin_Angosto that showed me a first smart step! Read More
Virtual Network Flow Logs Recipes
You might have heard about the General Availability of Virtual Network Flow Logs in Azure, and even read the announcement blog post. When writing that post with Harsha CS I had the chance to play a bit with VNet Flow Logs and Traffic Analytics, and I would like to share some of the learnings.
What the heck am I talking about? Let me bring you up to speed very quickly (attention, oversimplification ahead!): NSG Flow Logs is a technology that logs every packet going through an NSG: in and out, allowed and dropped. The main issue of NSG Flow Logs is, well, that you need an NSG, and some resources in Azure do not support them. For example, Azure Firewall, VPN gateways or ExpressRoute gateways. Enter VNet Flow Logs, which you can enable in a whole VNet or subnet, regardless of whether there are NSGs or not.
What is Traffic Analytics, I hear you say? VNet Flow Logs are stored in Azure Blob Storage. Optionally, you can enable Traffic Analytics, which will do two things: it will enrich the flow logs with additional information, and will send everything to a Log Analytics Workspace for easy querying. This “enrich and forward to Log Analytics” operation will happen in intervals, either every 10 minutes or every hour.
VNet Flow Logs give you much more, such as for example whether traffic is vnet-encrypted or not, whether traffic is dropped by AVNM security admin rules, and some more stuff, but you will find all that in the docs so I am not going to repeat it here.
Table structure: NTAIpDetails
This table will contain some enrichment data about public IP addresses, including whether they belong to Azure services and their region, and geolocation information for other public IPs. Here you can see a sample of what that table looks like:
For example, looking at the NTAIpDetails table you could extract information about what communications are there in place. The query is very simple (NTAIpDetails | distinct FlowType, PublicIpDetails, Location), and it gives you a glimpse of what you can do, especially when joining this table to NTANetAnalytics (see the scenarios further down for examples on how to join this table):
NTAIpDetails
| distinct FlowType, PublicIpDetails, Location
Table structure: NTATopologyDetails
This table contains information about different elements of your topology, including VNets, subnets, route tables, routes, NSGs, Application Gateways and much more. Here you cans see what it looks like:
For example, with a simple query you can get the routes in the route tables configured in a given resource group:
NTATopologyDetails
| where TimeGenerated > ago(600d)
| where AzureResourceType == “Route”
| extend name_a = split(Name, “/”)
| extend ResourceGroup = tostring(name_a[0]), RouteTableName = tostring(name_a[1]), RouteName = tostring(name_a[2])
| where ResourceGroup == “flowlogs”
| distinct ResourceGroup, RouteTableName, RouteName, NextHopType,NextHopIp
Yeah, there are many other ways of getting topology information in Azure, such as with Azure Resource Graph, but having this in a table is pretty handy to do join queries.
Table structure: NTANetAnalytics
Alright, now we are coming to more interesting things: this table is the one containing the flows we are looking for. Records in this table will contain the usual attributes you would expect such as source and destination IP, protocol, and destination port. Additionally, data will be enriched with information such as:
Source and destination VM
Source and destination NIC
Source and destination subnet
Source and destination load balancer
Flow encryption (yes/no)
Whether the flow is going over ExpressRoute
And many more
Further below you can read some scenarios with detailed queries that will show you some examples of ways you can extract information from VNet Flow Logs and Traffic Analytics. Of course, these are just some of the scenarios that came to mind on my topology, the idea is that you can get inspiration from these queries to support your individual use case.
Scenario 1: traffic to/from a virtual machine
For example, imagine you want to see with which IP addresses a given virtual machine has been talking to in the last few days:
NTANetAnalytics
| where TimeGenerated > ago(60d)
| where SrcIp == “10.1.1.8” and strlen(DestIp)>0
| summarize TotalBytes=sum(BytesDestToSrc+BytesSrcToDest) by SrcIp, DestIp
What if we want to enrich this information with the NTAIpDetails table to get the geolocation of the public IP addresses? Let’s have a look:
NTANetAnalytics
| where TimeGenerated > ago(60d)
| where SrcIp == “10.1.1.8” and strlen(DestIp)>0
| join kind = leftouter (NTAIpDetails) on $left.DestIp == $right.Ip
| summarize TotalBytes=sum(BytesDestToSrc+BytesSrcToDest) by SrcIp, DestIp, PublicIpDetails, Location
Mmmh, that packet host inc. looks suspicious, so now you might be interested in getting a time distribution on the protocols that have been going on there. Nothing easier! We can see here that there have been two big data transfers of around 1GB in two different days, the last one on 23rd April.
NTANetAnalytics
| where TimeGenerated > ago(60d)
| where SrcIp == “10.1.1.8” and DestIp == “136.144.58.113”
| join kind = leftouter (NTAIpDetails) on $left.DestIp == $right.Ip
| extend App = strcat(L4Protocol,tostring(DestPort))
| summarize TotalBytes=sum(BytesDestToSrc+BytesSrcToDest) by App, bin(TimeGenerated, 1d)
| render columnchart
Mmmmh, somebody exfiltrating data?
Scenario 2: load balancer traffic distribution
You want to look into the traffic distribution of a given application front-ended by a load balancer? Two of the enrichment fields in the NTANetAnalytics table are SrcLoadBalancer and DestLoadBalancer, that we can leverage for this purpose. We will look at the source IP first, meaning traffic going from the VM to the load balancer:
NTANetAnalytics
| where SubType == ‘FlowLog’ and TimeGenerated > ago(60d)
| where SrcLoadBalancer contains ‘web’ or DestLoadBalancer contains ‘web’
| summarize TotalBytes = sum(BytesSrcToDest + BytesDestToSrc) by tostring(SrcIp)
| render piechart
Interesting, it looks like 10.1.1.70 is not getting too much traffic? Let’s look here to the time distribution as well, maybe that machine hasn’t been there for a long time:
NTANetAnalytics
| where SubType == ‘FlowLog’ and TimeGenerated > ago(60d)
| where SrcLoadBalancer contains ‘web’ or DestLoadBalancer contains ‘web’
| summarize TotalBytes = sum(BytesSrcToDest + BytesDestToSrc) by tostring(SrcIp), bin(TimeGenerated, 1d)
| render barchart
We can have a look at the Destination IP as well, which will show an interesting picture:
NTANetAnalytics
| where SubType == ‘FlowLog’ and TimeGenerated > ago(60d)
| where SrcLoadBalancer contains ‘web’ or DestLoadBalancer contains ‘web’
| summarize TotalBytes = sum(BytesSrcToDest + BytesDestToSrc) by tostring(DestIp), bin(TimeGenerated, 1d)
| render barchart
Wow, it looks like we need to have a look at these VMs, something seems not to be right with our load distribution!
Scenario 3: Traffic between IP ranges
Traffic Analytics will enrich the information with information such as source and destination subnets:
NTANetAnalytics
| where SubType == ‘FlowLog’ and FaSchemaVersion == ‘3’ and TimeGenerated > ago(60d)
| where isnotempty(SrcSubnet) and isnotempty(DestSubnet)
| summarize TotalBytes=sum(BytesSrcToDest + BytesDestToSrc) by SrcSubnet, DestSubnet,L4Protocol,DestPort
However, sometimes you want to do a different data aggregation, for example if you would like to see traffic between on-premises and Azure. In this case you can define the aggregation prefixes yourself and use the handy KQL function ipv4_is_in_range:
let prefix1=”10.1.1.0/27″;
let prefix2=”10.1.1.64/27″;
NTANetAnalytics
| where SubType == ‘FlowLog’ and FaSchemaVersion == ‘3’ and TimeGenerated > ago(30d)
| extend SrcIpIsInPrefix1 = ipv4_is_in_range(SrcIp, prefix1), SrcIpIsInPrefix2 = ipv4_is_in_range(SrcIp, prefix2)
| extend DestIpIsInPrefix1 = ipv4_is_in_range(DestIp, prefix1), DestIpIsInPrefix2 = ipv4_is_in_range(DestIp, prefix2)
| where (SrcIpIsInPrefix1 and DestIpIsInPrefix2) or (SrcIpIsInPrefix2 and DestIpIsInPrefix1)
| summarize TotalBytes=sum(BytesSrcToDest + BytesDestToSrc) by SrcIp, DestIp,L4Protocol,DestPort,L7Protocol
You want this information but distributed across time, to have a look at traffic evolution? You got it. We can create a new field to aggregate the information about source, destination and protocol, and represent to a stacked chart:
let prefix1=”10.1.1.0/27″;
let prefix2=”10.1.1.64/27″;
NTANetAnalytics
| where SubType == ‘FlowLog’ and FaSchemaVersion == ‘3’ and TimeGenerated > ago(30d)
| extend SrcIpIsInPrefix1 = ipv4_is_in_range(SrcIp, prefix1), SrcIpIsInPrefix2 = ipv4_is_in_range(SrcIp, prefix2)
| extend DestIpIsInPrefix1 = ipv4_is_in_range(DestIp, prefix1), DestIpIsInPrefix2 = ipv4_is_in_range(DestIp, prefix2)
| where (SrcIpIsInPrefix1 and DestIpIsInPrefix2) or (SrcIpIsInPrefix2 and DestIpIsInPrefix1)
//| summarize TotalBytes=sum(BytesSrcToDest + BytesDestToSrc) by SrcIp, DestIp,L4Protocol,DestPort,L7Protocol
| extend FlowDescription = strcat(SrcIp, “-“, DestIp, “-“, L4Protocol, tostring(DestPort))
| summarize TotalBytes=sum(BytesSrcToDest + BytesDestToSrc) by FlowDescription, bin(TimeGenerated, 1d)
| render columnchart
Interesting, a lot of traffic on port 80, maybe somebody should look at migrating to HTTPS?
Scenario 4: ExpressRoute traffic
You know that VNet Flow Logs are not tied to NSGs as we saw in the previous scenario about Azure Firewall. Guess what, this applies as well to VPN and ExpressRoute gateways. More concretely, with ExpressRoute we can even leverage the fields SrcExpressRouteCircuit and DestExpressRouteCircuit:
NTANetAnalytics
| where SubType == ‘FlowLog’ and TimeGenerated > ago(60d)
| where isnotnull(SrcExpressRouteCircuit) or isnotnull(DestExpressRouteCircuit)
| extend TargetResourceName = tostring(split(TargetResourceId, “/”)[2])
| summarize TotalBytes=sum(BytesSrcToDest + BytesDestToSrc) by TargetResourceName, bin(TimeGenerated, 1d)
| render columnchart
We can use the previous recipe for prefix aggregation to show traffic from onprem to Azure and Azure to onprem:
let prefix1=”10.4.0.0/16″;
let prefix2=”10.1.0.0/16″;
NTANetAnalytics
| where SubType == ‘FlowLog’ and FaSchemaVersion == ‘3’ and FlowStartTime > ago(24h)
| extend SrcIpIsInPrefix1 = ipv4_is_in_range(SrcIp, prefix1), SrcIpIsInPrefix2 = ipv4_is_in_range(SrcIp, prefix2)
| extend DestIpIsInPrefix1 = ipv4_is_in_range(DestIp, prefix1), DestIpIsInPrefix2 = ipv4_is_in_range(DestIp, prefix2)
| where (SrcIpIsInPrefix1 and DestIpIsInPrefix2) or (SrcIpIsInPrefix2 and DestIpIsInPrefix1)
| extend Direction = iff((SrcIpIsInPrefix1 and DestIpIsInPrefix2), “Onprem2Azure”, “Azure2Onprem”)
| summarize TotalBytesSrcToDest=sum(BytesSrcToDest), TotalBytesDestTosrc=sum(BytesDestToSrc) by Direction
| render columnchart
Wrapping up
These were only some examples of how you can slice and dice the data in VNet Flow Logs, please do not hesitate to let me know in the comments about other cool KQL queries you are using!
Microsoft Tech Community – Latest Blogs –Read More
Call [1-833-460-2030] to Download QuickBooks Tool Hub 2024
Are you looking to enhance your QuickBooks experience and streamline your accounting processes? Look no further than the QuickBooks Tool Hub 2024. As one of the most powerful utilities offered by Intuit, the QuickBooks Tool Hub is designed to help users resolve common issues, optimize performance, and simplify troubleshooting tasks.
What is QuickBooks Tool Hub 2024?
The QuickBooks Tool Hub 2024 is an all-in-one solution that consolidates various tools and utilities to assist QuickBooks users in managing their software effectively. Whether you’re encountering errors, facing performance issues, or seeking guidance on specific tasks, the Tool Hub provides a centralized platform to address your needs swiftly and efficiently.
Key Features and Benefits:
Unified Interface: The Tool Hub offers a user-friendly interface that brings together a diverse range of tools and resources, eliminating the need to navigate through multiple menus and interfaces.
Diagnostic Tools: Diagnose and troubleshoot common QuickBooks errors and issues with ease using diagnostic tools such as QuickBooks File Doctor, QuickBooks Refresher, and QuickBooks Install Diagnostic Tool.
Repair Tools: Resolve software-related issues and restore functionality with built-in repair tools that can fix common installation problems, network issues, and data file corruption.
File Management: Manage and organize your QuickBooks company files effortlessly, with tools to create backups, restore data, and condense large files for optimal performance.
Update and Installation Assistance: Stay up-to-date with the latest QuickBooks releases and ensure smooth installations with tools that facilitate software updates and installations.
Technical Support Resources: Access a wealth of technical support resources, including FAQs, articles, and tutorials, to empower users with the knowledge and guidance needed to navigate QuickBooks effectively.
How to Download and Install QuickBooks Tool Hub 2024:
Downloading and installing the QuickBooks Tool Hub is a straightforward process:
Visit the official QuickBooks website or Intuit’s support portal to locate the QuickBooks Tool Hub download page.
Select the appropriate version of the Tool Hub for your operating system (Windows or Mac) and download the installation file to your computer.
Once the download is complete, double-click the installation file to launch the setup wizard.
Follow the on-screen instructions to complete the installation process. The Tool Hub will be installed on your computer, ready for immediate use.
Upon installation, launch the QuickBooks Tool Hub and explore its various tools and features to optimize your QuickBooks experience.
Conclusion:
In today’s fast-paced business environment, efficiency and productivity are paramount. The QuickBooks Tool Hub 2024 empowers users to overcome challenges, streamline workflows, and maximize the capabilities of their QuickBooks software. Whether you’re a small business owner, an accountant, or a financial professional, the Tool Hub serves as a valuable companion in your journey towards financial success. Download the QuickBooks Tool Hub 2024 today and unlock the full potential of your QuickBooks software.
Are you looking to enhance your QuickBooks experience and streamline your accounting processes? Look no further than the QuickBooks Tool Hub 2024. As one of the most powerful utilities offered by Intuit, the QuickBooks Tool Hub is designed to help users resolve common issues, optimize performance, and simplify troubleshooting tasks. What is QuickBooks Tool Hub 2024?The QuickBooks Tool Hub 2024 is an all-in-one solution that consolidates various tools and utilities to assist QuickBooks users in managing their software effectively. Whether you’re encountering errors, facing performance issues, or seeking guidance on specific tasks, the Tool Hub provides a centralized platform to address your needs swiftly and efficiently.Key Features and Benefits:Unified Interface: The Tool Hub offers a user-friendly interface that brings together a diverse range of tools and resources, eliminating the need to navigate through multiple menus and interfaces.Diagnostic Tools: Diagnose and troubleshoot common QuickBooks errors and issues with ease using diagnostic tools such as QuickBooks File Doctor, QuickBooks Refresher, and QuickBooks Install Diagnostic Tool.Repair Tools: Resolve software-related issues and restore functionality with built-in repair tools that can fix common installation problems, network issues, and data file corruption.File Management: Manage and organize your QuickBooks company files effortlessly, with tools to create backups, restore data, and condense large files for optimal performance.Update and Installation Assistance: Stay up-to-date with the latest QuickBooks releases and ensure smooth installations with tools that facilitate software updates and installations.Technical Support Resources: Access a wealth of technical support resources, including FAQs, articles, and tutorials, to empower users with the knowledge and guidance needed to navigate QuickBooks effectively.How to Download and Install QuickBooks Tool Hub 2024:Downloading and installing the QuickBooks Tool Hub is a straightforward process:Visit the official QuickBooks website or Intuit’s support portal to locate the QuickBooks Tool Hub download page.Select the appropriate version of the Tool Hub for your operating system (Windows or Mac) and download the installation file to your computer.Once the download is complete, double-click the installation file to launch the setup wizard.Follow the on-screen instructions to complete the installation process. The Tool Hub will be installed on your computer, ready for immediate use.Upon installation, launch the QuickBooks Tool Hub and explore its various tools and features to optimize your QuickBooks experience.Conclusion:In today’s fast-paced business environment, efficiency and productivity are paramount. The QuickBooks Tool Hub 2024 empowers users to overcome challenges, streamline workflows, and maximize the capabilities of their QuickBooks software. Whether you’re a small business owner, an accountant, or a financial professional, the Tool Hub serves as a valuable companion in your journey towards financial success. Download the QuickBooks Tool Hub 2024 today and unlock the full potential of your QuickBooks software. Read More
Outlook stopped downloading POP messages after update
Microsoft® Outlook® 2019 MSO (Version 2403 Build 16.0.17425.20176) 32-bit
My desktop outlook has changed and no longer download emails from non Microsoft POP accounts. This started on 7/5/2024. I have several POP accounts from different providers and they are all showing mail in their providers sites so the issue is with Outlook.
I also noticed in the outlook search bar “0w” in html brackets has appeared so I suspect it is another poor update.
I have two options. Fix it by the end of the week or abandon outlook altogether.
Any ideas?
thanks
jc
Microsoft® Outlook® 2019 MSO (Version 2403 Build 16.0.17425.20176) 32-bit My desktop outlook has changed and no longer download emails from non Microsoft POP accounts. This started on 7/5/2024. I have several POP accounts from different providers and they are all showing mail in their providers sites so the issue is with Outlook.I also noticed in the outlook search bar “0w” in html brackets has appeared so I suspect it is another poor update.I have two options. Fix it by the end of the week or abandon outlook altogether.Any ideas? thanks jc Read More
How to repair the drive from a drive failure in Windows 10 Storage Spaces
I have 4X 1TB drives configured as RAID 1. I assumed that meant that a copy of the data was also stored on the other drives since only 2TB of the 4TB is available. I found the failing drive and replaced it.I’m unable to remove the drive from the pool even though it’s physically uninstalled. All 4 HD’s (3 original, one new) show up as OK in Storage Spaces. I don’t see the pool in Explorer.
What’s the point of RAID if all your data is lost every time there’s a failure. The is the 2nd time I’ve had a SS failure. First time I just said good bye to all the data, reformatted everything and started over.
I have 4X 1TB drives configured as RAID 1. I assumed that meant that a copy of the data was also stored on the other drives since only 2TB of the 4TB is available. I found the failing drive and replaced it.I’m unable to remove the drive from the pool even though it’s physically uninstalled. All 4 HD’s (3 original, one new) show up as OK in Storage Spaces. I don’t see the pool in Explorer. What’s the point of RAID if all your data is lost every time there’s a failure. The is the 2nd time I’ve had a SS failure. First time I just said good bye to all the data, reformatted everything and started over. Read More
Dial +1-833-460-2030 to Download QuickBooks Tool Hub 2024
In the ever-evolving landscape of financial management software, QuickBooks stands out as a trusted ally for businesses of all sizes. Its intuitive interface and robust features streamline bookkeeping tasks, allowing entrepreneurs to focus on what truly matters: growing their ventures. To further enhance the user experience and address common issues efficiently, Intuit introduces QuickBooks Tool Hub 2024.
What is QuickBooks Tool Hub?
QuickBooks Tool Hub is a comprehensive solution designed to troubleshoot various QuickBooks errors and issues. It consolidates several diagnostic tools and utilities into a single, easy-to-use application, empowering users to resolve problems swiftly and effectively. Whether you’re encountering installation errors, company file issues, or connectivity problems, QuickBooks Tool Hub provides the necessary resources to diagnose and fix them promptly.
Key Features of QuickBooks Tool Hub 2024
1. Centralized Dashboard
QuickBooks Tool Hub offers a centralized dashboard where users can access all diagnostic tools and resources conveniently. With a user-friendly interface, navigating through the application is effortless, even for those with limited technical expertise.
2. Diagnostic Tools
From QuickBooks File Doctor to QuickBooks Install Diagnostic Tool, QuickBooks Tool Hub includes a range of diagnostic utilities tailored to address specific issues. Whether it’s repairing damaged company files or troubleshooting network connectivity, these tools simplify the troubleshooting process and minimize downtime.
3. Quick Solutions
Time is of the essence in business, and QuickBooks Tool Hub recognizes that. It provides quick solutions to common problems, allowing users to resolve issues with minimal disruption to their workflow. With just a few clicks, users can tackle issues head-on and get back to managing their finances seamlessly.
4. Seamless Integration
QuickBooks Tool Hub seamlessly integrates with existing QuickBooks applications, ensuring compatibility and ease of use. Whether you’re using QuickBooks Desktop or QuickBooks Online, QuickBooks Tool Hub complements your existing toolkit, enhancing its capabilities and addressing potential pain points.
How to Download QuickBooks Tool Hub 2024
Downloading QuickBooks Tool Hub 2024 is a straightforward process:
Visit the official Intuit website or the QuickBooks support page.Navigate to the Downloads section and locate QuickBooks Tool Hub 2024.Click on the download link and follow the on-screen instructions to complete the installation process.Once installed, launch QuickBooks Tool Hub and explore its features and capabilities.
Conclusion
In an era where efficiency and reliability are paramount, QuickBooks Tool Hub 2024 emerges as a valuable asset for businesses seeking seamless financial management solutions. By providing a comprehensive toolkit for diagnosing and resolving QuickBooks issues, it empowers users to overcome challenges quickly and stay focused on their entrepreneurial endeavors. With QuickBooks Tool Hub 2024 at your disposal, navigating the complexities of financial management becomes a breeze, enabling you to unlock your full potential and achieve success with confidence.
In the ever-evolving landscape of financial management software, QuickBooks stands out as a trusted ally for businesses of all sizes. Its intuitive interface and robust features streamline bookkeeping tasks, allowing entrepreneurs to focus on what truly matters: growing their ventures. To further enhance the user experience and address common issues efficiently, Intuit introduces QuickBooks Tool Hub 2024. What is QuickBooks Tool Hub?QuickBooks Tool Hub is a comprehensive solution designed to troubleshoot various QuickBooks errors and issues. It consolidates several diagnostic tools and utilities into a single, easy-to-use application, empowering users to resolve problems swiftly and effectively. Whether you’re encountering installation errors, company file issues, or connectivity problems, QuickBooks Tool Hub provides the necessary resources to diagnose and fix them promptly.Key Features of QuickBooks Tool Hub 20241. Centralized DashboardQuickBooks Tool Hub offers a centralized dashboard where users can access all diagnostic tools and resources conveniently. With a user-friendly interface, navigating through the application is effortless, even for those with limited technical expertise.2. Diagnostic ToolsFrom QuickBooks File Doctor to QuickBooks Install Diagnostic Tool, QuickBooks Tool Hub includes a range of diagnostic utilities tailored to address specific issues. Whether it’s repairing damaged company files or troubleshooting network connectivity, these tools simplify the troubleshooting process and minimize downtime.3. Quick SolutionsTime is of the essence in business, and QuickBooks Tool Hub recognizes that. It provides quick solutions to common problems, allowing users to resolve issues with minimal disruption to their workflow. With just a few clicks, users can tackle issues head-on and get back to managing their finances seamlessly.4. Seamless IntegrationQuickBooks Tool Hub seamlessly integrates with existing QuickBooks applications, ensuring compatibility and ease of use. Whether you’re using QuickBooks Desktop or QuickBooks Online, QuickBooks Tool Hub complements your existing toolkit, enhancing its capabilities and addressing potential pain points.How to Download QuickBooks Tool Hub 2024Downloading QuickBooks Tool Hub 2024 is a straightforward process:Visit the official Intuit website or the QuickBooks support page.Navigate to the Downloads section and locate QuickBooks Tool Hub 2024.Click on the download link and follow the on-screen instructions to complete the installation process.Once installed, launch QuickBooks Tool Hub and explore its features and capabilities.ConclusionIn an era where efficiency and reliability are paramount, QuickBooks Tool Hub 2024 emerges as a valuable asset for businesses seeking seamless financial management solutions. By providing a comprehensive toolkit for diagnosing and resolving QuickBooks issues, it empowers users to overcome challenges quickly and stay focused on their entrepreneurial endeavors. With QuickBooks Tool Hub 2024 at your disposal, navigating the complexities of financial management becomes a breeze, enabling you to unlock your full potential and achieve success with confidence. Read More
Why is there no location/office attribute in an AAD device properties?
Hey all,
we are using intune for some time now, and right now we think about optimizing how to put the location/office information to an Azure only device, because we want to use dynamic groups and group devices to an office/location. And Im kinda curious what you guys use for that, since there is no location/office attribute on an AAD/entra device (which I dont understand…)
So are you using device categories for that, or do you work with hundreds of different group tags? Or do you name every device different and use location shortcuts in the name?
Right now we dont have an inventory system or ticket system so im stuck with the intune / azure native options.
Would like to hear how you approach this, thank you
Hey all, we are using intune for some time now, and right now we think about optimizing how to put the location/office information to an Azure only device, because we want to use dynamic groups and group devices to an office/location. And Im kinda curious what you guys use for that, since there is no location/office attribute on an AAD/entra device (which I dont understand…)So are you using device categories for that, or do you work with hundreds of different group tags? Or do you name every device different and use location shortcuts in the name? Right now we dont have an inventory system or ticket system so im stuck with the intune / azure native options. Would like to hear how you approach this, thank you Read More
Why Windows 11 keeps booting into recovery mode when there’s an update?
Every time my Windows 11 needs an update, it fails and I have to go through recovery and repair. I’ve got plenty of space and I’ve already fixed it once before, but whenever there’s an update, it just goes back to square one. The last recovery worked fine, but now it’s acting up again. Any ideas how to fix this?
Every time my Windows 11 needs an update, it fails and I have to go through recovery and repair. I’ve got plenty of space and I’ve already fixed it once before, but whenever there’s an update, it just goes back to square one. The last recovery worked fine, but now it’s acting up again. Any ideas how to fix this? Read More