22 Apr
2014
22 Apr
'14
3:29 a.m.
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.