Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:mssql:mssql_basic_queries

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
dba:mssql:mssql_basic_queries [2023/08/14 16:31] – [Last hour events] dodgerdba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodger
Line 53: Line 53:
  
 <code sql> <code sql>
-select *  +SELECT 
-from  +    * 
-    sys.event_log  +FROM 
-where start_time>DateAdd(hour, -1, Convert(datetime2,SYSDATETIME()));+    sys.event_log 
 +WHERE 
 +    start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ())); 
 </code> </code>
  
Line 63: Line 66:
  
 <code sql> <code sql>
-select *  +SELECT 
-from  +    * 
-    sys.event_log  +FROM 
-where event_subtype_desc <> 'connection_successful';+    sys.event_log 
 +WHERE 
 +    event_subtype_desc <> 'connection_successful' 
 +ORDER BY 
 +    start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY;
 </code> </code>
  
  
dba/mssql/mssql_basic_queries.txt · Last modified: 2023/08/15 08:59 by dodger