Tag Archives: microsoft
SQL 2014 error ‘The Primary Filegroup is full’
I need your help to get the exact root cause of the issue “The Primary Filegroup is full” & how to avoid to occur again in the future. Please help on this & suggest better option.
I need your help to get the exact root cause of the issue “The Primary Filegroup is full” & how to avoid to occur again in the future. Please help on this & suggest better option. Read More
Files are duplicated when posting in a secure Teams channel
A couple of weeks ago my client’s Teams started duplicating every file that I posted in a secure channel. That is, I’d write a post, attach a document that was already saved in a Teams folder (via the paperclip icon) and two things happen: 1. The file takes a while to attach as seen by a progress bar, as if it’s uploading; and 2. It immediately creates a duplicate of the document into the parent SharePoint folder (that is, the top level secure channel folder). From there, I’ll end up working in the original document I had saved in the sub-folder and everyone else who accesses the document via the Post, is using the new version in the parent-level folder. Ok, so I logged a ticket with my client’s IT as they do have a very unusual set up for their whole Microsoft environment and to all of us this is a very new issue none of us has heard of before, so they logged a ticket with Microsoft. However, today I tested it in my tenant – and got exactly the same result! This is not a standalone issue – my tenant is set up completely differently to my client’s and I suspect we are not even on the same type of business licence (they’d be on enterprise and I’m just a small business). Not only is this weird but we are going insane trying to keep track of the correct versions and archiving all the duplicates. Has anyone seen this? Any ideas on whether there is a new default setting or something happening on microsoft’s end? And importantly, any idea how to fix this?
A couple of weeks ago my client’s Teams started duplicating every file that I posted in a secure channel. That is, I’d write a post, attach a document that was already saved in a Teams folder (via the paperclip icon) and two things happen: 1. The file takes a while to attach as seen by a progress bar, as if it’s uploading; and 2. It immediately creates a duplicate of the document into the parent SharePoint folder (that is, the top level secure channel folder). From there, I’ll end up working in the original document I had saved in the sub-folder and everyone else who accesses the document via the Post, is using the new version in the parent-level folder. Ok, so I logged a ticket with my client’s IT as they do have a very unusual set up for their whole Microsoft environment and to all of us this is a very new issue none of us has heard of before, so they logged a ticket with Microsoft. However, today I tested it in my tenant – and got exactly the same result! This is not a standalone issue – my tenant is set up completely differently to my client’s and I suspect we are not even on the same type of business licence (they’d be on enterprise and I’m just a small business). Not only is this weird but we are going insane trying to keep track of the correct versions and archiving all the duplicates. Has anyone seen this? Any ideas on whether there is a new default setting or something happening on microsoft’s end? And importantly, any idea how to fix this? Read More
Can we add “duplicate current tab” function in Edge mouse gesture?
It seems like the mouse gesture in Edge don’t have “duplicate current tab” function.
By the way, the current shortcut of “duplicate tab” is not convenient to use for me.
Could tech group consider adding it in mouse gestures.
Thanks a lot!
It seems like the mouse gesture in Edge don’t have “duplicate current tab” function. By the way, the current shortcut of “duplicate tab” is not convenient to use for me. Could tech group consider adding it in mouse gestures.Thanks a lot! Read More
Recording – Copilot Use Cases for PMO – Copilot for Microsoft 365 Starter Series
On Monday, April 22, 2024, we hosted a webinar on Copilot for Microsoft 365, the AI assistant that helps you work smarter and faster. The session featured Microsoft’s Jasmine Hoegh and Helen Guan. Additionally, they were joined by guest speakers Danielle McGahee, Busola Adeniran, and Kara Kimble-Williams. In this webinar, we focused on some use cases for the project management office (PMO) and how Copilot can help project managers with tasks such as brainstorming, communication, planning, reporting, and more. We also heard from some guest speakers who shared their experience and feedback on using Copilot for their projects. Here are some of the key takeaways from the webinar.
What is Copilot for Microsoft 365 and how does it align with PMO practices?
Copilot for Microsoft 365 is an AI assistant that works alongside you and through all of your applications such as Word, Excel, PowerPoint, Outlook, Teams, and many more, within your Microsoft ecosystem.
Copilot adapts to your preferences, goals, and context, and then helps you achieve much more than before. It is AI-generated and human-customized.
Copilot can help project managers adhere to the PMI talent triangle, which consists of technical project management, leadership, and strategic and business management.
Copilot can help project managers with various tasks across the project lifecycle, such as brainstorming, communication, planning, execution, monitoring, controlling, and closing.
Copilot does not replace human judgment or decision-making. Project managers still need to critically evaluate the suggestions, tailor them to their specific context, and approve any changes before implementing.
Copilot does not handle any sensitive or confidential information, such as proprietary data or personal information. It also does not predict any future events or outcomes with certainty.
What are some use cases for Copilot for PMO?
Copilot can help project managers with brainstorming and communication. For example, Copilot can suggest ideas for a project based on a prompt, categorize and organize the ideas, and summarize them in a loop component that can be inserted into an email, a Teams message, a OneNote page, or a Word document.
Copilot can help project managers create a project plan or a project charter based on a file or a prompt. For example, Copilot can generate a summary, a rationale, a project manager, some project goals, a budget, and a timeline for a project based on a Word document that contains some information about the project.
Copilot can help project managers create a presentation from a file or a prompt. For example, Copilot can create a kickoff deck based on a project charter document, and include an outline, some slides, and some slide notes.
Copilot can help project managers respond to RFPs faster and more efficiently. For example, Copilot can summarize and analyze a large RFP document, and highlight the key requirements, risks, assumptions, and deliverables.
Copilot can help project managers improve customer meetings and engagement. For example, Copilot can schedule a meeting with a customer based on a presentation file, and include a summary, an agenda, and an attachment in the meeting invite.
Copilot can help project managers collect and share feedback. For example, Copilot can create a survey or a poll based on a prompt, and insert it into an email, a Teams message, or a PowerPoint slide.
Resources:
Slide Deck in PDF Format
Microsoft Copilot Scenario Library – Microsoft Adoption
Generative AI Overview for Project Managers (pmi.org)
We hope you enjoyed this webinar and learned something new about Copilot for Microsoft 365 and how it can help you as a project manager. Thank you for joining us and have a great day.
You can see the rest of the upcoming Copilot for Microsoft 365 Starter series here.
Thanks for visiting – Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
Issue with Windows 11 Insider Preview 26058.1000 (ge_release)
Does anyone know how to resolve the Windows 11 Insider Preview 26058.1000 (ge_release) update, error watch_dog
Does anyone know how to resolve the Windows 11 Insider Preview 26058.1000 (ge_release) update, error watch_dog Read More
Can’t print couple columns
I downloaded a CSV file and saved it as a .xlsx file format. There are two columns that won’t print and I need to have them when printed. Does anyone know how to get them to print?
Thanks in advance!
I downloaded a CSV file and saved it as a .xlsx file format. There are two columns that won’t print and I need to have them when printed. Does anyone know how to get them to print?Thanks in advance! Read More
Office stuck on loading profile unless you kill background office product
Hello all,
According to MS, this bug was fixed back in 2019 (see below) but my org is having issues with Outlook getting stuck at the “loading profile” stage. I am aware of the workaround (closing background 365 processes) but I was hoping there was a more permanent solution to minimize calls about this issue.
Troubleshooting Attempts:
Reboot (works but doesn’t solve the problem)
Repair Outlook/365 (works, but not every time)
Closing Background 365/Office Processes (been the current solution with a constant success rate)
Not happening to all users.
Hello all,According to MS, this bug was fixed back in 2019 (see below) but my org is having issues with Outlook getting stuck at the “loading profile” stage. I am aware of the workaround (closing background 365 processes) but I was hoping there was a more permanent solution to minimize calls about this issue. Troubleshooting Attempts:Reboot (works but doesn’t solve the problem)Repair Outlook/365 (works, but not every time)Closing Background 365/Office Processes (been the current solution with a constant success rate)Not happening to all users. Read More
Signature template in Exchange Online
Hi ya’ll. I’m trying to move from Zoho to Exchange, and I’m having trouble figuring out how to configure an org wide signature template like I can in Zoho Mail. The signature uses variables that we use to insert someone’s name, email, extension, etc. in the signature. Is this available in Exchange Online, and if so, how would this be accomplished?
Hi ya’ll. I’m trying to move from Zoho to Exchange, and I’m having trouble figuring out how to configure an org wide signature template like I can in Zoho Mail. The signature uses variables that we use to insert someone’s name, email, extension, etc. in the signature. Is this available in Exchange Online, and if so, how would this be accomplished? Read More
Another endless cycle of employment verification rejection
I have been going at this for the better part of two weeks. The same as everyone else. Generic responses saying the documents I submitted do not match the accepted document types. Ironically, I select the document type from the drop down list and provide exactly what is asked for. Here is where I am at:
Went through the entire process and uploaded documents 3 times. Still rejected.Opened a support ticket 2404170040008375. Ticket took a week to be closed and the only response provided was: The application to join the program was rejected because it failed Microsoft standards review. At this point, we are unable to provide any further details. We are closing this ticket as restricted internally.Started the verification process again. This time I changed my operating as company name to my numbered corporation name. Still rejected. Sent a screenshot and a URL showing my company website with all the requested information on it as identified in the document types. This too was rejected.
Sadly I provided the proof of purchase for my domain. They wouldn’t accept it because I bought it under my personal name (newsflash, I registered the business after I bought the domain). I also cannot update my whois record to include my company name. It is a .ca registration and for reasons that I cannot understand half of the words in my company name are restricted. Words such as solutions, ontario and inc. I have sent articles of incorporation, government documents, everything but my DNA. Still rejected.
I am very willing to work with Microsoft to get this sorted out, but I cannot unless they tell me what is failing! Please help me find the path forward. Somebody has to know what it is!
And SHAME on you Microsoft. This has been a problem since last year according to all the posts in this forum. Fix it!
I have been going at this for the better part of two weeks. The same as everyone else. Generic responses saying the documents I submitted do not match the accepted document types. Ironically, I select the document type from the drop down list and provide exactly what is asked for. Here is where I am at: Went through the entire process and uploaded documents 3 times. Still rejected.Opened a support ticket 2404170040008375. Ticket took a week to be closed and the only response provided was: The application to join the program was rejected because it failed Microsoft standards review. At this point, we are unable to provide any further details. We are closing this ticket as restricted internally.Started the verification process again. This time I changed my operating as company name to my numbered corporation name. Still rejected. Sent a screenshot and a URL showing my company website with all the requested information on it as identified in the document types. This too was rejected. Sadly I provided the proof of purchase for my domain. They wouldn’t accept it because I bought it under my personal name (newsflash, I registered the business after I bought the domain). I also cannot update my whois record to include my company name. It is a .ca registration and for reasons that I cannot understand half of the words in my company name are restricted. Words such as solutions, ontario and inc. I have sent articles of incorporation, government documents, everything but my DNA. Still rejected. I am very willing to work with Microsoft to get this sorted out, but I cannot unless they tell me what is failing! Please help me find the path forward. Somebody has to know what it is! And SHAME on you Microsoft. This has been a problem since last year according to all the posts in this forum. Fix it! Read More
somebody pls give me 100000 reward binge points
anybody in the whole wide world. pls give me a 20000microsoft reward points pleeeasssee.
someone scammed me and other people hacked me because i had 700 points while i was saving
for a robox robux gift card and fortnite coins now i am broke pls give back my pointss
anybody in the whole wide world. pls give me a 20000microsoft reward points pleeeasssee. someone scammed me and other people hacked me because i had 700 points while i was saving for a robox robux gift card and fortnite coins now i am broke pls give back my pointss Read More
Key announcements for AKS from KubeCon Europe 2024
At KubeCon Europe 2024, we showed how Azure and Kubernetes can help you build and deploy intelligent applications. Even if you couldn’t visit us at the Microsoft booth or attend the conference sessions, you can read about all the exciting ways we’re making Azure Kubernetes Service (AKS) the best destination for all things cloud-native—including the latest AI and machine learning (ML) applications. With enhancements to security, performance, networking, observability, and more, AKS provides even more platform-as-a-service benefits on top of a smoother onboarding experience for a great end-to-end developer experience.
Powering AI, ML, and compute-intensive workloads
Principal PM Lead for AKS Jorge Palma gave the keynote address, where he explored what AI can do for your platform and how to balance cost and security. Open source tools can give you an advantage, and the new AI toolchain operator (KAITO) add-on for AKS is now in preview. KAITO simplifies the experience of training and inferencing for open-source large language models (LLMs). Using the Karpenter node autoprovisioning functionality, KAITO helps you run AI workloads more cost-effectively by provisioning graphical processing units (GPUs) right when you need them. In other GPU news, AKS now supports Windows GPUs, enabling you to run compute-intensive workloads on Windows nodepools.
As the number of Kubernetes clusters grows from hundreds to thousands, you need a way to efficiently manage your platform. We continue to work with the open-source community to extend fleet workload orchestration. With Azure Kubernetes Fleet Manager, you can now schedule workloads to clusters based on new heuristics such as cost and availability of resources. You can also customize cluster-specific resources by targeting groups of clusters through resource override.
We’re proud to work with the open-source community on these enhancements. We also contributed to OpenTelemetry on another big milestone: HTTP semantic conventions declared stable.
Making Kubernetes easier to adopt
Misconfigurations are the bedbugs of Kubernetes deployments. To make life easier for dev teams, we added safety guardrails to AKS based on Azure Policy controls. You can now configure Deployment safeguards (preview) that apply Kubernetes best practices and notify you of misconfigurations in your AKS cluster. You can even enforce compliance and deny deployments that don’t follow best practices.
If you’re a Windows developer, you can now take advantage of Windows Gen 2 VMs and custom kubelet configuration. With these features, you can expect your Windows workloads to run on AKS with better performance, security, and compatibility. Gen2 VMs on Windows are supported for WS2022 only.
We’ve also made it easier to track the everyday costs associated with running Kubernetes clusters. The cost analysis add-on for AKS is now generally available. You can use Azure portal to view costs with Kubernetes-specific levels of granularity, such as by namespace, pod, and cluster in addition to Azure asset categories.
Improving security and networking
We announced a host of new security features at KubeCon Europe 2024, starting with Trusted launch (preview). It improves the security of Gen 2 VMs by protecting against advanced and persistent attack techniques.
In addition, the security improvements in the latest Kubernetes 1.29 release (Mandala) are now available to preview in AKS. You can check out ReadWriteOncePod, PersistentVolume access mode, CSI Node Expand Secret feature, and more.
Diving deep into network management, we added Azure CNI static block IP allocation for AKS (preview). Now Azure CNI can dynamically allocate pod IPs from a subnet separate from the subnet hosting the AKS cluster. That means better IP utilization, performance, scaling, and policy support.
In related CNI news for Linux users, AKS now supports dual stack networking. Azure CNI Overlay allows nodes and pods to have both IPv4 and IPv6 addresses, enhancing connectivity and application compatibility.
AKS also provides more control over a cluster’s network security group (NSG). You can now directly configure allowed host ports in your node pool settings—you specify the allowed host ports on your node pools and add these pools to an Application Security Group. Also, nodes in a node pool can now receive their own dedicated public IP addresses. You can use instance level public IP tags to choose how your traffic routes between Azure and the Internet. And if your services require direct access to a node’s public IP without an intermediary like a load balancer, host ports can now be automatically assigned for pod workloads.
Adding more scalability and observability
We’re always looking for ways to empower developers to do more, and now AKS supports more scalability, performance, and observability in the control plane. In the Standard tier, you now have the performance you need to run larger workloads—anything from batch processing jobs and simulations to ML and multitenanted clusters. Standard tier supports up to a maximum of 5,000 nodes and 100,000 pods per cluster.
If you want to track all those workloads using Prometheus metrics, now you can. Azure Monitor managed service for Prometheus enables you to collect and analyze metrics at scale based on the Prometheus project from the Cloud Native Computing Foundation. This service debuted last year in 26 regions and is now available in 13 additional public Azure regions.
AKS supports Kubernetes Logs metadata as well. You can query objects using labels and selectors and perform bulk actions on specific subsets, like consumption or updates.
For services that use a load balancer, you can now switch the inbound pool type in AKS for greater efficiency in provisioning VMs. This improvement is particularly beneficial for clusters with large numbers of nodes.
Managing storage volumes with Azure Container Storage
Last year at KubeCon North America, we released the preview of Azure Container Storage, a fully managed, cost-efficient volume orchestration service built natively for Kubernetes. This year, we have announced notable enhancements that improve costs and simplify tedious tasks, such as manually managing volumes.
Azure Container Storage can help you avoid scaling bottlenecks and other challenges that come with running stateful container applications—including the cost of running persistent storage. Check out the overview.
Learn more
For more information about working with AKS:
Get started with Azure Kubernetes Service
Watch the recordings from our Azure Day with Kubernetes event in Paris
Get a copy of Kubernetes Best Practices, Second Edition
Microsoft Tech Community – Latest Blogs –Read More
New bookings redirects people who sign in with a personal account to LIVE.COM and give error
When I send out my bookings page to the public, and people who get it are forced to select guest or sign in – if they sign in with a personal microsoft account, they are re-directed to LIVE.COM and it displays the error message that they don’t have access “bookings with me”.
i understand that personal microsoft accounts can’t have bookings with the personal account, but I’m using a work account, sending out the public for them to create a booking with me. Why is this redirecting them after sign-in to LIVE.COM instead of landing them on my public bookings page.
I know they could know to sign is as guest, but then the process requires them to provide an email, and then requires them to verify that email with a code before making the booking. (because they aren’t logged in as anyone).
Please have someone investigate that redirect to LIVE.COM – that’s dumb.
When I send out my bookings page to the public, and people who get it are forced to select guest or sign in – if they sign in with a personal microsoft account, they are re-directed to LIVE.COM and it displays the error message that they don’t have access “bookings with me”. i understand that personal microsoft accounts can’t have bookings with the personal account, but I’m using a work account, sending out the public for them to create a booking with me. Why is this redirecting them after sign-in to LIVE.COM instead of landing them on my public bookings page. I know they could know to sign is as guest, but then the process requires them to provide an email, and then requires them to verify that email with a code before making the booking. (because they aren’t logged in as anyone). Please have someone investigate that redirect to LIVE.COM – that’s dumb. Read More
Changing default TCP window size using registry key
Using this registry DWORD value – TcpWindowSize in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters to change the default TCP Window Size does not seem to improve the perfromance of the throughput. It seems this reg key doesn’t work any more.
Using this registry DWORD value – TcpWindowSize in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters to change the default TCP Window Size does not seem to improve the perfromance of the throughput. It seems this reg key doesn’t work any more.
https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/description-tcp-features#tcp-window-size Read More
Allow only specific domain to email a distribution group
I’d like to allow only a specific external sender domain to send email to our distribution group (DG) in M365. (The DG is actually a mail-enabled security group synced from AD.) I see that a mail-flow rule doesn’t process until after the DG is expanded, so can’t match the DG as the recipient. I see that the DG has an attribute dLMemSubmitPerms to specify who’s permitted to send to the group, but I think that is only for objects in AD and wouldn’t be able to use an external domain? When I try to modify dLMemSubmitPerms I get an error anyway.
So how can this be done?
I’d like to allow only a specific external sender domain to send email to our distribution group (DG) in M365. (The DG is actually a mail-enabled security group synced from AD.) I see that a mail-flow rule doesn’t process until after the DG is expanded, so can’t match the DG as the recipient. I see that the DG has an attribute dLMemSubmitPerms to specify who’s permitted to send to the group, but I think that is only for objects in AD and wouldn’t be able to use an external domain? When I try to modify dLMemSubmitPerms I get an error anyway.So how can this be done? Read More
Authentication with API based messaging extension
Hey Everyone!
We have created API based messaging extension with Open API specification file. Currently we have uploaded the custom app as API based messaging extension on Teams. Without authentication, I’m able to run this custom app on M365 copilot as well as run in personal app messaging extension. However, when I implement authentication and enable auth type as “MicrosoftEntra” and setup my AAD accordingly, I could generate authentication token from my personal app messaging extension. But M365 copilot is not able to generate a token for my open API when this plugin is enabled in M365 copilot. Could you please help me understand the issue and what needs to be done here?
we have referred to below links. The suggestions given does not work for M365 auth.
1. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/build-api-based-message-extension?tabs=token-v2
2. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/api-based-overview
Hey Everyone!
We have created API based messaging extension with Open API specification file. Currently we have uploaded the custom app as API based messaging extension on Teams. Without authentication, I’m able to run this custom app on M365 copilot as well as run in personal app messaging extension. However, when I implement authentication and enable auth type as “MicrosoftEntra” and setup my AAD accordingly, I could generate authentication token from my personal app messaging extension. But M365 copilot is not able to generate a token for my open API when this plugin is enabled in M365 copilot. Could you please help me understand the issue and what needs to be done here?we have referred to below links. The suggestions given does not work for M365 auth.1. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/build-api-based-message-extension?tabs=token-v22. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/api-based-overview Read More
Can we please get a fix for muting individual tabs?
Currently if you have more than a handful of tabs, the mute tab button on each individual tab stops working. For me, when I have 12+ tabs on my 1080p display. There’s no reason for behavior-there is more than enough physical space to press the mute button. This functionality works fine on Chrome, you can have plenty of tabs, but this is still a problem on Edge and has been for years.
Chrome is going to push a new garbage UI update soon, so I (and many others) are looking for a new browser. This mute functionality is a dealbreaker, if there is a way this can be fixed it would be wonderful.
Currently if you have more than a handful of tabs, the mute tab button on each individual tab stops working. For me, when I have 12+ tabs on my 1080p display. There’s no reason for behavior-there is more than enough physical space to press the mute button. This functionality works fine on Chrome, you can have plenty of tabs, but this is still a problem on Edge and has been for years. Chrome is going to push a new garbage UI update soon, so I (and many others) are looking for a new browser. This mute functionality is a dealbreaker, if there is a way this can be fixed it would be wonderful. Read More
How does maximum-on-demand-scan-threads on MDE Linux affect performance?
Hello. I’m interested in achieving the best performance for on-demand/custom scans. Some of the benchmarks I’ve been seeing are very confusing and I was hoping someone could help clarify.
I have two Linux servers (16 CPU cores each) running MDE. Both servers have an NFS share mounted. There is a folder containing 1859 files that I want to scan.
On the first Linux server, scanning with max 2 threads took just under 16 minutes:
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 15m57.667s
user 0m0.124s
sys 0m0.111s
Then I bumped the max threads to 16, which reduced the overall time to just over 2 minutes. It sounded great at first, but I reduced back to 2 threads immediately and re-scanned, which took under 2 minutes. To me, this means the drastic time change is not a result of the number of threads, but likely that MDE is caching results.
$ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 2m9.889s
user 0m0.030s
sys 0m0.031s
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 1m54.150s
user 0m0.040s
sys 0m0.030s
Does anyone know if MDE in fact caches results? If so, are they cached locally or on the cloud side? Is there any way to clear the cache? To check if they are cached in the cloud, I ran the same scan from the second Linux server using 16 threads and it took 19 minutes. That suggests the cache is local, if it exists at all.
Some other questions I have:
* maximum-on-demand-scan-threads controls the maximum – is there a way to find out how many are/were used? Aside from the caching issue, scanning with max 2 and max 16 seem to take about the same amount of time.
* Does changing maximum-on-demand-scan-threads take effect immediately? I haven’t seen documentation that suggests it only takes effect after restarting the wdavdaemon services or rebooting, etc.
Side note: The Linux servers do not run auditd. There are no firewall rules blocking network connections (cloud protection is enabled).
Hello. I’m interested in achieving the best performance for on-demand/custom scans. Some of the benchmarks I’ve been seeing are very confusing and I was hoping someone could help clarify. I have two Linux servers (16 CPU cores each) running MDE. Both servers have an NFS share mounted. There is a folder containing 1859 files that I want to scan. On the first Linux server, scanning with max 2 threads took just under 16 minutes: $ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 15m57.667s
user 0m0.124s
sys 0m0.111s Then I bumped the max threads to 16, which reduced the overall time to just over 2 minutes. It sounded great at first, but I reduced back to 2 threads immediately and re-scanned, which took under 2 minutes. To me, this means the drastic time change is not a result of the number of threads, but likely that MDE is caching results. $ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 2m9.889s
user 0m0.030s
sys 0m0.031s
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 1m54.150s
user 0m0.040s
sys 0m0.030s Does anyone know if MDE in fact caches results? If so, are they cached locally or on the cloud side? Is there any way to clear the cache? To check if they are cached in the cloud, I ran the same scan from the second Linux server using 16 threads and it took 19 minutes. That suggests the cache is local, if it exists at all. Some other questions I have: * maximum-on-demand-scan-threads controls the maximum – is there a way to find out how many are/were used? Aside from the caching issue, scanning with max 2 and max 16 seem to take about the same amount of time. * Does changing maximum-on-demand-scan-threads take effect immediately? I haven’t seen documentation that suggests it only takes effect after restarting the wdavdaemon services or rebooting, etc. Side note: The Linux servers do not run auditd. There are no firewall rules blocking network connections (cloud protection is enabled). Read More
How to share one plan only
Hi,
I have created a group for all my projects and this is private. Each projects has a plan created within the group. I am the only member. However, I would like to find a way to share only some of the plans when i go on holiday so my manager can view the progress of those projects. But today I tried to add him as member but it got added to the group and he could see and amend all of my plans (projects).
How can i do to only share one plan (project) to him? do i have to create another group and call it shared and copy the plans i want to shre into it and then invite him in that group? the only problem with that solution, it creates a duplication of data.
is there any other way to only share one plan but not all plans within a group?
thanks
Hi, I have created a group for all my projects and this is private. Each projects has a plan created within the group. I am the only member. However, I would like to find a way to share only some of the plans when i go on holiday so my manager can view the progress of those projects. But today I tried to add him as member but it got added to the group and he could see and amend all of my plans (projects). How can i do to only share one plan (project) to him? do i have to create another group and call it shared and copy the plans i want to shre into it and then invite him in that group? the only problem with that solution, it creates a duplication of data. is there any other way to only share one plan but not all plans within a group? thanks Read More
How to configure cipher suites for STARTTLS?
I configured the available cipher suites for an Exchange 2013 server as described here in the best practice document by putting them into the appropriate registry key:
HKLM:SYSTEMCurrentControlSetControlCryptographyConfigurationLocalSSL0010002
But when looking at a packet capture of an outgoing SMTP session of that server which used STARTTLS, I observed that it was offering a completely different set of ciphers. Is that registry key not being used for STARTTLS by Exchange Server and if so, where do the ciphers for that have to be configured instead?
I configured the available cipher suites for an Exchange 2013 server as described here in the best practice document by putting them into the appropriate registry key:HKLM:SYSTEMCurrentControlSetControlCryptographyConfigurationLocalSSL0010002But when looking at a packet capture of an outgoing SMTP session of that server which used STARTTLS, I observed that it was offering a completely different set of ciphers. Is that registry key not being used for STARTTLS by Exchange Server and if so, where do the ciphers for that have to be configured instead? Read More
Can VBA dynamically insert data in rows on one worksheet based on the number rows w. data on another
Windows 10
Excel 2019
Is possible for VBA dynamically insert data in rows on one worksheet based on the number rows on another worksheet in the same workbook?
I have a workbook with two worksheets named “Title Data” and “Track Data”.
Both worksheets have headers.
The number of rows with data in worksheet “Track Data” can vary, new data maybe added, and some may be deleted.
The VBA code below pulls selected data from “Track Data” in to “Title Data” .
I have to manually specify the number of rows which I have set at 50000 in code as seen in the snippit…
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I50000”), Type:=xlFillDefault
At the moment there is only 33,105 rows with data so I see no point in adding more rows of formulas than is needed as the code takes a while to run as it is.
Can the above code snippit be dynamic where the VBA, when it is run, looks in the “Track Data” worksheet and counts the number of rows with data and then copies the formulas into “Title Data” and only fills the forumalas down to match the number of rows with data in “Track Data” ?
So if there are 10,000 rows in “Track Data” with data, the VBA the copies the formulas down 10,000 rows in “Title Data” and if there are 90,000 rows then it adds 90,000 rows of formulas.
I may be thinking rubbish but if I do not ask then I will not know the answer as this is beyond my knowledge.
Thank you everyone.
Sub PullTitlesDataTest2()
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
‘ Starting with cell A2 through to cell I2, and down to row 40,000, this inserts the forumlas to
‘ pull the data from the worksheet “Track Data*
Range(“A2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC),””””,’Track Data’!RC)”
Range(“B2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-1]),””””,’Track Data’!RC)”
Range(“C2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-2]),””””,’Track Data’!RC[6])”
Range(“D2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-3]),””””,’Track Data’!RC[6])”
Range(“E2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-4]),””””,’Track Data’!RC)”
Range(“F2”).Select
ActiveCell.FormulaR1C1 = “=IF(AND(RC[-5]=R[1]C[-5],RC[-4]=R[1]C[-4],RC[-3]=R[1]C[-3],RC[-2]=R[1]C[-2]),””””,TEXTJOIN(“”+””,,CHOOSE({1,2},IF(COUNTIFS(R2C[-1]:RC[-1],1,R2C[-4]:RC[-4],RC[-4]),””M””,””””),IF(COUNTIFS(R2C[-1]:RC[-1],2,R2C[-4]:RC[-4],RC[-4]),””S””,””””),2)))”
Range(“G2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-6]),””””,’Track Data’!RC[-1])”
Range(“H2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-7]),””””,’Track Data’!RC[-1])”
Range(“I2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-8]),””””,IF(‘Track Data’!RC[-1]=””.wav””,””Wav””,IF(‘Track Data’!RC[-1]=””.flac””,””Flac””,IF(‘Track Data’!RC[-1]=””.aif””,””Aif””,IF(‘Track Data’!RC[-1]=””.mp3″”,””MP3″”,IF(‘Track Data’!RC[-1]=””.SD2″”,””SD2″”,””UNKNOWN TYPE””))))))”
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I40000”), Type:=xlFillDefault
Range(“A2:I40000”).Select
Application.GoTo Reference:=”R2C1″
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
End Sub
Windows 10Excel 2019Is possible for VBA dynamically insert data in rows on one worksheet based on the number rows on another worksheet in the same workbook? I have a workbook with two worksheets named “Title Data” and “Track Data”.Both worksheets have headers. The number of rows with data in worksheet “Track Data” can vary, new data maybe added, and some may be deleted. The VBA code below pulls selected data from “Track Data” in to “Title Data” . I have to manually specify the number of rows which I have set at 50000 in code as seen in the snippit… Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I50000”), Type:=xlFillDefault At the moment there is only 33,105 rows with data so I see no point in adding more rows of formulas than is needed as the code takes a while to run as it is. Can the above code snippit be dynamic where the VBA, when it is run, looks in the “Track Data” worksheet and counts the number of rows with data and then copies the formulas into “Title Data” and only fills the forumalas down to match the number of rows with data in “Track Data” ? So if there are 10,000 rows in “Track Data” with data, the VBA the copies the formulas down 10,000 rows in “Title Data” and if there are 90,000 rows then it adds 90,000 rows of formulas. I may be thinking rubbish but if I do not ask then I will not know the answer as this is beyond my knowledge. Thank you everyone. Sub PullTitlesDataTest2()
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
‘ Starting with cell A2 through to cell I2, and down to row 40,000, this inserts the forumlas to
‘ pull the data from the worksheet “Track Data*
Range(“A2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC),””””,’Track Data’!RC)”
Range(“B2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-1]),””””,’Track Data’!RC)”
Range(“C2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-2]),””””,’Track Data’!RC[6])”
Range(“D2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-3]),””””,’Track Data’!RC[6])”
Range(“E2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-4]),””””,’Track Data’!RC)”
Range(“F2”).Select
ActiveCell.FormulaR1C1 = “=IF(AND(RC[-5]=R[1]C[-5],RC[-4]=R[1]C[-4],RC[-3]=R[1]C[-3],RC[-2]=R[1]C[-2]),””””,TEXTJOIN(“”+””,,CHOOSE({1,2},IF(COUNTIFS(R2C[-1]:RC[-1],1,R2C[-4]:RC[-4],RC[-4]),””M””,””””),IF(COUNTIFS(R2C[-1]:RC[-1],2,R2C[-4]:RC[-4],RC[-4]),””S””,””””),2)))”
Range(“G2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-6]),””””,’Track Data’!RC[-1])”
Range(“H2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-7]),””””,’Track Data’!RC[-1])”
Range(“I2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-8]),””””,IF(‘Track Data’!RC[-1]=””.wav””,””Wav””,IF(‘Track Data’!RC[-1]=””.flac””,””Flac””,IF(‘Track Data’!RC[-1]=””.aif””,””Aif””,IF(‘Track Data’!RC[-1]=””.mp3″”,””MP3″”,IF(‘Track Data’!RC[-1]=””.SD2″”,””SD2″”,””UNKNOWN TYPE””))))))”
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I40000”), Type:=xlFillDefault
Range(“A2:I40000”).Select
Application.GoTo Reference:=”R2C1″
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
End Sub Read More