通过查询Sql Server获取Horizon View 某个时间段的用户登陆信息
use [Horizon_logDB] //*Horizon_logDB是Horizon View 的数据库名称
SELECT * from [dbo].[event]
WHERE ModuleAndEventText LIKE '%logged in%'
and Time > '2018-12-1' and Time < '2018-12-31'
查询结果如下图所示
use [Horizon_logDB] //*Horizon_logDB是Horizon View 的数据库名称
SELECT * from [dbo].[event]
WHERE ModuleAndEventText LIKE '%logged in%'
and Time > '2018-12-1' and Time < '2018-12-31'
查询结果如下图所示