select hostname as '客户端', User_Code As 'B1用户代码',U_Name as 'B1用户名' ,
nt_domain as Domain, nt_username as 'Window用户',
loginame as '数据库用户',login_time as '登录时间', last_batch as '上次操作时间',
DATEDIFF(minute, last_batch , GetDate()) as '空闲时间(分)'
from master.dbo.sysprocesses left outer join SBODemoUS.dbo.OUSR
on hostname collate SQL_Latin1_General_CP850_CI_AS = U_ClientMch collate SQL_Latin1_General_CP850_CI_AS
where spid >=0 and spid <= 32767 and program_name = 'SAP Business One' and db_name(dbid)='SBODemoUS'