You can start with this query: select * from vpx_entity, vpx_alarm, vpx_alarm_runtime where vpx_alarm_runtime.alarm_id = vpx_alarm.alarm_id and vpx_alarm_runtime.entity_id = vpx_entity.id;
This one shows selected fields:
select vpx_entity.name, vpx_alarm.name, vpx_alarm_runtime.metric_value, vpx_alarm_runtime.created_time from vpx_entity, vpx_alarm, vpx_alarm_runtime where vpx_alarm_runtime.alarm_id = vpx_alarm.alarm_id and vpx_alarm_runtime.entity_id = vpx_entity.id;
When you go through the import data dialog in Excel you can choose whatever you like. At the end you can edit the query the query in Microsft Query. Click on the SQL button there, delete the existing query (which reflects what you have selected in the dialog before) and enter this one or the one you would like, respectively.
Message was edited by: AWo
vExpert 2009/10/11
[:o]===[o:] [: ]o=o[ :]
= Save forests! rent firewood! =
