It seems that the aws api limits you to about the last 4 hours worth of data. How hard would it be to look at vpc flows logs exported to an s3 bucket? They store the flow data as an unstructured compressed (and possibly encrypted) text file within a directory structure. This would make it much easier for the system to look at more flow data without the added expense of an api call. I am enclosing an example table structure that I used to do sql:
CREATE TABLE "public"."vpc" (
"time" timestamp NOT NULL,
"version" integer NOT NULL,
"account" text NOT NULL,
"interface" text NOT NULL,
"srcaddr" inet,
"dstaddr" inet,
"srcport" integer,
"dstport" integer,
"protocol" int,
"packets" bigint,
"bytes" bigint,
"start" int,
"end" int,
"action" text,
"log-status" text
) WITH (oids = false);
Here is an example single line (uncompressed)
2018-07-26T21:01:11.000Z 2 678049594014 eni-0foobar 10.111.15.10 12.16.612.124 35136 2100 6 2 104 1532638871 1532638930 ACCEPT OK
Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. Car parking multiplayer for ios
Thank you, I have recently been searching for info about this subject for ages and yours is the best I’ve found so far. winmate88 australia
Excellent blog right here! Also your site a lot up very fast! What web host are you the use of? Can I am getting your associate link to your host? I want my site loaded up as quickly as yours lol mega888 download
Thank you for having the time to discuss this topic. I truly appreciate it. I’ll stick a link of this entry in my site. Visit us
I think this is among the such a lot important information for me. And i’m glad studying your article. However should commentary on few common things, The web site taste is perfect, the articles is really great . Good activity, cheers. Manna Flux order
there are many good family resorts that you can find both online and offline, some are very cheap too“ Prodentim
Scripmine is an innovative online platform that seamlessly blends technology, creativity, and knowledge to provide a space for digital exploration and growth. Scripmine
I conceive this website has very wonderful indited content material posts . find out more
Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging..have a peek here paybyplatema Check This Out paybyplatema this content paybyplatema my review here paybyplatema Get More Info paybyplatema click to read more paybyplatema click here now paybyplatema more info here paybyplatema this content paybyplatema my review here paybyplatema
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.have a peek here panoramacharter Check This Out panoramacharter this content panoramacharter my review here panoramacharter Get More Info panoramacharter click to read more panoramacharter click here now panoramacharter more info here panoramacharter this content panoramacharter my review here panoramacharter
Love to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thanks.have a peek here wendysbreakfasthours Check This Out wendysbreakfasthours this content wendysbreakfasthours my review here wendysbreakfasthours Get More Info wendysbreakfasthours click to read more wendysbreakfasthours click here now wendysbreakfasthours more info here wendysbreakfasthours this content wendysbreakfasthours
I think this is an informative post and it is very beneficial and knowledgeable. Therefore, I would like to thank you for the endeavors that you have made in writing this article. All the content is absolutely well-researched. Thanks... vun77
I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject.have a peek here s0nichappyyhourr Check This Out s0nichappyyhourr this content s0nichappyyhourr my review here s0nichappyyhourr Get More Info s0nichappyyhourr click to read more s0nichappyyhourr click here now s0nichappyyhourr more info here s0nichappyyhourr this content s0nichappyyhourr my review here s0nichappyyhourr
This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post.! Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers Tellculvers
This is such a great resource that you are providing and you give it away for free. sim owner ship
I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject.have a peek here talktostopand Check This Out talktostopand this content talktostopand my review here talktostopand Get More Info talktostopand click to read more talktostopand click here now talktostopand more info here talktostopand this content talktostopand my review here talktostopand
I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject.have a peek here krogerfeeedbackCheck This Out krogerfeeedbackthis content krogerfeeedbackmy review here krogerfeeedbackGet More Info krogerfeeedbackclick to read more krogerfeeedbackclick here now krogerfeeedbackmore info here krogerfeeedbackthis content krogerfeeedbackmy review here krogerfeeedback
It is the kind of information I have been trying to find. Thank you for writing this information. It has proved utmost beneficial for me.have a peek here tellhco Check This Out tellhco this content tellhco my review here tellhco Get More Info tellhco click to read more tellhco click here now tellhco more info here tellhco this content tellhco my review here tellhco
It is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post.have a peek here alaskasworld Check This Out alaskasworld this content alaskasworld my review here alaskasworld Get More Info alaskasworld click to read more alaskasworld click here now alaskasworld more info here alaskasworld this content alaskasworld my review here alaskasworld
I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject.have a peek here marshallsfeedback Check This Out marshallsfeedback this content marshallsfeedback my review here marshallsfeedback Get More Info marshallsfeedback click to read more marshallsfeedback click here now marshallsfeedback more info here marshallsfeedback this content marshallsfeedback my review here marshallsfeedback