sumologic-labs / sumo-report-generator Goto Github PK

It would be nice to be able to build a report template. A workbook with perhaps additional columns/formulas/conditional formatting that I could use to generate my report from.

Hello,

First of all, thank you for a great tool. I have a few requests/new features.

1. Allow results of multiple queries to be written in a single spreadsheet without having to create multiple JSON source files. A single JSON file with multiple queries and not creating multiple sheets would be great.
2. In case of multiple JSON file, please allow command line parameters to be passed to it. This avoids us to making changes to all the files (like from_date/to_date) whenever we have to run them.
3. Allow different column names for different query results in a single spreadsheet. Right now, if the column names do not match or if number of columns for each query is different, the execution throws and exception.

Thanks once again.

Thanks
Krishna

Right now we can only export record level data, so you have to have an aggregate. Would be nice to have the option to export message level data.

INFO 2015-10-02 06:37:53 SumoDataServiceImpl - executing search job: SearchJob{query='_view=customer_ingest_hourly orgid="${org_id}"| timeslice by 1d | sum(gbytes) as gb_ingested by _timeslice, orgid| fields orgid, _timeslice, gb_ingested| order by _timeslice desc', from=${from_date}, to=${to_date}, timezone='PST'}

It would be nice to not have numeric cells show up as text. let's make this possible.

If you run 10 queries, and #10 fails, the workbook will be generated along with named tabs but no data exists. Would it be possible to save the data after each query completes?

This would allow us to print out the job name when running multiple instances of Sumo Report Gen:

Currently:

INFO 2015-12-01 12:25:04 SumoDataServiceImpl - checking search job status

INFO 2015-12-01 12:25:04 Checking search job status for KeithInc

test

It would be useful to print out the total time taken so that we can easily record how long it's taking to run similar jobs at different times or with different customers.

All numbers that are downloaded in the xlsx are stored as text.

It would be great to be able to specify -14d as the default timestamp. It should be supported by Sumo- perhaps I should try it first.. :-)

This would be great since one could reuse the JSON with minimal changes, and easily set different time ranges for different queries.

Time slice needs to be converted to a readable format. Not sure if there is already an issue for this.

So you know what its on

test

Let's say you have multiple JSON files (perhaps for different accounts or deployments) and you want to append the data together. We need the ability to append to a file.

Right now, the job will fail is you lose your laptop connection for too long. Let's say you're running a job that takes 20-30 minutes.

Right now, we can't start a job before heading the office or during the last hour of the day without a concern about it failing. It would be sweet if the Report Gen could sleep during network downtime, and then continue to retrieve the job status when you come back online.

In case you want to see the status manually and for debugging...

test