How to: Export AD Connect sync errors to a CSV file

You look into the export errors of an connector in AD connect, found 100+ sync related errors and want these export errors into a CSV file.

Fix: SSPR failure reason OnPremisesAdminActionRequired

When an onpremis user in your environment cannot change his password and you see in the SSPR audit logs OnPremisesAdminActionRequired or ADAdminActionRequired as failure