Category: Microsoft
Category Archives: Microsoft
Another Issue with previous row/column references
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:
Given this:
I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in
10 15 15 25
Using the bleeding edge version of 365.
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:Given this:I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in 10 15 15 25 Using the bleeding edge version of 365. Read More
Sneaky Windows 10 update:
I have a windows 10 pro laptop and received a notice for an update required to go from 22H2 to 23H2 which I thought was a new version of Windows 10. When the update finished they had installed windows 11 without my permission. I think this is a terrible practice as I was not ready nor did I want to upgrade at this time. I have Windows 11 on other Pc’s and really don’t like it and prefer windows 10 as it avoids the windows 11 constant bombardment of advertising and useless apps and constant invasion of privacy that has gotten so much worse with Windows 11. So anyone with Windows 10 be careful of this deceptive practice or you will be tricked like me. Very dissappointing experience.
I have a windows 10 pro laptop and received a notice for an update required to go from 22H2 to 23H2 which I thought was a new version of Windows 10. When the update finished they had installed windows 11 without my permission. I think this is a terrible practice as I was not ready nor did I want to upgrade at this time. I have Windows 11 on other Pc’s and really don’t like it and prefer windows 10 as it avoids the windows 11 constant bombardment of advertising and useless apps and constant invasion of privacy that has gotten so much worse with Windows 11. So anyone with Windows 10 be careful of this deceptive practice or you will be tricked like me. Very dissappointing experience. Read More
Bing Web Master data not updated for 4 days
I run a site and have been tracking its searches traffic on Bing Webmaster Tools, where it shows clicks and impressions. However, the data stopped updating and has been stuck for last 4 days with no updates related to my site’s performance on Bing. My site is iotools.cloud and it helps people with various online front end tools. Does anyone have the same issue or found any updates from Bing?
I run a site and have been tracking its searches traffic on Bing Webmaster Tools, where it shows clicks and impressions. However, the data stopped updating and has been stuck for last 4 days with no updates related to my site’s performance on Bing. My site is iotools.cloud and it helps people with various online front end tools. Does anyone have the same issue or found any updates from Bing? Read More
Calculating which % of users fill out different data points
Hi,
I have a list of users for my company platform and I’m trying to use the data to create stats but I’m not very familiar with excel. For example, I’m trying to understand what percentage of users have actually made a post on the platform. How do I do this?
Example of data:
Hi, I have a list of users for my company platform and I’m trying to use the data to create stats but I’m not very familiar with excel. For example, I’m trying to understand what percentage of users have actually made a post on the platform. How do I do this? Example of data: Read More
What URLs are allowed when a device is in isolation?
I have a customer who’s asking what URLs are allowed when a device has been set to “Isolated”. I know there’s full isolation (where the only thing allowed is the Defender ATP service) and selective isolation (for Windows devices which allows Outlook, Teams and Skype for Business).
Per “Take response actions on a device in Microsoft Defender for Endpoint – Microsoft Defender for Endpoint“, when isolating a device, “only certain processes and destinations are allowed.”
So:
#1-is there a more detailed list of what’s allowed?
#2-is it configurable?
Thanks!
I have a customer who’s asking what URLs are allowed when a device has been set to “Isolated”. I know there’s full isolation (where the only thing allowed is the Defender ATP service) and selective isolation (for Windows devices which allows Outlook, Teams and Skype for Business).
Per “Take response actions on a device in Microsoft Defender for Endpoint – Microsoft Defender for Endpoint”, when isolating a device, “only certain processes and destinations are allowed.”
So:
#1-is there a more detailed list of what’s allowed?
#2-is it configurable?
Thanks! Read More
Am i going to be automatically upgraded to office 2024
I currently subscribe to Microsoft Office, and I currently have the latest version
(Version 2407 Build 16.0.17830.20016) 64-bit
I don’t know if this is already office 2024 or not. If it’s not, will I automatically recieve the new Office 2024, or will I have to purchase it again? There isn’t any infomation currently on the internet to answer my question.
I currently subscribe to Microsoft Office, and I currently have the latest version(Version 2407 Build 16.0.17830.20016) 64-bit I don’t know if this is already office 2024 or not. If it’s not, will I automatically recieve the new Office 2024, or will I have to purchase it again? There isn’t any infomation currently on the internet to answer my question. Read More
Microsoft at TechCon365 – Washington, D.C. (August 12-16, 2024)
“This was by far the most robust, wide ranging, and useful collection of content I’ve ever had delivered through a conference. Next time I attend, I’ll definitely be bringing my colleagues!”
– Previous TechCon365 attendee (Note to future attendees: Bring your colleagues. :))
What: TechCon365 – D.C.
Register today |Use the MSCMTY discount code to save $200 USD off registration.
Content: 1 Microsoft keynote + 1 AMA || 140 overall sessions – 52 Microsoft-led sessions (review all Microsoft-led sessions) | 25 full-day workshops
Microsoft is sending over 30+ product makers to present and engage.
Review all sessions + agenda view, workshops, and their full speaker lineup.
When & where: August 12-16, 2024
In-person: Washington, D.C. – Walter E. Washington Convention Center
Twitter & hashtag: @TechCon365 | #TechCon365
Cost: $850 – $2,775 (Learn more about ticket pricing options) – Use our MSCMTY code to get a $200.00 USD discount.
At TechCon365 – D.C., a Microsoft 365 Conference & Power Platform Conference, the subject matter is divided into tracks and each session is designated for beginner, intermediate, advanced or expert.
Explore the latest in Microsoft 365 and AI innovations.
Amp up your expertise with Power Platform insights.
Network with top industry leaders and IT pros.
Acquire actionable knowledge to elevate your career.
With 2 optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops presented by Microsoft 365, SharePoint, Power Platform, Microsoft Teams, Viva, Azure, Copilot & AI’s top experts! Whether you are new to Microsoft 365, Power Platform and SharePoint or an experienced power user, admin or developer, TechCon365 has content designed to fit your experience level and area of interest.
See how the Microsoft 365, SharePoint Power Platform, Azure, and AI ecosystem is growing and evolving by speaking with technical experts from the local Microsoft field and diverse channels within the Microsoft Partner Network – all in our exhibit hall (25 sponsors).
Microsoft keynotes, sessions, and workshops: Copilot/AI, SharePoint, OneDrive, Teams, Viva, Power Platform, D&I, and related technology
Microsoft keynote, Ask Microsoft Anything (AMA), and inspiring Diversity & Inclusion meetup
Hear from Microsoft leadership revealing the latest innovations shaping the flexible, innovative, and secure business environments of the future. Plus, a unique opportunity to ask your questions. [all times listed in EDT]
Microsoft 365 keynote: “Thriving in the era of AI”
Presenter: Karuana Gatimu, Principal PM Manager – Microsoft 365 Community and Adoption Group, Microsoft
Date/Time: Wednesday, August 14th, 8:30am – 9:40am EDT
Location: Ballroom A
Panelists: Karuana Gatimu, Bob Ward, Pat Mahoney, Naomi Moneypenny, and Kristi Kelly
Date/time: Wednesday, August 14th, 1:10pm – 2:20pm EDT
Location: Ballroom B
“Women in Tech and Allies Meetup”
Panelists: Karuana Gatimu, Kristi Kelly, Tiffany Lee, Naomi Moneypenny, and Rima Reyes
Date/time: Thursday, August 15th, 4:20pm – 5:30pm
Location: Room 207A
Register today | Note: Use the MSCMTY discount code to save $200 USD off registration.
Take the opportunity to select the sessions best suited for your role and interests. All breakouts bring product updates, demos, customer stories, best practices, and insights into product and solution strategy – including guidance on the future.
And find us in the Community Zone – A place to connect with Microsoft MVPs, MCM, Microsoft Regional Directors, and user group leaders via Ask the Experts tables and in the Community Lounge when you can pick up some laptop stickers and learn more about community programs in the Exhibit Hall.
TechCon365 | Microsoft-led breakout sessions and workshops
It is crucial to ensure your organization is technically ready for the full potential of Copilot for Microsoft 365. The sessions below focus on technical readiness and ensuring you have the latest guidance. Our experts will share best practices and provide guidance on how to leverage AI and to maximize the benefits of Microsoft 365, Power Platform, and Microsoft Fabric throughout your organization. Note: All breakout sessions are 70 minutes.
Copilot and AI
“The Art of Prompt Engineering in M365 Copilot” with Michelle Gilbert
“Technical Readiness for Copilot for Microsoft 365” with Ben Summers
“The AI Enabled Agency” with Kevin Tupper
“Empowering US Federal Agencies with Microsoft Copilot: A Roadmap to AI Democratization” with Steve Winward and Jay Leask
“Citizens Services and Generative AI – A new way to engage!” with Dave Bailey and Daniel Cox
“Protect at the speed and scale of AI with Microsoft Copilot for Security” with Rick Engle
“Securing the Future: AI-Enhanced Cybersecurity in Federal Agencies” with Brian Trich
“Copilot Extensibility: Updates from Microsoft Build” with Bob German
“Getting Started Making Copilots with Assistants, Graph, and AI Search” with Fabian Williams and Doug Ware
“Learning Hack: Building Smarter Skilling with Copilot” with Tom Resing and Paul Stubbs
“Bring your business data into Microsoft Copilot with Plugins and Connectors” with Bob German
WORKSHOP | “Building Generative AI Applications: GPTs, Copilots, and Chatbots” with Doug Ware and Fabian Williams
Microsoft 365
“Delivering User Satisfaction and Adoption Practices for Microsoft 365” with Karuana Gatimu
“How Microsoft Federal Supports the US Government” with Jason Payne and Karuana Gatimu
“The Future of Your Intranet: Beautiful, flexible and AI ready powered by SharePoint” with Katelyn Helms
“Unlock SharePoint Premium content services by connecting Azure Pay-as-you-go billing” with Tom Resing
“Teams Emergency Operations Center – Modernizing communications in critical incidents” with Tiffany Lee and Josh Leporati
“What’s New for Microsoft 365 Admins” with Josh Leporati
“Top 10 best practices every admin should be doing in Microsoft 365” with Michelle Gilbert
“Managing Change in a Microsoft World! Office 365 Governance and Change Management” with Michelle Gilbert
“Mastering Microsoft Lists” Tiffany Lee and Josh Leporati
“New Planner: Unifying Task Management in Microsoft Teams” with Alexander Lahuerta
“Building Multi-tenant apps for Microsoft 365” with Bob German and Julie Turner
“Introduction to the Microsoft Graph” with Fabian Williams
“Unlock Third Party or Line of Business Data using Graph Connectors and Copilot “ with Fabian Williams
WORKSHOP | “Ultimate guide to administering M365 and Teams” with Michelle Gilbert
Microsoft Viva
“What’s new and next for Microsoft Viva” with Kristi Kelly
“Getting started with Viva Amplify” with Naomi Moneypenny
“AI in Viva Engage for communications and knowledge management” with Kristi Kelly
Power Platform
“Power Platform and Dynamics 365 in the Federal Government” with Brendon Colburn
“Better Together: Azure + Power Platform in the Federal Government” with Jamie Willis-Rose, Chris Boretos, and Ruth Delaney
“Securing and governing the Power Platform at scale” with Ken Aguillard
“Have you met your new Trainer? – AI as a learning tool in the Power Platform” with Craig Harris
“To Build or Buy: Case Management in Dynamics 365 or Power Apps” with Jamie Willis-Rose
“Modernizing Paper Form Processing with Power Platform and AI” with Jamie Willis-Rose and Sunny Eltepu
“Build enterprise web sites with Power Pages” with Meera Mahabala
“Dataverse Virtual Tables – Build a Custom Provider” with Jim Novak
Microsoft Fabric and Power BI
“Threads of Innovation: A Comprehensive Overview of Microsoft Fabric” with Pat Mahoney
“Unify your data with OneLake and Microsoft Fabric” with Matt Basile
“Ingest, Transform, and Act in Real-Time with Microsoft Fabric” with Tzvia Gitlin Troyna
“Connect to your M365 Data with Microsoft Fabric and Microsoft Graph Data Connect” with John White and Jason Himmelstein
“Getting Started with SQL, AI, and Microsoft Fabric” with Bob Ward
“Deep Dive on Power BI, Teams and SharePoint” with John White and Jason Himmelstein
“Healthcare Virtual Data Tables” with Jim Novak
“Power BI Analytics at Scale with Microsoft Fabric” with John White and Jason Himmelstein
“There’s No Time Like the Present – Real Time Reporting with Power BI” with John White and Jason Himmelstein
“Protect and Manage Your Enterprise Data Effectively at Scale for safeguarding AI-enabled application” with Mihaela Blenda
“Security and Compliance in Microsoft Fabric” with Rick Xu
WORKSHOP | “Everything You Wanted to Know About Power BI… but were afraid to ask!” with John White and Jason Himmelstein
Register today | Note: Use the MSCMTY discount code to save $200 USD off registration.
Get the most out of TechCon365: Our top five tips while attending
Introduce yourself | Unique perspectives await, including yours.
Attend as much as you can | Laptops down, eyes open – depth learning, tips, and tricks abound.
Share what you know |Your knowledge saves time – pay it forward.
Ask questions, share feedback | Your issues and ideas Inform us and influence the roadmap.
Hydrate and dress for steps | Keep the brain healthy and mind active.
BONUS | Update your LinkedIn profile and photo | Best reflect your professional experience and growing technical aptitude.
Learn more
Visit TechCon365.com/DC and follow the action on X/Twitter: @TechCon365, @Microsoft365, @MSFTCopilot, @SharePoint, @OneDrive, @MicrosoftTeams, @MSPowerPlat, @MicrosoftFabric, @MSPowerBI, @Microsoft365Dev, and @MSFTAdoption.
I hope you will join us in D.C. for what will be a fantastic week “near the capitol”! We’re looking forward to the action alongside the community, MVPs, and Microsoft product members from Copilot, Teams, Office, SharePoint, OneDrive, Loop, Viva, Power Platform, Lists, Planner, and more.
Remember, use the discount code MSCMTY discount code to save $200 USD off your conference registration. Register today!
Last, a glimpse of the TechCon365 event experience:
Cheers,
Karuana Gatimu and Heather Cook
Microsoft Tech Community – Latest Blogs –Read More
Save Costs with Basic SKU Application Gateway for more features and less fixed costs
Hi All!
If you are one of the customers looking to save Costs with Application Gateway for better features than v1 SKU with limited applications as backend pools, here is a post for you!
The Azure Application Gateway Basic SKU is an excellent choice for customers who have applications with lower traffic and do not necessitate high Service Level Agreements (SLAs). This feature is currently in public preview. It’s a cost-effective solution that still provides core application-level load balancing features, such as URL-based, host-based, and multi-site routing, as well as cookie-based affinity. This SKU supports a variety of flexible backends, including Azure Kubernetes Service (AKS), Virtual Machine Scale Sets (VMSS), App Services, and on-premises deployments. With built-in high availability and support for HTTP2/HTTPS and WebSocket protocols, the Basic SKU ensures reliable application delivery without the need for advanced traffic management features. For small to medium-sized enterprises or developers seeking a balance between functionality and cost, the Azure Application Gateway Basic SKU presents a compelling option.
Let’s delve into the details of the Azure Application Gateway Basic SKU. This SKU is designed for applications with lower traffic and SLA requirements, and it doesn’t require advanced traffic management features.
Here are the key points:
Advantages of Basic SKU:
Basic SKU Features:
High Availability: The Basic SKU includes built-in high availability.
Protocol Support: It supports HTTP2/HTTPS and WebSocket protocols.
Load Balancing: Core application-level load balancing features include URL-based, host-based, and multi-site routing, along with cookie-based affinity.
Key Vault integration capabilities
Header Rewrite
Comparison with Standard V2 SKU:
Performance: The Basic SKU is suitable for smaller workloads with a restriction of the number of backend pools supported upto 5 and also supports zone redundancy, while the Standard V2 SKU offers higher performance, autoscaling, zone redundancy, private application gateway, private link, mTLS and static VIPs.
Autoscaling: The Standard V2 SKU allows autoscaling based on changing traffic patterns, whereas the Basic SKU doesn’t offer autoscaling.
Static VIP: Basic SKU exclusively supports static VIPs, ensuring the VIP associated with the application gateway remains unchanged throughout its lifecycle.
URL Rewrite: Only Standard V2 SKU allows you to add, remove, or update an URL.
Security: When there is a need to use Web Application Firewall, it is better to choose WAF V2 SKU over Basic SKU as Basic SKU Application Gateway doesn’t support Web Application Firewall yet.
When to Use Basic SKU:
Lower Traffic Workloads: Choose the Basic SKU for applications with lower traffic.
Cost Savings: If advanced features aren’t necessary, Basic SKU provides cost savings.
Zone Redundancy: If you need zone redundancy only for limited number of applications served as backends, choose the Basic SKU but if you need zone redundancy along with autoscaling, consider Standard V2 SKU.
Limitations of Basic SKU:
Now let’s explore the limitations of the Azure Application Gateway Basic SKU:
Limited Performance:
The Basic SKU is designed for smaller workloads and has lower performance compared to the Standard V2 SKU. If your application requires high throughput or autoscaling, consider the Standard V2 SKU instead.
No Autoscaling:
Unlike the Standard V2 SKU, the Basic SKU does not support autoscaling based on changing traffic patterns. You’ll need to manually adjust capacity if traffic increases.
Fewer Advanced Features:
The Basic SKU lacks some advanced features available in Standard V2, such as URL rewrite capabilities, private application gateway, private link, Web Application Firewall and mTLS (Mutual TLS Authentication).
Remember to choose the SKU that aligns with your application’s requirements and budget.
Differences between feature support with Basic SKU and Standard V2 SKU Application Gateway
The following table displays a comparison between Basic and Standard_v2.
Feature
Capabilities
Basic SKU (preview)
Standard v2 SKU
Reliability
SLA
99.9
99.95
Functionality – basic
HTTP/HTTP2/HTTPS
Websocket
Public/Private IP
Cookie Affinity
Path-based affinity
Wildcard
Multisite
KeyVault
AKS (via AGIC)
Zone
Header rewrite
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
Functionality – advanced
URL rewrite
mTLS
Private Link
Private-only1
TCP/TLS Proxy
✓
✓
✓
✓
✓
Scale
Max. connections per second
Number of listeners
Number of backend pools
Number of backend servers per pool
Number of rules
2001
5
5
5
5
625001
100
100
1200
400
Capacity Unit
Connections per second per compute unit
Throughput
Persistent new connections
10
2.22 Mbps
2500
50
2.22 Mbps
2500
1Estimated based on using an RSA 2048-bit key TLS certificate.
Here is the source from where I got the differences between Basic SKU and Standard V2 SKU Application Gateway Capabilities.
Additional information/resources:
If you want to try Basic SKU in your lower environments for testing while it is in public preview, please use this article to proceed with the steps to register for the Basic SKU feature in public preview. While preview features are not something we recommend customers to use in production environment, consider production-ready Standard V2 SKU Application Gateway for production workloads. For more information on when the Basic SKU Application Gateway feature will be generally available (GA), stay tuned to Azure Updates.
Savings with fixed costs on Application Gateway Basic SKU:
[I have a Basic SKU Application Gateway with a single backend which is an app service in the East US region with zone redundancy enabled.]
Standard SKU Comparison on Pricing:
[ I have a Standard SKU Application Gateway with a single backend which is an app service in the East US region with zone redundancy enabled.]
For more information on Pricing details and calculations, please check Application Gateway Pricing | Microsoft Azure.
How to register for preview feature Basic SKU Application Gateway using Azure CLI:
https://learn.microsoft.com/en-us/azure/application-gateway/overview-v2#register-for-the-preview
I hope you found this information useful.
Happy reading!
FastTrack for Azure: Move to Azure efficiently with customized guidance from Azure engineering. FastTrack for Azure – Benefits, and FAQ | Microsoft Azure
Microsoft Tech Community – Latest Blogs –Read More
Zelle AI42 Probleme
Hallo Leute in der Zelle AI42 steht ,,#Bezug!,, dadurch kann ich keine Rechnungen mehr machen. Wenn ich die Zelle versuche, zu ändern, kommt immer ,,die Zelle ist schreibgeschützt. Könnt ihr ihr mir bitte helfen?
Hallo Leute in der Zelle AI42 steht ,,#Bezug!,, dadurch kann ich keine Rechnungen mehr machen. Wenn ich die Zelle versuche, zu ändern, kommt immer ,,die Zelle ist schreibgeschützt. Könnt ihr ihr mir bitte helfen? Read More
How to delete rows that have a 0 in every column but not rows that have 1 column thats not 0
I have an excel sheet with 8000+ rows of data, there is 18 columns.
each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column).
i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time
thank you!
I have an excel sheet with 8000+ rows of data, there is 18 columns. each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column). i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time thank you! Read More
Force automatic log outs on Entra Shared Device (iPhone)
I feel really dumb but can’t find how to force Microsoft 365 apps on an Entra Shared Device mode to automatically log out after a certain time?
We have Inventory devices that are used by multiple people and I want them to be logged out automatically after 5 minutes of inactivity, and by « inactivity », I mean 5 minutes of not using a 365 app
I feel really dumb but can’t find how to force Microsoft 365 apps on an Entra Shared Device mode to automatically log out after a certain time? We have Inventory devices that are used by multiple people and I want them to be logged out automatically after 5 minutes of inactivity, and by « inactivity », I mean 5 minutes of not using a 365 app Read More
Block Microsoft 365 account from logging on Windows machine?
Hello! How can I block a user from logging on Windows with Azure AD on our machines, but still allow it to use Microsoft 365?
Basically we have a service account that should only be accessed from iOS MDM devices by default.
A way to exempt some Windows machines would be nice, but the preference is ban the account from Windows logon altogether.
We use Microsoft 365 with Intune. All machines are managed.
Thanks in advance!
Hello! How can I block a user from logging on Windows with Azure AD on our machines, but still allow it to use Microsoft 365? Basically we have a service account that should only be accessed from iOS MDM devices by default.A way to exempt some Windows machines would be nice, but the preference is ban the account from Windows logon altogether. We use Microsoft 365 with Intune. All machines are managed. Thanks in advance! Read More
How to handle MFA for a shared account?
Hello,
We have a business need where some users need to share an Entra ID account for Dynamics 365. I am trying to figure out how to handle MFA for a shared account and what’s the best practice in such cases. We could setup the MFA for this account to the admins’ phones, but this will only create headache for those admins (when they’re out of office, travelling etc.).
Any advice would be appreciated.
Hello, We have a business need where some users need to share an Entra ID account for Dynamics 365. I am trying to figure out how to handle MFA for a shared account and what’s the best practice in such cases. We could setup the MFA for this account to the admins’ phones, but this will only create headache for those admins (when they’re out of office, travelling etc.).Any advice would be appreciated. Read More
Read Item and Subs from System.Windows.Forms.ListView
I am building a UI around a PowerShell script to make it more user friendly. I am have ListView that holds a Queue of Jobs that need to be run. How do I loop through it and get the values of each column so I can pass the properties as variables to another processfunction?
$JobQue = New-Object System.Windows.Forms.ListView
$JobQue.Text = ‘Queued Jobs’
#$JobQue.Font = $DefaultFont
$JobQue.Location = ‘435,140’
$JobQue.Size = ‘730,235’
$JobQue.View = “Details”
$JobQue.Sorting = “Ascending”
$JobQue.CheckBoxes = $true
$JobQue.MultiSelect = $true
$JobQue.FullRowSelect = $true
[VOID]$JobQue.Columns.Add(‘Time’, 170)
[VOID]$JobQue.Columns.Add(‘Source Server’,115)
[VOID]$JobQue.Columns.Add(‘Source DB’,115)
[VOID]$JobQue.Columns.Add(‘Dest Server’,115)
[VOID]$JobQue.Columns.Add(‘Dest DB’,115)
[VOID]$JobQue.Columns.Add(‘Status’,90)
That is the snippet of the JobQue List. Whole PS script is quite large. Trying to do something like this:
$GoButton.Add_Click({
ForEach($Task in $JobQue.Items){
Write-Host “Starting Refresh $Task”
$Task.SubItems.Text
My-Task($Task.[‘Source Server’],$Task.[‘Dest Server’])
}
})
I am building a UI around a PowerShell script to make it more user friendly. I am have ListView that holds a Queue of Jobs that need to be run. How do I loop through it and get the values of each column so I can pass the properties as variables to another processfunction? $JobQue = New-Object System.Windows.Forms.ListView
$JobQue.Text = ‘Queued Jobs’
#$JobQue.Font = $DefaultFont
$JobQue.Location = ‘435,140’
$JobQue.Size = ‘730,235’
$JobQue.View = “Details”
$JobQue.Sorting = “Ascending”
$JobQue.CheckBoxes = $true
$JobQue.MultiSelect = $true
$JobQue.FullRowSelect = $true
[VOID]$JobQue.Columns.Add(‘Time’, 170)
[VOID]$JobQue.Columns.Add(‘Source Server’,115)
[VOID]$JobQue.Columns.Add(‘Source DB’,115)
[VOID]$JobQue.Columns.Add(‘Dest Server’,115)
[VOID]$JobQue.Columns.Add(‘Dest DB’,115)
[VOID]$JobQue.Columns.Add(‘Status’,90) That is the snippet of the JobQue List. Whole PS script is quite large. Trying to do something like this: $GoButton.Add_Click({
ForEach($Task in $JobQue.Items){
Write-Host “Starting Refresh $Task”
$Task.SubItems.Text
My-Task($Task.[‘Source Server’],$Task.[‘Dest Server’])
}
}) Read More
Effectiveness of “Impersonation Protection” within the Standard Protection security policy
Recently we began trying to improve the overall posture of our O365 Exchange. One step of that was enabling both the Preset Security Policies.
These have been enabled and I’ve set up Impersonation Protection on both with pretty much the same list of internal stakeholders to protect. What we appear to be seeing is that impersonation protection doesn’t work for those users on Standard Protection. Support is telling me that’s how it works and that I should move all of our users to Strict Protection if we want to take advantage of the Impersonation Protection.
My limited tests seem to back this up, but the fact that Impersonation Protection is an available option in the Standard preset policy is baffling if it’s as ineffective as it seems to be.
As a test I setup a new outlook.com account with the name of the a protected user. I then sent an email to my personal Gmail account and two internal employees. The email was delivered to the Gmail account (expected) and to the ‘Standard’ employee. The email to the ‘Strict’ employee was quarantined with a note about impersonation. For the ‘Standard’ employee it was allowed with the note “Allowed by user policy : Trusted recipient address list”. I verified the external address is not in the ‘Standard’ user’s Safe Sender list.
Are others seeing this behavior as well?
Recently we began trying to improve the overall posture of our O365 Exchange. One step of that was enabling both the Preset Security Policies. These have been enabled and I’ve set up Impersonation Protection on both with pretty much the same list of internal stakeholders to protect. What we appear to be seeing is that impersonation protection doesn’t work for those users on Standard Protection. Support is telling me that’s how it works and that I should move all of our users to Strict Protection if we want to take advantage of the Impersonation Protection. My limited tests seem to back this up, but the fact that Impersonation Protection is an available option in the Standard preset policy is baffling if it’s as ineffective as it seems to be. As a test I setup a new outlook.com account with the name of the a protected user. I then sent an email to my personal Gmail account and two internal employees. The email was delivered to the Gmail account (expected) and to the ‘Standard’ employee. The email to the ‘Strict’ employee was quarantined with a note about impersonation. For the ‘Standard’ employee it was allowed with the note “Allowed by user policy : Trusted recipient address list”. I verified the external address is not in the ‘Standard’ user’s Safe Sender list. Are others seeing this behavior as well? Read More
Can SharePoint 365 News posts be emailed to external users?
I’m excited to see this new feature that lets us easily send SPO new posts via email! I’m noticing that when I type in an external email address, whether they are a guest in AAD or not, I’m not able to send the new post to them. I’ve been searching the MS community to see if we can send to external emails, since the marketing documentation says you can “send to anyone.” Is emailing to external email addresses supported?
I’m excited to see this new feature that lets us easily send SPO new posts via email! I’m noticing that when I type in an external email address, whether they are a guest in AAD or not, I’m not able to send the new post to them. I’ve been searching the MS community to see if we can send to external emails, since the marketing documentation says you can “send to anyone.” Is emailing to external email addresses supported? Read More
Azure Arc connected Linux machines
I have multiple Linux (various supported distros) connected to Azure via Arc. MDE has deployed automatically and installed successfully on all systems. I created a security group in Entra and added the Service Principal (Entra device objects do not exist, (should they?)) for each Arc connected machine to that Entra Security Group. I have created an Endpoint Security Policy in the Defender portal and applied it to said Entra Security Group. The goal is to manage the auto deployed MDE installation via this policy.
The policy is not applying to any of the Linux servers. The Arc install appears healthy and mdatp health command is showing Healthy:true Licensed:true and the Arc tags etcetera. There are some error logs in /var/log/microsoft/mdatp but nothing jumps out at me as a cause other than the fact that the managed.json file doesn’t exist. My question is, how do I get the MDE install to be managed via this Endpoint Security Policy?
I have multiple Linux (various supported distros) connected to Azure via Arc. MDE has deployed automatically and installed successfully on all systems. I created a security group in Entra and added the Service Principal (Entra device objects do not exist, (should they?)) for each Arc connected machine to that Entra Security Group. I have created an Endpoint Security Policy in the Defender portal and applied it to said Entra Security Group. The goal is to manage the auto deployed MDE installation via this policy.The policy is not applying to any of the Linux servers. The Arc install appears healthy and mdatp health command is showing Healthy:true Licensed:true and the Arc tags etcetera. There are some error logs in /var/log/microsoft/mdatp but nothing jumps out at me as a cause other than the fact that the managed.json file doesn’t exist. My question is, how do I get the MDE install to be managed via this Endpoint Security Policy? Read More
Inbox is not displaying new messages in a usable way
Messages coming into my inbox are not displaying in a readable way (image attached). My sent folder does display correctly (image attached). How I do fix my inbox?? I am running outlook on windows 11 enterprise and “new outlook” toggle is not available due to my organization.
Messages coming into my inbox are not displaying in a readable way (image attached). My sent folder does display correctly (image attached). How I do fix my inbox?? I am running outlook on windows 11 enterprise and “new outlook” toggle is not available due to my organization. Read More
Lack of Windows update group policy for Win 10/11 – “Reschedule Automatic Updates”
Hello, is there an equivalent policy or registry key for “Reschedule Automatic Updates shcheduled installations” for Windows 10 or 11? Currently, we have no way to use group policy to schedule updates for users who missed updates, which results in PCs missing updates for several months.
We have the latest ADMX templates, and the policy is showing in the “Legacy Policies” section and only works on Windows 7 or lower.
Hello, is there an equivalent policy or registry key for “Reschedule Automatic Updates shcheduled installations” for Windows 10 or 11? Currently, we have no way to use group policy to schedule updates for users who missed updates, which results in PCs missing updates for several months.We have the latest ADMX templates, and the policy is showing in the “Legacy Policies” section and only works on Windows 7 or lower. Read More
MFA Enabled> conditional MFA policy setup > not prompting users to authenticate
I pulled a report in Entra that shows users with no MFA authentication methods setup, but we have a conditional mfa policy setup that should enforce MFA. I have worked with a user showing on the report. Their PC is joined in entra and managed Intune. I have revoked the user session reset his MFA still the user is able to sign in to his pc with his windows hello pin or his 0365 credentials without being prompted for MFA registration authentication setup…any help
I pulled a report in Entra that shows users with no MFA authentication methods setup, but we have a conditional mfa policy setup that should enforce MFA. I have worked with a user showing on the report. Their PC is joined in entra and managed Intune. I have revoked the user session reset his MFA still the user is able to sign in to his pc with his windows hello pin or his 0365 credentials without being prompted for MFA registration authentication setup…any help Read More