-
Export data in openoffice or excel
I try to export some needed information ( for example: memory usage ) to excel or openoffice, but I don’t find how to do that.
So I think I can do it using database in mysql – but I can’t find needed information.Can you tell me what is the best way to export some information into excel or openoffice? ( I need to make some report to my chief twice a day – so I need automatize this work).
thanks!
Pandora is very great!
Thank you for you job! -
6 Replies
-
-
-
-
[cite]Posted By: yduma[/cite]
I think I can copy/paste data that I need… or eport some data and after that change it to needed view.Can you describe how you organize data in mysql? – I think it will be usefull thing for all.( where I can find data from some agent in mysql for example).
thank’s
In version 2.0 you can export to a downloable standalone .CSV file. But it’s easy to get data from database using tagente_datos table. Just read pandora_db*.sql files and you’ll see that is a very simple database model.
If you make cool stuff , and want to share with us, you’re always welcome ! 🙂
-
SELECT AgenteId AS ‘Agente Id’, Nombre AS ‘Agente Name’, b AS ‘Alert fired’, c AS ‘Alert ceased ‘
FROM (SELECT a AS AgenteId, b, min( c ) AS ‘c’
FROM (SELECT a, if( c = ‘A’, b, NULL ) b, if( c = ‘B’, b, NULL ) c, @counter := if( c = ‘A’, @counter +1, @counter ) cnt
FROM (SELECT id_agente ‘A’, timestamp AS ‘B’,
CASE WHEN evento LIKE ‘Alert fired%’
THEN ‘A’
ELSE ‘B’
END AS ‘C’
FROM tevento
WHERE evento LIKE ‘Alert%’
)t, (SELECT @counter :=0
)t1
)t
GROUP BY cnt
)k
INNER JOIN tagente k2 ON k.AgenteId = k2.Id_agente
WHERE c IS NOT NULL
ORDER BY b DESC
