Forum Discussion

Thomas Cox's avatar
Thomas Cox
Copper Contributor
Mar 01, 2023
Solved

Microsoft Sentinel - See collected Event IDs per Computer

Hey! 

 

Whilst the Common Security Events (via AMA) collects a set number of Windows Security Event IDs: 

Windows security event sets that can be sent to Microsoft Sentinel | Microsoft Learn

 

Is there a way to see which computers are sending which event IDs as part of a wider SecurityEvents query? It's easy enough to pull back Event IDs being collected: 

 

SecurityEvent
| summarize count() by Activity

 

Any pointers would be appreciated! 

  • Thomas Cox 

     

    An alternative method

    SecurityEvent
    | summarize count_=dcount(EventID), Ids_=make_set(EventID) by Computer

     

     

  • Thomas Cox's avatar
    Thomas Cox
    Copper Contributor
    This might be the answer:

    Security Event
    | distinct Computer, EventID

    • Clive_Watson's avatar
      Clive_Watson
      Bronze Contributor

      Thomas Cox 

       

      An alternative method

      SecurityEvent
      | summarize count_=dcount(EventID), Ids_=make_set(EventID) by Computer

       

       

      • Thomas Cox's avatar
        Thomas Cox
        Copper Contributor
        That is much neater than having to stitch the data together! Thank you.

Resources