Pandora FMS Community

Export data in openoffice or excel

yduma · 17 jun 2008, 19:45 · 7 mensajes · 93 visitas

  1. Inicio del debate

    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!

  2. You might want to take a look at "Export data" menu in the webconsole, maybe it'll do the trick Cheers!

  3. 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

  4. The database schema is in the pandora_console directory you can take a look at it if needed.

  5. [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 ! :-)

  6. 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

  7. Hi yduma! What's that for?

Entra en tu cuenta para publicar.