YalingZheng/xrootdreport — pull request #1 by bbockelm (2012-04-23 15:33:44+00:00)
Title: Fix timezone issues and queries

Hi Yaling,

This pull request fixes the timezone issues and a few SQL queries.

The timezone issues were due to UCSD running the report on a 24-hour period starting at 6am PST (and handling the timezone arithmetic in DST-safe manner).

The SQL queries required three fixes:
1) Only count jobs that have an exit status.
2) Only count data collected by the UCSD probe.
3) Filter on HostDescription, not SiteName.

Brian