Differences

This shows you the differences between two versions of the page.

--- dba:mssql:mssql_basic_queries [2023/08/14 16:28] – [Event log] dodger
+++ dba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodger
@@ Line 53: / Line 53: @@
 <code sql>
-select *
+SELECT
-from sys.event_log;
+    *
+FROM
+    sys.event_log
+WHERE
+    start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ()));
 </code>
+==== Not connection succeed events ====
+<code sql>
+SELECT
+    *
+FROM
+    sys.event_log
+WHERE
+    event_subtype_desc <> 'connection_successful'
+ORDER BY
+    start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY;
+</code>