Azure devops agent No usable version of libssl was found

Azure devops pipeline agent fails at the personal access token step: with this error:

No usable version of libssl was found

Looks like the following threads have also reported the same:

https://github.com/microsoft/azure-pipelines-agent/issues/3834

https://github.com/microsoft/azure-pipelines-agent/issues/3922

Dotnet6 migration

Solution is to wait until MS ships the latest version of their agent built with .NET 6.0 version which officially supports the Open SSL 3 version.