Mishkat al-Masabih
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.
وَعَنْ أَبِي هُرَيْرَةَ أَنَّ رَسُولَ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ قَالَ: «لَا يَصْبِرُ عَلَى لَأْوَاءِ الْمَدِينَةِ وَشِدَّتِهَا أَحَدٌ مِنْ أُمَّتِي إِلَّا كُنْتُ لَهُ شَفِيعًا يَوْمَ الْقِيَامَةِ» . رَوَاهُ مُسْلِمٌ
Reference