OMS + colllectd によるバッチ実行数の取得

Perf 
| where Computer == "ubuntu"
| where CounterName contains "Batch" 
| sort by TimeGenerated asc nulls last 
| extend PrevCounterValue = prev(CounterValue, 1, 0)  
| extend PrevTimeGenerated = prev(TimeGenerated, 1, 0)
| extend TimeInterval = case(
PrevCounterValue == 0, toreal(0),
round(datetime_diff("Second", TimeGenerated, PrevTimeGenerated))
)
| extend  BRPS = case(
 TimeInterval == 0 , toreal(0),
 PrevCounterValue == 0 , toreal(0),
 CounterValue - PrevCounterValue <= 0 , toreal(0), 
 (CounterValue - PrevCounterValue)
 ) 
| extend BRPS_Interval = case(
 TimeInterval == 0 , toreal(0),
 PrevCounterValue == 0 , toreal(0),
 CounterValue - PrevCounterValue <= 0 , toreal(0), 
 (CounterValue - PrevCounterValue) / TimeInterval 
 ) 
| where TimeInterval  >= 15
| project TimeGenerated_JPN = datetime_add("Hour", 9, TimeGenerated) , BRPS_Interval, 
 Computer , TimeInterval, BRPS
| render timechart