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!
Export data in openoffice or excel
yduma · 17 jun 2008, 19:45 · 7 mensajes · 93 visitas
- Inicio del debate
You might want to take a look at "Export data" menu in the webconsole, maybe it'll do the trick Cheers!
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
The database schema is in the pandora_console directory you can take a look at it if needed.
[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
Hi yduma! What's that for?
Entra en tu cuenta para publicar.
