|Using the result of a dataset in another dataset [message #742724]
||Thu, 20 October 2011 15:20
| Esteban Lus Bietti
Registered: October 2011
Hi I have a datase that retrieves a list of Servers and metrics, for example:|
agent oid id
server1 CPUUsage 14
server1 MemoryUsage 15
server2 CPUUsage 16
and then I have the information of the avg, max and min measure for each metric in another table, for example
id date avg max min
14 2011-10-19 15:00:00 5 10 2
15 2011-10-20 15:00:00 6 20 4
14 2011-10-20 15:00:00 25 50 15
and both tables are related by the id field.
I want to create one graphic por each metric, that means one graphic for server1 CPUUsage (id = 14), server1 MemoryUsage (id=15) and server2 CPUUsage (id = 16).
So on the secon dataset used for retriving the values I need in the where clause something like id = (select id from table where agent = 'server1' and oid ' 'CPUUsage')
but this two values should be replaced dinamically for each graphs with the values from the first dataset (which has all the values of the server-metric possible relations).
IS there a way to do this? I wasn´t able to find how to acomplish this, any help will be useful
Powered by FUDForum
. Page generated in 0.12335 seconds