{"id":526,"date":"2016-04-09T11:02:14","date_gmt":"2016-04-09T11:02:14","guid":{"rendered":"http:\/\/wp.andreas.bieri.name\/myblog\/?p=526"},"modified":"2016-04-09T11:02:14","modified_gmt":"2016-04-09T11:02:14","slug":"lync-ip-adresse-eines-endpunktes","status":"publish","type":"post","link":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/","title":{"rendered":"Lync\/Skype: IP Adresse eines Endpunktes"},"content":{"rendered":"<p>Ein oft nachgefragte Information in einem Lync\/Skype for Business System ist die IP Adresse eine registrierten Endpunktes. Fr\u00fcher waren diese <a href=\"http:\/\/blogs.technet.com\/b\/parallel_universe_-_ms_tech_blog\/archive\/2011\/09\/29\/powershell-lync-map-a-sip-user-to-the-ip-address-it-came-from.aspx\">hier<\/a> zu finden.<\/p>\n<p>Mit Lync 2013 und Skype for Business sind die IP Adressen nur noch in der lcscdr Datenbank und in der QoeDB zu finden:<\/p>\n<ul>\n<li><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/gg398114.aspx\">Registration table details in lcscdr Database<\/a><\/li>\n<li><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/jj205077.aspx\">IP table in QoE Database<\/a><\/li>\n<li><a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/jj205205.aspx\">Traceroute table in QoE Database<\/a><\/li>\n<\/ul>\n<p>Nach M\u00f6glichketi sollte man nicht direkt mit den tables arbeiten, sondern mit den stored Procedures (soweit vorhanden) und den Views (Beispiel Queries sind oben angef\u00fchrt).\u00a0Mit der IP lassen sich coole Sachen bauen: geo-lokalisierte Endpunkte&#8230;Codebeispiele dazu in dieser\u00a0Pr\u00e4sentation von der Lync Ignite 2014:\u00a0<a href=\"https:\/\/channel9.msdn.com\/Events\/Lync-Conference\/Lync-Conference-2014?sort=sequential&amp;direction=desc&amp;term=&amp;s=shane-hoey#theSessions\">Hardcore Lync Analytics<\/a>.<\/p>\n<p>Die Bestimmung der Koordinaten aufgrund einer Post-Adresse wird als Geo-Coding bezeichnet. Der Standard Service dazu ist <a href=\"https:\/\/developers.google.com\/maps\/documentation\/geocoding\/intro?hl=de#GeocodingRequests\">Google Maps Geocoding<\/a>, es gibt auch <a href=\"http:\/\/geoservices.tamu.edu\/Services\/Geocode\/OtherGeocoders\/\">andere<\/a>\u00a0und es geht auch direkt aus einer SQL Datenbank heraus mit Powershell (<a href=\"https:\/\/architectevangelist.wordpress.com\/2012\/10\/20\/bulk-bing-maps-geocode-service-encoding-using-powershell\/\">so wie hier<\/a>). Die Antworten m\u00fcssen aber noch ausgewertet werden (<a href=\"https:\/\/developers.google.com\/maps\/web-services\/overview?hl=de#ParsingXML\">weitere Informationen<\/a>)\u00a0sodass die ganze Sache nicht ganz trivial ist.<\/p>\n<p><img loading=\"lazy\" class=\"alignleft size-full wp-image-524\" src=\"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png\" alt=\"image.png\" width=\"1024\" height=\"477\" srcset=\"http:\/\/52.29.166.97\/myblog\/wp-content\/uploads\/2016\/04\/image-9.png 1024w, http:\/\/52.29.166.97\/myblog\/wp-content\/uploads\/2016\/04\/image-9-300x140.png 300w, http:\/\/52.29.166.97\/myblog\/wp-content\/uploads\/2016\/04\/image-9-768x358.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ein oft nachgefragte Information in einem Lync\/Skype for Business System ist die IP Adresse eine registrierten Endpunktes. Fr\u00fcher waren diese hier zu finden. Mit Lync 2013 und Skype for Business sind die IP Adressen nur noch in der lcscdr Datenbank und in der QoeDB zu finden: Registration table details in lcscdr Database IP table in [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,6],"tags":[64],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.\" \/>\n<meta property=\"og:description\" content=\"Ein oft nachgefragte Information in einem Lync\/Skype for Business System ist die IP Adresse eine registrierten Endpunktes. Fr\u00fcher waren diese hier zu finden. Mit Lync 2013 und Skype for Business sind die IP Adressen nur noch in der lcscdr Datenbank und in der QoeDB zu finden: Registration table details in lcscdr Database IP table in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/\" \/>\n<meta property=\"og:site_name\" content=\"Merkbar.\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-09T11:02:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"wp_blogadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#website\",\"url\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/\",\"name\":\"Merkbar.\",\"description\":\"IT, Elektronik und Mathematik\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#primaryimage\",\"inLanguage\":\"de\",\"url\":\"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png\",\"contentUrl\":\"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#webpage\",\"url\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/\",\"name\":\"Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.\",\"isPartOf\":{\"@id\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#primaryimage\"},\"datePublished\":\"2016-04-09T11:02:14+00:00\",\"dateModified\":\"2016-04-09T11:02:14+00:00\",\"author\":{\"@id\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d\"},\"breadcrumb\":{\"@id\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lync\/Skype: IP Adresse eines Endpunktes\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d\",\"name\":\"wp_blogadmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#personlogo\",\"inLanguage\":\"de\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/d0dc804558b03f640b22e497ec010c9a?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/d0dc804558b03f640b22e497ec010c9a?s=96&d=mm&r=g\",\"caption\":\"wp_blogadmin\"},\"url\":\"http:\/\/52.29.166.97\/myblog\/author\/wp_blogadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.","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":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/","og_locale":"de_DE","og_type":"article","og_title":"Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.","og_description":"Ein oft nachgefragte Information in einem Lync\/Skype for Business System ist die IP Adresse eine registrierten Endpunktes. Fr\u00fcher waren diese hier zu finden. Mit Lync 2013 und Skype for Business sind die IP Adressen nur noch in der lcscdr Datenbank und in der QoeDB zu finden: Registration table details in lcscdr Database IP table in [&hellip;]","og_url":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/","og_site_name":"Merkbar.","article_published_time":"2016-04-09T11:02:14+00:00","og_image":[{"url":"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png"}],"twitter_card":"summary","twitter_misc":{"Verfasst von":"wp_blogadmin","Gesch\u00e4tzte Lesezeit":"1 Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#website","url":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/","name":"Merkbar.","description":"IT, Elektronik und Mathematik","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"ImageObject","@id":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#primaryimage","inLanguage":"de","url":"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png","contentUrl":"http:\/\/wp.andreas.bieri.name\/wp-content\/uploads\/2016\/04\/image-9.png"},{"@type":"WebPage","@id":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#webpage","url":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/","name":"Lync\/Skype: IP Adresse eines Endpunktes - Merkbar.","isPartOf":{"@id":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#website"},"primaryImageOfPage":{"@id":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#primaryimage"},"datePublished":"2016-04-09T11:02:14+00:00","dateModified":"2016-04-09T11:02:14+00:00","author":{"@id":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d"},"breadcrumb":{"@id":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/52.29.166.97\/myblog\/2016\/04\/09\/lync-ip-adresse-eines-endpunktes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/"},{"@type":"ListItem","position":2,"name":"Lync\/Skype: IP Adresse eines Endpunktes"}]},{"@type":"Person","@id":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d","name":"wp_blogadmin","image":{"@type":"ImageObject","@id":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/#personlogo","inLanguage":"de","url":"http:\/\/1.gravatar.com\/avatar\/d0dc804558b03f640b22e497ec010c9a?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/d0dc804558b03f640b22e497ec010c9a?s=96&d=mm&r=g","caption":"wp_blogadmin"},"url":"http:\/\/52.29.166.97\/myblog\/author\/wp_blogadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/posts\/526"}],"collection":[{"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":0,"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"wp:attachment":[{"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/52.29.166.97\/myblog\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}