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.