Hello Spice-Heads!

I dont like complaining, criticizing or anything of the sort (not that I do much of it anyways but…) IF I dont have a better solution.

I have taken over some security responsibilities and one of them requires me to review reports sent to us from our MDR partner and I am task to continue doing what the previous was doing and that was taking screenshots of the information (graphs etc…) in PDF’s and pulling data from csv reports and combining into an Excel spreadsheet. This isnt for reporting but for historical reviews…to keep the pertinent data “in front of us” outside of “real reporting” to SMT or otherwise.

I’m looking for a better solution. Do you log any of these graphs, charts etc…collect data numbers? What do you use for “storing” purposes?

Any and all information would be very much appreciated.

Thanks y’all!

2 Spice ups

It seems like a lot of work, but it is a good idea to get an overview of the historical data. Can’t the partner just send you a historical report? It seems to me like it’s a manual report of previous reports. If they can’t send you the report, it might be worth scripting something in python to pull the data you need from CSVs and compiling in a new CSV/excel sheet.

1 Spice up

Thanks for the reply @tb33t . We receive weekly and monthly reports. PDF with different types of graphs listing diff data and a .csv report. That one gets sent to a another department for reporting purposes and we are ok with that process. Its the documentation on my end that I’d like to make better.

I agree with TB33T above. Most of these companies know that they will have different audiences so they will have different reports. They surely must have some Senior/Executive level reports/summary. Maybe one is close enough to suit your needs or at least cuts down on your work. Let them know your requirements.

As mentioned above - the vendor might be able to create the report you’re looking for - email them a copy of what you are manually creating and ask them if they can include a report including the data you want as well.

Seems like copy & pasting the graphs is likely to be the most manual (read: annoying) part. Any chance that the data in the graphs is in, or can be derived from, the csv data?