The stored procedure is interesting. However it does require a lot of prerequisites and open security holes that PCI-DSS would not allow (for example like distributed transaction).

Moreover, the stored procedure does not work with sp_listprocess or sp_who2 as they have duplicate column names.

Also, there needs to have the linked server set up in prerequisites (do not forget the instance name).

The stored procedure is promising but lack some improvements but I think it is a great start.