How to script nagios csv export

csvexportnagios

nagios 3 can export availability data as csv (clicking through the web gui). Now I would like to do that automated and on a regular basis, so I am looking for a way to set all the parameters (e.g. reporting period) and then get the csv. Since the parameters seem not encoded in the url, I do not see an obvious solution.

Can this be scripted? If yes, how? Or do I need to do screen scraping?

Best Answer

You could script this with your favorite language (perl, python, etc.) or use curl/wget. All of the CGIs can be run from the command line as well, but you'll have to set the REMOTE_USER env variable.

The params are absolutely encoded in the URL, but the stock Nagios web interface uses frames, so you don't see them. View the actual frame that the report is in, and you'll see the GET params.

You can also use a browser add-on like Live HTTP Headers (for Firefox) to show you exactly what is being requested. For example:

GET /cgi-bin/nagios3/avail.cgi?show_log_entries=&host=all&service=all&timeperiod=last7days&smon=11&sday=1&syear=2013&shour=0&smin=0&ssec=0&emon=11&eday=25&eyear=2013&ehour=24&emin=0&esec=0&rpttimeperiod=&assumeinitialstates=yes&assumestateretention=yes&assumestatesduringnotrunning=yes&includesoftstates=no&initialassumedservicestate=0&backtrack=4&csvoutput=

Related Solutions

Sql-server – export proper csv from SqlServer management studio query result

See Options > Query Results > SQL Server > Results to Text

Check "include column headers". My text results are being enclosed in doublequotes so that should take care of the comma issue. Take a look at the "Results to grid" tab as well - I see a "Quote strings containing list separators when saving .csv results"

If not through SSMS then you can also use the sqlcmd command line utility which includes more options than the powershell equivalent.

Sql-server – MS SQL Server 2008: How to export all the tables into CSV

A more robust solution is to use the Oracle Migration Workbench. This used to be a separate utility from Oracle, but is now included in Oracle SQL Developer . If you and CLOB/BLOB data types then this is the way to go. You should also read the Oracle documentation on how to migrate as the SQL Developer migration interface is not very intuitive.

If you do want to go down the road of exporting all tables to csv you can use BCP or SSIS. There is a very good article on simple-talk on using some t-sql and to generate bcp export commands for all tables in a database. You can also create simple SSIS package to export all the tables to csv by using a flat file destination task.

here's something quick & dirty that will generate the BCP commands for you. Run it in SSMS, the run the output at the command prompt.

            USE AdventureWorks
SELECT 'bcp ' +
            QUOTENAME(DB_NAME())
            + '.'
            +QUOTENAME(SCHEMA_NAME(schema_id))
            + '.'
            +QUOTENAME(name)
            + ' '+'out'+' '
            + name + '.csv -w -t"|" -E -S '
            + @@servername
            + ' -T'
    FROM sys.objects
    WHERE TYPE='u'
        AND is_ms_shipped=0

Best Answer

Related Solutions

Sql-server – export proper csv from SqlServer management studio query result

Sql-server – MS SQL Server 2008: How to export all the tables into CSV

Related Topic