Hadith #4476 (Sunan Abi Dawud)
Book: Prescribed Punishments (Kitab Al-Hudud)
Narrator(s): Abdullah bin lahya'a bin 'Uqba عبد الله بن لهيعة بن عقبة الحضرمي, Abdullah bin Wahb عبد الله بن وهب بن مسلم القرشي, Haywat bin Sharih bin Safwan حيوة بن شريح بن صفوان التجيبي, Muhammad bin Abi Najiyya محمد بن أبي ناجية, Yahya bin Ayoub al-Ghafiqi يحيى بن أيوب الغافقي
Grade: Sahih

The Prophet (ﷺ) did not prescribe any punishment for drinking wine. Ibn Abbas said: A man who had drunk wine and become intoxicated was found staggering on the road, so he was taken to the Prophet (ﷺ). When he was opposite al-Abbas’s house, he escaped, and going in to al-Abbas, he grasped hold of him. When that was mentioned to the Prophet (ﷺ), he laughed and said: Did he do that? and he gave no command regarding him.
Abu Dawud said: This tradition of al-Hasan b. ‘Ali has been transmitted only by the people of Medina.

Source: https://parallelquran.com/hadith/sunan-abi-dawud-4476/