Fetch events' data of sentinel incident

Atiya Sarwar 0 Reputation points
2024-03-12T08:45:40.4166667+00:00

I want to fetch event's data (under evidence) of sentinel incident but I haven't found API for it. Any other API that indirectly provides the data of events specifically the data of entities?
User's image

Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
979 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Clive Watson 5,716 Reputation points MVP
    2024-03-12T12:36:15.8833333+00:00

    Hello, The KQL you need would be this, its part of the SecurityAlert NOT the SecurityIncident - which may help you find the api?

    Specifically the value of Search_Query_Results_Overall_Count_ matches "Events"

    SecurityIncident
    | where TimeGenerated > ago(30d)
    | summarize arg_max(TimeGenerated,*) by tostring(IncidentNumber), Severity
    | extend Alerts = extract("\\[(.*?)\\]", 1, tostring(AlertIds))
    | mv-expand AlertIds to typeof(string)
    | join 
    (
        SecurityAlert
        | extend Search_Query_Results_Overall_Count_ = tostring(parse_json(ExtendedProperties).["Search Query Results Overall Count"])
        | summarize AlertCount=dcount(SystemAlertId) by SystemAlertId, Search_Query_Results_Overall_Count_
    ) on $left.AlertIds == $right.SystemAlertId
    | project IncidentNumber, AlertCount, Search_Query_Results_Overall_Count_
    

    User's image