Common security logs data in size

Copper Contributor

Hi , would like to know if it is possible to breakdown the commonSecurityLog table that it will show the data that is ingested by Computer (ip) GB and cost ? 

1 Reply

@Guy_S_Dev1 Hi, this should get you started.


let price_ = 2.4;  // use your value here for cost per GByte 
| summarize GB = round(sum(_BilledSize)/(1024*1024*1024),2),
            estimatedPrice = round(sum(_BilledSize)/(1024*1024*1024) * price_,2)
             by Computer
| order by GB desc