I would like to create a report (if it does not already exist) that calculates red/green time for a given service for a given date range for ALL client machines configured. Or possibly a subset of clients if that is also doable. This is for an end-of-month type report. Percentages as well as total times would be great.

For example.

Service = conn Start = 4/1/14 00:00:00 End = 4/30/14 23:59:59

Output would be: Client1 Green: 0/0% Red: 43200/100% Client2 Green: 21600/50% Red: 21600/50% Clent3 Green: 42200/97.685% Red: 1000/2.315% .... Total Green: xxxxx/xx.xxx% Red: yyyyy/yy.yyy%

Is this type of report (easily) doable?

Any pointers on the best way to so such a report would be appreciated.