{"id":11172,"date":"2025-02-01T01:00:12","date_gmt":"2025-01-31T22:00:12","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/"},"modified":"2025-02-01T01:00:12","modified_gmt":"2025-01-31T22:00:12","slug":"aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/","title":{"rendered":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak"},"content":{"rendered":"<p><body><\/p>\n<p>AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak<\/p>\n<p>Merhaba!  Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m.  Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r.  \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor.  Bu nedenle,  \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.<\/p>\n<p><strong>Veri D\u00f6n\u00fc\u015f\u00fcm\u00fc:<\/strong>  CloudTrail g\u00fcnl\u00fckleri genellikle JSON veya CSV format\u0131ndad\u0131r. Bu verileri SQL ile sorgulayabilmek i\u00e7in, \u00f6ncelikle ili\u015fkisel bir veritaban\u0131na (\u00f6rne\u011fin, PostgreSQL, MySQL veya SQLite) aktarmal\u0131y\u0131z.  Bunun i\u00e7in \u00e7e\u015fitli ara\u00e7lar ve y\u00f6ntemler mevcuttur. \u00d6rne\u011fin, AWS&#8217;in kendi ara\u00e7lar\u0131n\u0131 kullanabilir veya  jq gibi komut sat\u0131r\u0131 ara\u00e7lar\u0131n\u0131 tercih edebilirsiniz.  Amac\u0131m\u0131z, JSON verilerini uygun tablo \u015femalar\u0131na d\u00f6n\u00fc\u015ft\u00fcrmektir.  Ard\u0131ndan bu verileri se\u00e7ti\u011finiz veritaban\u0131na y\u00fckleyebilirsiniz.<\/p>\n<p><strong>\u00d6rnek Senaryo:<\/strong>  Diyelim ki, belirli bir tarih aral\u0131\u011f\u0131nda ger\u00e7ekle\u015ftirilen S3 eri\u015fimlerini sorgulamak istiyorsunuz.  \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerini indirip,  JSON verilerini bir tablo \u015femas\u0131na d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekir.  Bu \u015femada, tarih, saat, kullan\u0131c\u0131, i\u015flem t\u00fcr\u00fc ve kaynak gibi \u00f6nemli bilgiler yer almal\u0131d\u0131r. Sonras\u0131nda, SQL sorgular\u0131n\u0131z\u0131 kullanarak bu verileri analiz edebilirsiniz.  A\u015fa\u011f\u0131da \u00f6rnek bir SQL sorgusu bulunmaktad\u0131r:<\/p>\n<pre><code class=\"language-sql\">\nSELECT *\nFROM cloudtrail_logs\nWHERE eventSource = 's3.amazonaws.com'\n  AND eventTime BETWEEN '2023-10-26 00:00:00' AND '2023-10-27 00:00:00';\n<\/code><\/pre>\n<p><strong>Ara\u00e7lar ve Kaynaklar:<\/strong>  Bu s\u00fcreci kolayla\u015ft\u0131rmak i\u00e7in bir\u00e7ok ara\u00e7 mevcuttur.  \u00d6rne\u011fin,  awslogs komut sat\u0131r\u0131 arac\u0131 CloudTrail g\u00fcnl\u00fcklerini filtreleyip indirebilir. Ayr\u0131ca,  jq gibi JSON i\u015fleme ara\u00e7lar\u0131 verileri yap\u0131land\u0131rmada yard\u0131mc\u0131 olabilir.  Veritaban\u0131na veri y\u00fckleme i\u00e7in ise, psql (PostgreSQL), mysql (MySQL) gibi komut sat\u0131r\u0131 ara\u00e7lar\u0131n\u0131 kullanabilirsiniz.  Ayr\u0131ca, \u00e7e\u015fitli programlama dilleri ile (Python, Java vb.)  otomasyonlar olu\u015fturabilirsiniz.<\/p>\n<p><strong>Avantajlar:<\/strong>  Yerel SQL sorgulama, CloudTrail g\u00fcnl\u00fcklerini analiz etmenin h\u0131zl\u0131 ve etkili bir yoludur.  B\u00fcy\u00fck veri setlerini veritaban\u0131 optimizasyonlar\u0131yla h\u0131zl\u0131ca sorgulayabilirsiniz. Ayr\u0131ca,  SQL&#8217;in g\u00fcc\u00fcnden yararlanarak karma\u015f\u0131k sorgular olu\u015fturabilirsiniz.  \u00d6rne\u011fin, belirli bir kullan\u0131c\u0131 taraf\u0131ndan ger\u00e7ekle\u015ftirilen i\u015flemleri, ba\u015far\u0131s\u0131z olan i\u015flemleri veya belirli kaynaklara yap\u0131lan eri\u015fimleri kolayca sorgulayabilirsiniz.  Sonu\u00e7 olarak, g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek ve  bulut ortam\u0131n\u0131z\u0131n g\u00fcvenli\u011fini iyile\u015ftirmek i\u00e7in de\u011ferli bilgiler elde edersiniz.<\/p>\n<p><strong>Sonu\u00e7:<\/strong>  AWS CloudTrail g\u00fcnl\u00fcklerini yerel olarak SQL ile sorgulamak, bulut g\u00fcvenli\u011fi ve operasyonlar\u0131 i\u00e7in g\u00fc\u00e7l\u00fc bir yakla\u015f\u0131md\u0131r.  Bu y\u00f6ntem, verileri daha etkin bir \u015fekilde analiz etmenizi ve potansiyel sorunlar\u0131 \u00f6nceden tespit etmenizi sa\u011flar.  Unutmay\u0131n ki, bu i\u015flem i\u00e7in biraz teknik bilgi ve tecr\u00fcbe gerekmektedir.  Ancak, do\u011fru ara\u00e7lar ve y\u00f6ntemlerle bu i\u015flemi ba\u015far\u0131yla ger\u00e7ekle\u015ftirebilirsiniz. Daha fazla bilgi i\u00e7in <a href=\"https:\/\/fatihsoysal.com\">fatihsoysal.com<\/a> sitesini ziyaret edebilirsiniz.<\/p>\n<p><strong>Faydal\u0131 Ba\u011flant\u0131lar:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/dev.to\/aws-builders\/query-aws-cloudtrail-logs-locally-with-sql-4jcj\">Orijinal Makale (\u0130ngilizce)<\/a><\/li>\n<li><a href=\"https:\/\/aws.amazon.com\/cloudtrail\/\">AWS CloudTrail Resmi Dok\u00fcmanlar\u0131<\/a><\/li>\n<li><a href=\"https:\/\/stedolan.github.io\/jq\/\">jq Arac\u0131<\/a><\/li>\n<\/ul>\n<p><\/body><br \/>\n<\/html><\/p>\n<p>#Etiketler: AWS CloudTrail, SQL, G\u00fcnl\u00fck Sorgulama, Yerel Sorgulama, Veri Analizi, AWS, Bulut G\u00fcvenli\u011fi, JSON, CSV, PostgreSQL, MySQL, SQLite, jq, awslogs, psql, mysql, g\u00fcvenlik olaylar\u0131, veri d\u00f6n\u00fc\u015f\u00fcm\u00fc,  bulut g\u00fcvenli\u011fi,  veritaban\u0131<\/p>\n","protected":false},"excerpt":{"rendered":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-11172","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak<\/title>\n<meta name=\"description\" content=\"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak\" \/>\n<meta property=\"og:description\" content=\"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-31T22:00:12+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak\",\"datePublished\":\"2025-01-31T22:00:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\"},\"wordCount\":584,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\",\"name\":\"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-01-31T22:00:12+00:00\",\"description\":\"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak","description":"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/","og_locale":"tr_TR","og_type":"article","og_title":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak","og_description":"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.","og_url":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-01-31T22:00:12+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak","datePublished":"2025-01-31T22:00:12+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/"},"wordCount":584,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/","url":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/","name":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-01-31T22:00:12+00:00","description":"Merhaba! Fatih Soysal olarak, bu makalede AWS CloudTrail g\u00fcnl\u00fcklerini yerel ortam\u0131n\u0131zda SQL kullanarak nas\u0131l sorgulayabilece\u011finizi ad\u0131m ad\u0131m anlataca\u011f\u0131m. Bu y\u00f6ntem, bulut ortam\u0131n\u0131zdaki etkinlikleri analiz etmek ve g\u00fcvenlik olaylar\u0131n\u0131 tespit etmek i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6ncelikle, CloudTrail g\u00fcnl\u00fcklerinin b\u00fcy\u00fck ve karma\u015f\u0131k oldu\u011funu ve direkt olarak SQL ile sorgulaman\u0131n m\u00fcmk\u00fcn olmad\u0131\u011f\u0131n\u0131 belirtmem gerekiyor. Bu nedenle, \u00f6ncelikle verileri d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekiyor.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/aws-cloudtrail-gunluklerini-yerel-olarak-sql-ile-sorgulamak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AWS CloudTrail G\u00fcnl\u00fcklerini Yerel Olarak SQL ile Sorgulamak"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/11172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=11172"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/11172\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=11172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=11172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=11172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}