Nakonec se to udělalo přes powershell ..

$date_month=(get-date).adddays(-31)
$source = import-csv -Delimiter "," '.\Report.csv'
$computermonth = $source |select alertmoredetailsvalue,{[datetime]$_.alertTimevalue} | ?{$_.{[datetime]$_.alertTimevalue} -gt $date_month} | sort alertmoredetailsvalue |group AlertMoreDetailsValue |sort count -descending |select -first 10 |select name,count