Sample Telemetry SQL Query

The following is an example of a SQL query:
set echo on
spool telemetry_report.txt
 
COLUMN eventname FORMAT A70
 
select eventname, count(*), min(telemetry), max(telemetry), avg(telemetry), stddev(telemetry) from rx_telemetry
where
StartTimeUtc > to_date('2011/07/11 00:00', 'YYYY/MM/DD HH24:MI:SS') and
StartTimeUtc < to_date('2011/07/11 23:00', 'YYYY/MM/DD HH24:MI:SS') and
relatedactivityid is null
group by eventname order by eventname;
 
select count(*) from rx_telemetry where eventname='MSMQClientTransport.Exception';
select count(*) from rx_telemetry where eventname='MSMQServerTransport.ExceededRetryThreshold';
select count(*) from rx_telemetry where eventname='MSMQServerTransport.Retry';
select count(*) from rx_telemetry where eventname='UnhandledException';
 
select count(*) transfers from rx_telemetry where eventtype=4096;
select count(*) log_errors from rx_telemetry where eventtype=2;
select count(*) log_info from rx_telemetry where eventtype=8;
select count(*) log_warn from rx_telemetry where eventtype=4;
 
spool off
set echo off
 

--Here is an example "summary" query for SQLite:
select eventname, count(*), min(telemetry), max(telemetry), avg(telemetry) from rx_telemetry
where
StartTimeUtc > date('2011/07/11') and
StartTimeUtc < date('2011/07/11') and
relatedactivityid is null
group by eventname order by eventname;