RecipientEmailAddress but recipient information BEFORE DL expansion
I'm trying to get a list of the top email recipients in our environment using the EmailEvents table andRecipientEmailAddress in Defender 365/Sentinel. But, as the schema says, RecipientEmailAddress is the "address of the recipient, or email address of the recipient after distribution list expansion" How can I query on recipient info before DL expansion?
How to use xlookup with condition for sharepoint list
I have an Excel file that I would like to import into a SharePoint list. Each column in the Excel file contains formulas, and it appears that XLOOKUP is used in some of them. I would appreciate assistance in accomplishing this task. My proficiency in English is limited, so if anyone has the time, please feel free to contact me via WhatsApp or use Microsoft Teams for a video call to provide me with instructions.Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be onWednesday 6 Sept 2023starting at18:00 UK time (6PM UTC+1)and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please checkhttps://www.worldtimebuddy.com/ In this month's session, I will be demonstrating my newDatabase Analyzer Proapplication. The free evaluation version is now available for download from the above link on my website If time permits, I will also be discussing a number of related Access examples and code samples such as: • the use of progress bars • creating a table of contents in Access reports • the undocumented SaveAsText/LoadFromText features • changing query views using command bars code For more details about this session, see:https://accessusergroups.org/europe/event/access-europe-2023-09-06/orhttps://isladogs.co.uk/aeu-19/ The meeting will again be held onZoom. When the time comes, you can connect using:Join Zoom Meeting. If you are asked, use:Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see theAccessUserGroups.orgweb page for this event All sessions are recorded and later uploaded to theAccess User Groupschannel onYouTube I hope you will join us for this month's session. As always, the session will be recorded and the video uploaded toYouTubeafter the event NOTE: I regret that the planned presentation on Better Access Charts by Thomas Moller originally scheduled for Wed 6 Sept has been postponed until further notice.
Windows 11 ARM Microsoft 365 broken login - Outlook "unable to connect right now"
Hi all, HNY Came back from holiday to see that my Company Policy required to change my AD password as 4 months had passed. Did that on a Win 11 PC, no problems. Outlook showed 'trying to connect...' and 'Need Password', which when clicked opened the Microsoft 365 login page requesting the updated password etc. Moving to my Win 11 ARM machine (build 25267.1000) and opening up Outlook, I immediately get a pop up saying "we are unable to connect right now". Clicking the 'Need Password' opens up the same dialog again. I have tried to create a new profile using Control Panel->Mail, but the Add new account is again unable to Connect to the Mail server. My other Windows 11 PC Laptops work as expected from the same connection, so it is not a network issue. Has anyone else noticed the latest Dev build breaking the Microsoft 365 login process? Have tried downgrading Office 365 two builds to see if that was the problem, but it is not. Thanks!Working with multiple work accounts on a windows 10 device
Hello everyone I think it's time for me to vent my frustration about working with multiple work/education accounts on a windows 10 device... First of all, I have 3 Microsoft Accounts (1x Personal; 1x Work; 1x Education) and oh boy, it's very very frustrating to get all these 3 Accounts work together on the same windows 10 device with one Userprofile. Working with my Personal and Work (or Education) account on the same device works fine, no problems, but as soon as I add additionally either my Work or Education Account in the Windows 10 settings under "Account > Email & accounts" things starting to get complicated. Sync issues across every app that uses one of these work/education accounts (classic Office Apps, ToDo, Edge, OneNote) Upload blocks in the office apps (Word, Excel...) & Credential Errors 4x/day a notification toast that my work accounts need to fix... blabla -> I click okay, now fix it -> Accounts fixed -> later in the day, same error occurs... I just want to use all my accounts on the same device with the same Userprofile, I really love the Microsoft 365 Platform but these things driving me crazy. I had a time, in there I worked completely online, but yeah, we all know how cool it is to work with the online versions of Office Apps. I also tried multi-bootable windows installations or multiple Userprofiles and it worked, but I often need to access files/services that are stored in the OneDrive from my Education Account or vise versa, so it's really impracticable. Then I tried to link my accounts just in these apps where I need it, but Windows 10 really have fun on it to write in my accounts under the named windows 10 settings location. Has anyone a best practice, tips/tricks etc. everything helps... Thanks.Blogpost - Get-MailDomainInfo function for retrieving all email DNS records
Wrote a blogpost about it, but this is the Function I made to get all the email dns records in a convenientway. (Saves time querying mxtoolbox.com 😉 ) function Get-MailDomainInfo { param( [parameter(Mandatory = $true)][string]$DomainName, [parameter(Mandatory = $false)][string]$DNSserver ) #Use DNS server 1.1.1.1 when parameter DNSserver is not used if (-not ($DNSserver)) { $DNSserver = '1.1.1.1' } #Retrieve all mail DNS records $autodiscoverA = (Resolve-DnsName -Name "autodiscover.$($domainname)" -Type A -Server $DNSserver -ErrorAction SilentlyContinue).IPAddress $autodiscoverCNAME = (Resolve-DnsName -Name "autodiscover.$($domainname)" -Type CNAME -Server $DNSserver -ErrorAction SilentlyContinue).NameHost $dkim1 = Resolve-DnsName -Name "selector1._domainkey.$($domainname)" -Type CNAME -Server $DNSserver -ErrorAction SilentlyContinue $dkim2 = Resolve-DnsName -Name "selector2._domainkey.$($domainname)" -Type CNAME -Server $DNSserver -ErrorAction SilentlyContinue $domain = Resolve-DnsName -Name $DomainName -Server $DNSserver -ErrorAction SilentlyContinue $dmarc = (Resolve-DnsName -Name "_dmarc.$($DomainName)" -Type TXT -Server $DNSserver -ErrorAction SilentlyContinue).Strings $mx = (Resolve-DnsName -Name $DomainName -Type MX -Server $DNSserver -ErrorAction SilentlyContinue).NameExchange $spf = (Resolve-DnsName -Name $DomainName -Type TXT -Server $DNSserver -ErrorAction SilentlyContinue | Where-Object Strings -Match 'v=spf').Strings #Set variables to Not enabled or found if they can't be retrieved #and stop script if domainname is not valid $errorfinding = 'Not enabled' if ($null -eq $domain) { Write-Warning ("{0} not found" -f $DomainName) return } if ($null -eq $dkim1 -and $null -eq $dkim2) { $dkim = $errorfinding } else { $dkim = "$($dkim1.Name) , $($dkim2.Name)" } if ($null -eq $dmarc) { $dmarc = $errorfinding } if ($null -eq $mx) { $mx = $errorfinding } if ($null -eq $spf) { $spf = $errorfinding } if (($autodiscoverA).count -gt 1) { $autodiscoverA = $errorfinding } if ($null -eq $autodiscoverCNAME) { $autodiscoverCNAME = $errorfinding } $info = [PSCustomObject]@{ 'Domain Name' = $DomainName 'Autodiscover IP-Address' = $autodiscoverA 'Autodiscover CNAME ' = $autodiscoverCNAME 'DKIM Record' = $dkim 'DMARC Record' = "$($dmarc)" 'MX Record(s)' = $mx -join ', ' 'SPF Record' = "$($spf)" } return $info } (https://powershellisfun.com)Outlook Group Calendars - The operation failed. An object could not be found
Hello everyone, We have an issue where a user can't use any of it's M365 group calendars in the Outlook client (for Windows) anymore. Once a new item should be created, we receive the error message from the screenshot below. The permissions are all fine, since on OWA the calendars are fully functional. What we did so far: - Recreate the mail profile in the control center - Reinstall whole Office suite (includes Outlook) - Upgrade Office suite from 32 to 64 bit Finally the mentioned error message (unfortunately in german), but I think the english translation would be "The operation failed. An object could not be found.": Maybe someone has an idea how to solve this issue? Thank you!
People Webpart doesn't show the pictures
Hello guys, I want to ask you something, I have a SharePoint site integrated with my 365 platform. In the site I use the Webpart People to add new hires, I mean, it's like a Welcome aboard.. In the user profile in 365 platform, I add the user's picture but in the WebPart the picture is not shown. There seems to be a synchronization problem. Do you have any idea how to solve it? Thanks in advance,
