Just compile the 3 scripts in the order shown. To execute the main script(sp_whom) use the following examples from SQL Server Management Studio. Three result sets will be tabs will be displayed. Drag the top one up to view results from all 3:
You can optionally pass in any or all of the 3 filters.
1) login name
2) host name
3) program name
This is designed for SQL Server 2005, 2008 and 2012 and works best with a GUI SQL tool loke SSMS or MS Visual Studio.