It is narrated from Sayyiduna Abd al-Rahman bin Abi Aqil al-Thaqafi (may Allah be pleased with him) that I set out with the delegation of the tribe of Thaqif. We came into the blessed presence of the Messenger of Allah (peace and blessings be upon him) and stayed at his door. (Our state at that time was such that) among all people there was no one more hateful to us than this man (the Prophet (peace and blessings be upon him)) whose presence we were about to enter; but when we left, that very personality whom we had visited had become the most beloved to us of all the people in the world. Then one of us said: "O Messenger of Allah, did you not ask your Lord for a magnificent kingdom like that of Sayyiduna Sulayman bin Dawud (peace be upon them both)?" On hearing this the Prophet (peace and blessings be upon him) smiled and then said: "Perhaps your companion has with Allah Almighty a rank far more excellent than the kingdom of Sulayman. The truth is that whenever Allah Almighty sent any prophet, He granted him one supplication (with a special right of acceptance) that does not go to waste. Some of those prophets asked for worldly things with it and were given them, and some invoked it against their people when they disobeyed them, and they were destroyed because of it. And Allah, the Mighty and Majestic, has granted me such a supplication too, which I have saved (and kept in reserve) as intercession for my Ummah before my Lord on the Day of Resurrection."
Imam al-Harith transmitted something similar through Abd al-Aziz bin Aban, Abd al-Jabbar bin Abbas al-Shibami and Awn bin Abi Juhayfah.
Imam Abu Ya'la mentioned it through the route of Zuhayr and Ahmad bin Abdullah bin Yunus.
Imam al-Bazzar narrated it on the authority of Abbas bin Abi Talib and Ahmad bin Abdullah, and he said: To our knowledge Ibn Abi Aqil has no other narration besides this.
Hadith Referenceالمطالب العالية بزوائد المسانيد الثمانية / كتاب الفتوح / 4574
Hadith Gradingمحدثین:إسناده ضعيف
Hadith Takhrij«حکم الحدیث المطالب العالیہ محققاً تنسیق د. سعد بن ناصر بن عبد العزيز الشَّثري- مکتبہ شاملہ :إسناده ضعيف » «أخرجه مصنف ابن أبي شيبة برقم: 102، وأخرجه المستدرك على الصحيحين برقم: 234، وأخرجه مجمع الزوائد ومنبع الفوائد برقم: 18497، وأخرجه شرح مشكل الآثار برقم: 3967، وأخرجه إتحاف الخيرة المهرة بزوائد المسانيد العشرة برقم: 7762»