Hadithcore
Mishkat al-Masabih, 2730

Abu Huraira reported God's messenger as saying, "No one from among my people will endure the hardship and rigour of Medina without my being an intercessor on his behalf on the day of resurrection." Muslim transmitted it.

وَعَنْ أَبِي هُرَيْرَةَ أَنَّ رَسُولَ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ قَالَ: «لَا يَصْبِرُ عَلَى لَأْوَاءِ الْمَدِينَةِ وَشِدَّتِهَا أَحَدٌ مِنْ أُمَّتِي إِلَّا كُنْتُ لَهُ شَفِيعًا يَوْمَ الْقِيَامَةِ» . رَوَاهُ مُسْلِمٌ

References1 variant
In-Book Reference
Book 10, Hadith 219