| 19 |
|
|
| 20 |
|
public CpuUserReport(String directory, Statement stmt, String machine_name, long startDate, long endDate){ |
| 21 |
|
super (directory, stmt, machine_name, startDate, endDate); |
| 22 |
+ |
|
| 23 |
+ |
// Use this from the parameter table. |
| 24 |
|
_reportField = "packet.cpu.user"; |
| 25 |
< |
_sql = "SELECT * FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"';"; |
| 25 |
> |
|
| 26 |
> |
// Use this select query. |
| 27 |
> |
_sql = "SELECT * FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;"; |
| 28 |
> |
|
| 29 |
|
} |
| 30 |
|
|
| 31 |
|
//---PUBLIC METHODS--- |
