Musnad Abu Ya'la al-Mawsili 160:92

And with his chain of narration, that the Messenger of Allah (may Allah bless him and grant him peace) said: "No one from my Ummah will endure the hardship of Medina and its severity, except that I will be an intercessor for him on the Day of Resurrection, or a witness."