%SYS

Just been shown this in 2008.2:

select * from %SYS.ProcessQuery

is the equivalent of D ^%SS, or

[Home] > [Processes] in the system management portal

but instead of the filters, you can do something more customised like:

select * from %SYS.ProcessQuery where ClientIPAddress IS NOT NULL