Sayyiduna Salman (may Allah be pleased with him) narrated: On the Day of Resurrection the sun will be given the heat of ten years, then it will be brought close to people's skulls - then the narrator mentioned the (rest of the) hadith - he said: Then the people will come to the Prophet (peace and blessings be upon him) and say: O Prophet of Allah! You are the one through whom Allah opened (the religion), and He has forgiven you your past and future sins, and you see the state we are in, so intercede for us with our Lord. He (peace and blessings be upon him) will say: "I am your (interceding) companion." Then he (peace and blessings be upon him) will go out, driving the people (along with him), until he reaches the gate of Paradise; he will take hold of a ring of gold on the gate and knock on the gate. It will be asked: Who is this? It will be said: Muhammad. So the gate will be opened for him (peace and blessings be upon him). He (peace and blessings be upon him) will go forward until he stands before Allah and prostrates. A call will come: Raise your head; ask and you will be given, and intercede and your intercession will be accepted. That is the Praised Station (al-Maqam al-Mahmud).
Hadith Referenceالمعجم الكبير للطبراني / باب السين / 6092