{"id":789,"date":"2020-04-11T10:12:00","date_gmt":"2020-04-11T08:12:00","guid":{"rendered":"https:\/\/itblogwildi.wordpress.com\/?p=789"},"modified":"2020-04-11T10:12:00","modified_gmt":"2020-04-11T08:12:00","slug":"verbindungsdaten-mail-aus-exchange-exportieren","status":"publish","type":"post","link":"https:\/\/itblog.wildi.dk\/?p=789","title":{"rendered":"Verbindungsdaten (Mail) aus Exchange exportieren"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen potenten Sortier- und Filterfunktionen nutzen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Doch hier stiess ich an eine Grenze. Ich musste den Wert &#171;EventData&#187; exportieren. In Excel (via Export-Csv) erhielt ich nur unsinnige Daten:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">System.Collections.Generic.KeyValuePair`2[System.String,System.Object][]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Also wechselte ich auf<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ConvertTo-Html<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">und<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Out-File<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Da sich in diesem Fall die Info \u00fcber die Server-IP nur in den Logs mit &#171;EventID = RECEIVE&#187; befand, habe ich noch danach gefiltert:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Get-MessageTrackingLog -Start (Get-Date).AddDays(-5) -ResultSize Unlimited | Where-Object {$_.EventID -match \"RECEIVE\"} | convertto-HTML TimeStamp,Sender,{$_.recipients},MessageSubject,{$_.EventData} | out-file C:\\Temp\\ExportLog_01.html<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Das ergibt ein &#171;sch\u00f6nes&#187; HTML File, welches auch problemlos durchsucht werden kann.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im&#8230; <a class=\"read-more\" href=\"https:\/\/itblog.wildi.dk\/?p=789\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,29],"tags":[],"class_list":["post-789","post","type-post","status-publish","format-standard","hentry","category-exchange","category-powershell"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Martin Wildi\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/itblog.wildi.dk\/?p=789\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"IT Blog Wildi - Blog \u00fcber IT und anderes.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi\" \/>\n\t\t<meta property=\"og:description\" content=\"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/itblog.wildi.dk\/?p=789\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-04-11T08:12:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-11T08:12:00+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#blogposting\",\"name\":\"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi\",\"headline\":\"Verbindungsdaten (Mail) aus Exchange exportieren\",\"author\":{\"@id\":\"##author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Martin Wildi\"},\"datePublished\":\"2020-04-11T10:12:00+02:00\",\"dateModified\":\"2020-04-11T10:12:00+02:00\",\"inLanguage\":\"de-CH-informal\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#webpage\"},\"articleSection\":\"Exchange, PowerShell\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/itblog.wildi.dk\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?cat=13#listItem\",\"name\":\"Exchange\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?cat=13#listItem\",\"position\":2,\"name\":\"Exchange\",\"item\":\"https:\\\/\\\/itblog.wildi.dk\\\/?cat=13\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#listItem\",\"name\":\"Verbindungsdaten (Mail) aus Exchange exportieren\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#listItem\",\"position\":3,\"name\":\"Verbindungsdaten (Mail) aus Exchange exportieren\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?cat=13#listItem\",\"name\":\"Exchange\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/#person\",\"name\":\"Martin Wildi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Martin Wildi\"}},{\"@type\":\"Person\",\"@id\":\"##author\",\"url\":\"#\",\"name\":\"Martin Wildi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Martin Wildi\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#webpage\",\"url\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789\",\"name\":\"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi\",\"description\":\"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \\u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen\",\"inLanguage\":\"de-CH-informal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/?p=789#breadcrumblist\"},\"author\":{\"@id\":\"##author\"},\"creator\":{\"@id\":\"##author\"},\"datePublished\":\"2020-04-11T10:12:00+02:00\",\"dateModified\":\"2020-04-11T10:12:00+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/#website\",\"url\":\"https:\\\/\\\/itblog.wildi.dk\\\/\",\"name\":\"IT Blog Wildi\",\"description\":\"Blog \\u00fcber IT und anderes.\",\"inLanguage\":\"de-CH-informal\",\"publisher\":{\"@id\":\"https:\\\/\\\/itblog.wildi.dk\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi","description":"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen","canonical_url":"https:\/\/itblog.wildi.dk\/?p=789","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/itblog.wildi.dk\/?p=789#blogposting","name":"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi","headline":"Verbindungsdaten (Mail) aus Exchange exportieren","author":{"@id":"##author"},"publisher":{"@id":"https:\/\/itblog.wildi.dk\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/itblog.wildi.dk\/?p=789#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g","width":96,"height":96,"caption":"Martin Wildi"},"datePublished":"2020-04-11T10:12:00+02:00","dateModified":"2020-04-11T10:12:00+02:00","inLanguage":"de-CH-informal","mainEntityOfPage":{"@id":"https:\/\/itblog.wildi.dk\/?p=789#webpage"},"isPartOf":{"@id":"https:\/\/itblog.wildi.dk\/?p=789#webpage"},"articleSection":"Exchange, PowerShell"},{"@type":"BreadcrumbList","@id":"https:\/\/itblog.wildi.dk\/?p=789#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk#listItem","position":1,"name":"Home","item":"https:\/\/itblog.wildi.dk","nextItem":{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk\/?cat=13#listItem","name":"Exchange"}},{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk\/?cat=13#listItem","position":2,"name":"Exchange","item":"https:\/\/itblog.wildi.dk\/?cat=13","nextItem":{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk\/?p=789#listItem","name":"Verbindungsdaten (Mail) aus Exchange exportieren"},"previousItem":{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk\/?p=789#listItem","position":3,"name":"Verbindungsdaten (Mail) aus Exchange exportieren","previousItem":{"@type":"ListItem","@id":"https:\/\/itblog.wildi.dk\/?cat=13#listItem","name":"Exchange"}}]},{"@type":"Person","@id":"https:\/\/itblog.wildi.dk\/#person","name":"Martin Wildi","image":{"@type":"ImageObject","@id":"https:\/\/itblog.wildi.dk\/?p=789#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g","width":96,"height":96,"caption":"Martin Wildi"}},{"@type":"Person","@id":"##author","url":"#","name":"Martin Wildi","image":{"@type":"ImageObject","@id":"https:\/\/itblog.wildi.dk\/?p=789#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/a1c8a3ca3a2a4720206887f0ccc4f80bf521e8af2cef394783141b99318bcca4?s=96&d=mm&r=g","width":96,"height":96,"caption":"Martin Wildi"}},{"@type":"WebPage","@id":"https:\/\/itblog.wildi.dk\/?p=789#webpage","url":"https:\/\/itblog.wildi.dk\/?p=789","name":"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi","description":"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen","inLanguage":"de-CH-informal","isPartOf":{"@id":"https:\/\/itblog.wildi.dk\/#website"},"breadcrumb":{"@id":"https:\/\/itblog.wildi.dk\/?p=789#breadcrumblist"},"author":{"@id":"##author"},"creator":{"@id":"##author"},"datePublished":"2020-04-11T10:12:00+02:00","dateModified":"2020-04-11T10:12:00+02:00"},{"@type":"WebSite","@id":"https:\/\/itblog.wildi.dk\/#website","url":"https:\/\/itblog.wildi.dk\/","name":"IT Blog Wildi","description":"Blog \u00fcber IT und anderes.","inLanguage":"de-CH-informal","publisher":{"@id":"https:\/\/itblog.wildi.dk\/#person"}}]},"og:locale":"de_DE","og:site_name":"IT Blog Wildi - Blog \u00fcber IT und anderes.","og:type":"article","og:title":"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi","og:description":"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen","og:url":"https:\/\/itblog.wildi.dk\/?p=789","article:published_time":"2020-04-11T08:12:00+00:00","article:modified_time":"2020-04-11T08:12:00+00:00","twitter:card":"summary_large_image","twitter:title":"Verbindungsdaten (Mail) aus Exchange exportieren - IT Blog Wildi","twitter:description":"In einem komplexeren Fall musste ich die gesamten Verbindungsdaten des ganzen Mailservers untersuchen, um einige spezielle Mails zu identifizieren. Im konkreten Fall ging es darum, festzustellen, ob noch \u00fcber eine spezifische Inboud-Connector-IP Mails versendet werden. Normalerweise verwende ich PowerShell und exportiere in csv. Diese Files importiere ich dann in Excel. In Excel kann ich dessen"},"aioseo_meta_data":{"post_id":"789","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-05-16 01:50:14","updated":"2026-05-16 01:50:14"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/itblog.wildi.dk\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/itblog.wildi.dk\/?cat=13\" title=\"Exchange\">Exchange<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tVerbindungsdaten (Mail) aus Exchange exportieren\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/itblog.wildi.dk"},{"label":"Exchange","link":"https:\/\/itblog.wildi.dk\/?cat=13"},{"label":"Verbindungsdaten (Mail) aus Exchange exportieren","link":"https:\/\/itblog.wildi.dk\/?p=789"}],"_links":{"self":[{"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=\/wp\/v2\/posts\/789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=789"}],"version-history":[{"count":0,"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=\/wp\/v2\/posts\/789\/revisions"}],"wp:attachment":[{"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itblog.wildi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}