[SOLVED]combining records
Posted: Mon Sep 25, 2006 1:57 am
hello
i have a database wich get the load percentage of the various servers i have.
and this shows me how much work the servers have.
now for the problem: this database is updated every 5 min and the results are placed in a graph (using JPgraph)
but i want every point in the graph to be an update of the last half hour.
example:
this is the record set

and this is the graph

i want the graph to show the highest value for every half hour. without changing the database
(because i might want that info for something else). i think this could be done best with a new query.
btw sr0029 is a name usually filled in by a variable in another page
this is the current one:
EDIT:
oh and i also want the lastcheck of the highest loadpercentage to show but i will figure that out later
i have a database wich get the load percentage of the various servers i have.
and this shows me how much work the servers have.
now for the problem: this database is updated every 5 min and the results are placed in a graph (using JPgraph)
but i want every point in the graph to be an update of the last half hour.
example:
this is the record set

and this is the graph

i want the graph to show the highest value for every half hour. without changing the database
(because i might want that info for something else). i think this could be done best with a new query.
btw sr0029 is a name usually filled in by a variable in another page
this is the current one:
Code: Select all
SELECT TOP 30 LoadPercentage, LastCheck, ServerName
FROM Gispen_Server_CPU_gebruik
WHERE (ServerName LIKE 'sr0029')
ORDER BY LastCheck DESCoh and i also want the lastcheck of the highest loadpercentage to show but i will figure that out later