Printer driver requires admin, you are logged in as a user

Launching add printer as an admin in Windows 11 is a pain.

Save the following in a bat file and run as admin.

rundll32 printui.dll,PrintUIEntry /il

365 Online Archive Not Archiving

You've enabled Online Archiving for a 365 user and a few days go by and the user complains of a lack of space. This can be solved by manually starting the archiving process in PowerShell, this process is normally on a weekly schedule.

In PowerShell run: Connect-ExchangeOnline

Once logged in run: Start-ManagedFolderAssistant -Identity "user@domain.com"

If you don't have the Connect-ExchangeOnline command run the following in admin PowerShell. I usually have this in a connection script so the module stays up to date.

Install-Module -Name ExchangeOnlineManagement
Update-Module -Name ExchangeOnlineManagement
Import-Module ExchangeOnlineManagement; Get-Module ExchangeOnlineManagement
Connect-ExchangeOnline -ShowProgress $true

Publish Control Panel Email Settings in RDS

 You need to publish the following: c:\Windows\SysWOW64\control.exe mlcfg32.cpl

To do this in the Publish Applications wizard browse to Control.exe at the location shown above, and publish that, then go back in to the published app settings and modify;

1. General: Rename it to Email Settings.
2. Parameters: Select 'Always use the following command-line parameters' and enter this in the box: mlcfg32.cpl

Click OK and refresh RDWeb, you will see the new RemoteApp.

Tapo app keeps saying, You have viewed the live video for 5 minutes without any operation. Continue the viewing?

If you are getting the popup "You have viewed the live video for 5 minutes without any operation. Continue the viewing?" in the Tapo app you need to change some settings.

In the settings for the app.
Turn on "Allow background usage", "Allow background data usage", Some versions of android have a setting for battery usage set this to "Unrestricted" for the Tapo app.

Different versions of Android call this different things, but the app being restricted is what causes the problem so just have a look through the settings in the "App info" option..

Set Windows user not to expire via CMD

 To set a local Windows user password not to expire use the following.

wmic UserAccount where Name='username' set PasswordExpires=False

Produce a last logon report on Active Directory

The following PowerShell command will produce a csv file with username, last login date and time, and 'user enabled' columns. 

Get-LocalUser | Select-Object Name, LastLogon, Enabled | Export-Csv -Path "C:\path\to\your\LastLogonReport.csv" -NoTypeInformation

 

Install Hyper-V PowerShell module without Hyper-V role

In an elevated PowerShell prompt.

Install-WindowsFeature rsat-hyper-v-tools

Find an Outlook folder using PowerShell

Connect-ExchangeOnline -ShowProgress $true

Enter your login details.

Get-MailboxFolderstatistics -Identity username@example.com | Where {$_.Name -Match "Missing Folder Name"}

The output will show the folder path!

Close the session with:  Disconnect-ExchangeOnline

Possible fix (works but for how long) Outlook 2016 on RDS 2019 Gives Error 'Cannot start Microsoft Outlook. The set of folders cannot be opened'

 

Outlook 2016 on RDS 2019 Gives Error 'Cannot start Microsoft Outlook. The set of folders cannot be opened'

On the problem computer, create the registry key for the affected user: Computer\HKEY_USERS\USERSID\Software\Microsoft\Office\16.0\Outlook\AutoDiscover

Name: ExcludeScpLookup
Type: REG_DWORD
Data:1

Rename the Outlook Folder c:\users%username%\AppData\Local\Microsoft\Outlook

Delete profile keys from Computer\HKEY_USERS\USERSID\Software\Microsoft\Office\16.0\Outlook\Profiles

Reverse block of Windows 10 upgrade to Windows 11

On a PC that has been blocked from upgrading to Windows 11 you will see registry keys as below with similar values within: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate

To unblock the upgrade, you need to delete TargetReleaseVersion, leave ProductVersion as it is.

Untested: I don't think the TargetReleaseVersionInfo value matters once TargetReleaseVersion is disabled.

Adding SQL Permissions to Certificates in Windows

 Faced with these certificate permissions how do you add the last two?

The correct syntax is to add each of these.

NT SERVICE\MSSQLSERVER
NT SERVICE\SQLSERVERAGENT

Jet Reports Jet Service Tier Error

 Jet Service Tier Error

The SSL certificate could not be validated. The following error was received.

Could not establish trust relationship for the SSL/TLS secure channel with authority 'host.example.com:7090'.

I tried using the Jet Services Administration Shell, this ran and immediately closed the PowerShell window, I found the script was missing that the shortcut calls.

1. I checked for a binding using netsh: netsh http show sslcert
2. I removed the binding: netsh http delete sslcert ipport=0.0.0.0:7090
3. I added the new binding using the appid from step one: netsh http add sslcert ipport=0.0.0.0:7090 certhash=my-cert-hash appid={appid from step 1}

I was then able to open Jet Administration Console and connect.