Forum Discussion

Vshah335's avatar
Vshah335
Copper Contributor
Oct 01, 2020

Visualization Workbooks

Hey Community, 

 

On our Cloud Sentinel env,  i am trying to build workbooks, Under Visualization workbooks create two separate Incidents Column and build on Chart with that Incident.  I would like to display incident from separate work-spaces in Separate column. 

 

Query : 

SecurityIncident

| take 20 

Under Visualization DEMO  workbooks, 

On that All alerts generated on sentinel displays under output column. But we need to separate both core alert and outside org alert.  

10 Replies

  • GaryBushey's avatar
    GaryBushey
    Bronze Contributor

    Vshah335 If I understand what you are asking for, you want to be able to have one column for those incidents created by Azure Sentinel and another for those created by other Azure security products like Microsoft Cloud App Security.

     

    To do this, you need to get to the actual product creation which is hidden in the AdditionalData field and is called "alertProductNames".  For some reason this is stored as a JSON array so need to extract that value and then expand it like this:

     

    SecurityIncident
    | extend ProductName = (parse_json(AdditionalData).alertProductNames)
    | mv-expand ProductName
     
    You can then use the ProductName field to determine who generated the incident.
    • Vshah335's avatar
      Vshah335
      Copper Contributor

      Thanks Gary Bushey GaryBushey 

       

      I applied that Value under field name and it's works. 

       

      GaryBushey  Do you have workbooks visualization template(not in-build in workbooks ) ? For only for Security Incident query. Just want to explore my self into it. 

       

       

Resources