Kevin Oppihle's Tech Notes

 Windows update Stuck at 8% for Windows 11 Upgrade While trying to upgrade a patched Windows 10 workstation from Windows update the downloader kept stopping at 8% Since that was failing. I tried the Windows 11Installation Assistant https://www.microsoft.com/en-us/software-download/windows11? However that interface would download and appear to get near the end of install then fail with an alert about unable to upgrade due to Windows Update. I stopped the Windows update services and same issue. I attempted to use Dell provided recovery USB Media and that was failing too. I returned to Microsoft's site and used a 16GB flash drive and used the Create Windows installation Media downloader. https://www.microsoft.com/en-us/software-download/windows11? I selected the USB option and after the download completed I ran Setup.exe from the flash drive. It then completed the upgrade and retained the Windows 10 settings and data.

Open Powershell as an Administrator and process the following to connect to your 365 tenant: $UserCredential = Get-Credential Enter in 365 admin and credentials when prompted  $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic –AllowRedirection Import-PSSession $Session Export command 365: Get-Mailbox | Select Name, PrimarySMTPAddress, legacyExchangeDN | Export-Csv C:\Source\Address\X500.csv -NoTypeInformation   Output will look similar to this: With this output you can then modify as necessary for import into another AD or 365 tenant if doing a  tenant to tenant or other email migration and reduce unnecessary non-delivery errors.

If a user attempts to run a report and receives the following in a SQL base application. You may need to add the user to SSRS 2019   Unexpected Error The request failed with the HTTP status 401:Unauthorized or  Unexpected Error The permissions granted to user 'username' are insufficient for performing this operation (rsAccessDenied) To add a user or group to a system role: Start the web portal. Select the Gear icon in the upper right and then select Site Settings from the dropdown menu. Select Security. Select Add group or user. In Group or user, enter a Windows domain user or group account in this format: <domain>\<account>. Then to give the users access to SSRS reports? Click Home Folder settings Create a new role assignment so that you can grant access to the “Content Manager” role. (that will grant access so that the user can edit or build reports) Note: You can give them additional permissions in SSRS, such as the Report Builder permission to the Home fol...

Here is an older article on SPF Basics https://koppihle3.blogspot.com/2016/04/dns-spf-basics-what-you-need-to-know-to.html  to add to that... While you can only have ONE official SPF record for your domain, If your domain requires more include statements than you can fit on one SPF record (limit should be10).  It is DNS acceptable to create references to additional txt records that can include other SPF references but it is important to end all of them with a ~all. This is a common issue if you have several marketing or other services sending email for your domain or a monster domain such as Microsoft.com .  Note: Subdomains are handled separately and can have their own official SPF record. for Example for Microsoft using MXtoolbox.com to lookup the data: References include statements to other records:  So Rules are still. Put SPF records in priority access for example if your email primarily comes from proofpoint, put that first then any third party references such ...

If you are using a local account rather than having MS created one from the wizard for better auditing and control. You may have to make some AD permissions changes via powershell. If you are seeing the following Export Errors: Caution- you are modifying AD permissions to grant an account high level access. Do not use a regular user/admin account! Security best practices requires creating a separate  service account that can be used exclusively for this process to allow proper auditing trail and security.  I have found the following 3 commands give permissions needed to access the attributes: $accountName = " Domain-Name \ User-Name " $ForestDN = "DC= Domain-Name ,DC= Domain-Extension " $cmd = "dsacls '$ForestDN' /I:S /G '`"$accountName`":WP;ms-ds-consistencyGuid;user'" Invoke-Expression $cmd accountName = " Domain-Name \ User-Name " $ForestDN = "DC= Domain-Name ,DC= Domain-Extension " $cmd = "d sacls ...