新院址运行统计-优快云博客

本文提供了上周项目的活动统计数据，包括电脑端和手机端的登录次数，以及项目中提出的问题数量。通过对这些数据进行分析，可以了解用户的活跃度及项目管理情况。

---上周电脑端登陆次数统计
  select a.ExTitle as 'user',COUNT(*) as 'count' from [BIMPM_Base].[dbo].[ApplicationLog] as a join [BIMPM_Base].[dbo].[ProjectAttendUser] as b 
  on a.ExTitle = b.UserName 
  where a.OperateCategory = 1 and ExMessage = '' and b.ProjectRowGuid = '8567b6bc-27e9-4128-b5d9-1b5f20bbcf78' and 
  a.OperateDate > '2018-7-29' and a.OperateDate< '2018-8-6'
  group by a.ExTitle
  
  ---上周手机端登陆次数统计
  select a.ExTitle as 'user',COUNT(*) as 'count' from [BIMPM_Base].[dbo].[ApplicationLog] as a join [BIMPM_Base].[dbo].[ProjectAttendUser] as b 
  on a.ExTitle = b.UserName 
  where a.OperateCategory = 1 and ExMessage = '手机端快速登陆' and b.ProjectRowGuid = '8567b6bc-27e9-4128-b5d9-1b5f20bbcf78' and 
  a.OperateDate > '2018-7-29' and a.OperateDate< '2018-8-6'
  group by a.ExTitle
  
  ---上周问题数量统计
  SELECT a.CreateUserName as 'user',COUNT(*) as 'count'
  FROM [BIMPM_RoadBridge].[dbo].[ProjectProblem] as a 
  where a.ProjectRowGuid = '8567b6bc-27e9-4128-b5d9-1b5f20bbcf78' and a.CreationDate > '2018-7-29' and a.CreationDate< '2018-8-6'
  group by a.CreateUserName

转载于:https://www.cnblogs.com/wangzuofei/p/9428692.html