How do I find all work items with a failed sync?

Use JQL:

SQL

sbHasFailure = "true"

Or open Sync history on the admin page and filter by status.

See also: Search Synced Work Items with JQL, Sync History