使用登录事件计算SQL Server中登录和注销时间的最小和最大值

SELECT
    MIN(event_time) AS min_login_time,
    MAX(event_time) AS max_logout_time
FROM
    sys.fn_get_audit_file('C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Security*', DEFAULT, DEFAULT);

DECLARE @min_login_time DATETIME;
DECLARE @max_logout_time DATETIME;

SELECT
    @min_login_time = MIN(event_time),
    @max_logout_time = MAX(event_time)
FROM
    sys.fn_get_audit_file('C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Security*', DEFAULT, DEFAULT);

-- 计算登录时长（分钟）
DECLARE @login_duration INT;
SET @login_duration = DATEDIFF(MINUTE, @min_login_time, @max_logout_time);

-- 查询在某个时间范围内的登录事件
SELECT
    event_time,
    event_type,
    session_server_principal_name
FROM
    sys.fn_get_audit_file('C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Security*', DEFAULT, DEFAULT)
WHERE
    event_time BETWEEN '2022-01-01' AND '2022-01-31';