To what extent is the story true regarding 'Umar ibn al-Khattab spying on a man who drank alcohol and listened to singing, and what events transpired between them as a result?

The aforementioned story is well-known and has been transmitted by prominent scholars in their books and in books of history and biographies, including Al-Suyuti in Jami' al-Ahadith and 'Ala' al-Din Ali al-Muttaqi in Kanz al-Ummal. No one has challenged its authenticity or confirmed its veracity.