Get the App
SLTechnology News&Howtos  ›  Database  › 

Obtain the user login information of a certain time period of Horizon View by querying Sql Server

Shulou Source: shulou.com Published: 2022-06-01 14:23:02 11月12日 Update

Use [Horizon_logDB] / / * Horizon_logDB is the database name of Horizon View

SELECT * from [dbo]. [event]

WHERE ModuleAndEventText LIKE'% logged in%'

And Time > '2018-12-1' and Time < '2018-12-31'

The query results are shown in the following figure

Tags: Query name data database results information time time period user login Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Shulou Tech Info Xiaomi MariaDB Apple