Pep Guardiola has endured more than a decade of Champions League near-misses since he last lifted the trophy.