SOLVED

Timestamps in AlertTable

%3CLINGO-SUB%20id%3D%22lingo-sub-1570831%22%20slang%3D%22en-US%22%3ETimestamps%20in%20AlertTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570831%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Sentinel%20Alert%20table%2C%20there%20are%20StartTime%2C%20EndTime%2C%20ProcessingEndTime.%20What%20do%20these%20refer%20to%20%3F%3C%2FP%3E%3CP%3ELooking%20into%20sample%20alerts%2C%20in%20many%20cases%20StartTime%20and%20Endtime%20seem%20to%20correpsond%20to%20%22set%20query_datetimescope_from%22%20%22set%20query_datetimescope_to%20%22%20respectively%20which%20makes%20sense%2C%20but%20in%20other%20cases%20they%20don't%20map.%20The%20ProcessingEndTime%20seems%20to%20map%20to%20the%20end%20of%20LA%20rule%20execution%20time%20(i.e.%20after%20it%20starts%20running)%2C%20any%20confirmation%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22majo01_0-1596726628364.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210642iD100B48EFAABECD6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22majo01_0-1596726628364.png%22%20alt%3D%22majo01_0-1596726628364.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576387%22%20slang%3D%22en-US%22%3ERe%3A%20Timestamps%20in%20AlertTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576387%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F540154%22%20target%3D%22_blank%22%3E%40majo01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETimestamps%20behave%20differently%20depending%20on%20the%20relevant%20alert%20provider%20and%20specific%20alert.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20alerts%20that%20aren%E2%80%99t%20Sentinel%20scheduled%20alerts%20the%20alert%20provider%20determines%20the%20start%20time%2C%20end%20time%20and%20processing%20time%20of%20the%20alert.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20scheduled%20alerts%20it%20depends%20whether%20the%20query%20results%20contain%20the%20TimeGenerated%20of%20the%20events%20or%20not%20%E2%80%93%20if%20it%20does%20then%20the%20start%20and%20end%20times%20of%20the%20alert%20will%20be%20determined%20based%20on%20the%20earliest%20and%20last%20events%2C%20if%20it%20doesn%E2%80%99t%20they%20will%20be%20based%20on%20the%20time%20period%20that%20was%20queried%20to%20create%20the%20alert.%20TimeGeneraged%20and%20ProcessingEndTime%20are%20identical%20and%20refer%20to%20the%26nbsp%3B%3CSPAN%3Etime%20in%20which%20the%20query%20ran%20and%20the%20alert%20was%20created.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

In Sentinel Alert table, there are StartTime, EndTime, ProcessingEndTime. What do these refer to ?

Looking into sample alerts, in many cases StartTime and Endtime seem to correpsond to "set query_datetimescope_from" "set query_datetimescope_to " respectively which makes sense, but in other cases they don't map. The ProcessingEndTime seems to map to the end of LA rule execution time (i.e. after it starts running), any confirmation ?

 

majo01_0-1596726628364.png

 

1 Reply
best response confirmed by majo01 (Occasional Contributor)
Solution

@majo01 

 

Timestamps behave differently depending on the relevant alert provider and specific alert.

 

For alerts that aren’t Sentinel scheduled alerts the alert provider determines the start time, end time and processing time of the alert. 

 

For scheduled alerts it depends whether the query results contain the TimeGenerated of the events or not – if it does then the start and end times of the alert will be determined based on the earliest and last events, if it doesn’t they will be based on the time period that was queried to create the alert. TimeGeneraged and ProcessingEndTime are identical and refer to the time in which the query ran and the alert was created.