Select Count(HostName) from (SELECT Hostname, Program_name, hostprocess as HostProcessID, COUNT(spid) AS NoConnections FROM  master.dbo.sysprocesses (nolock) GROUP BY hostname, program_name, hostprocess HAVING (program_name = N'Desktop - Keyhouse')) X
go 
Select HostName from (SELECT Hostname, Program_name, hostprocess as HostProcessID, COUNT(spid) AS NoConnections FROM  master.dbo.sysprocesses (nolock) GROUP BY hostname, program_name, hostprocess HAVING (program_name = N'Desktop - Keyhouse')) X
go 
SELECT Hostname, Program_name, hostprocess as HostProcessID, COUNT(spid) AS NoConnections FROM  master.dbo.sysprocesses (nolock) GROUP BY hostname, program_name, hostprocess HAVING (program_name = N'Desktop - Keyhouse')





Select * from (SELECT Hostname, Program_name, hostprocess as HostProcessID, COUNT(spid) AS NoConnections FROM  master.dbo.sysprocesses (nolock) GROUP BY hostname, program_name, hostprocess HAVING (program_name = N'Desktop - Keyhouse')) X