{"id":1787,"date":"2016-10-20T20:07:50","date_gmt":"2016-10-20T20:07:50","guid":{"rendered":"http:\/\/wp.andreas.bieri.name\/myblog\/?p=1787"},"modified":"2016-10-20T20:07:50","modified_gmt":"2016-10-20T20:07:50","slug":"skype-cdr-daten-mit-splunk-auswerten-teil-3","status":"publish","type":"post","link":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/","title":{"rendered":"Skype CDR Daten mit Splunk auswerten (Teil 3)"},"content":{"rendered":"

Siehe Teil 1<\/a> und Teil 2<\/a>.<\/p>\n

Statistiken f\u00fcr Telefonanrufe<\/h4>\n

F\u00fcr die Auswertung der eingehenden und ausgehenden PSTN Anrufe gibts es keine passende Stored Procedure. Hier zeigt sich erneut der nicht konsistente Entwicklungsstand der Monitoring Server Reports. Es ist aber nicht schwer, eine passende Stored Procedure PSTNCallSummaryReport<\/em> zu schreiben. Die Anrufe sind in der Tabelle\u00a0dbo.VoipDetails <\/em>aufgelistet und wir k\u00f6nnen diese entsprechend z\u00e4hlen und stundenweise aggregieren. Die Richtung des Anrufs ist durch die Telefonnummer gegeben, da die interne Seite immer als Audio Call mit einer SIP Adresse erscheint und die externe Seite mit einer Telefonnummer. Mit dieser Unterscheidung lassen sich eingehende und ausgehende Anrufe getrennt erfassen. Die Details eines Anrufs sind aber dann wieder, wie alle Verbindungen \u00fcberhaupt, in der Tabelle dbo.SessionDetails<\/em> zu finden. Das restliche Drumherum der neuen Stored Procedure kann von einem anderen Summary Report \u00fcbernommen und angepasst werden.<\/p>\n

 <\/p>\n

Stored Procedure\u00a0PSTNCallSummaryReport<\/em><\/h4>\n

USE<\/span> [LcsCDR]<\/p>\n

GO<\/p>\n

\/****** Object:\u00a0 StoredProcedure [dbo].[PSTNCallSummaryReport]\u00a0\u00a0\u00a0 Script Date: 22.09.2016 15:31:18 ******\/<\/p>\n

SET ANSI_NULLS ON<\/p>\n

GO<\/p>\n

SET QUOTED_IDENTIFIER ON<\/p>\n

GO<\/p>\n

ALTER procedure<\/span> [dbo].<\/span>[PSTNCallSummaryReport]<\/p>\n

\u00a0\u00a0 <\/span>@_StartTime\u00a0\u00a0\u00a0\u00a0 <\/span>datetime <\/span>= null,<\/span><\/p>\n

\u00a0\u00a0 @_EndTime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 datetime <\/span>= null,<\/span><\/p>\n

\u00a0\u00a0 <\/span>@_Interval\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>int <\/span>=<\/span> 5<\/span>,<\/span><\/p>\n

\u00a0\u00a0 @_WindowSize\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int <\/span>=<\/span> 5<\/p>\n

WITH RECOMPILE <\/span>— Recompile sprocs that may query large amount of data<\/span><\/p>\n

as<\/p>\n

begin<\/p>\n

\u00a0\u00a0\u00a0 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED<\/span><\/p>\n

\u00a0\u00a0\u00a0 declare<\/span> @Status int<\/span><\/p>\n

\u00a0\u00a0\u00a0 declare<\/span> @Msg\u00a0\u00a0\u00a0 int<\/span><\/p>\n

\u00a0\u00a0\u00a0 set<\/span> @Msg =<\/span> 0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — create table for time fields<\/span><\/p>\n

\u00a0\u00a0\u00a0 create table<\/span> #TimeAxis (<\/span> StartTime datetime<\/span>,<\/span> EndTime datetime <\/span>)<\/span><\/p>\n

\u00a0\u00a0\u00a0 if <\/span>(<\/span>@_EndTime is null) <\/span>select<\/span> @_EndTime = <\/span>getutcdate<\/span>()<\/span><\/p>\n

\u00a0\u00a0\u00a0 if <\/span>(<\/span>@_StartTime is null) <\/span>select<\/span> @_StartTime = <\/span>dateadd<\/span>(<\/span>hour<\/span>, –<\/span>1*<\/span>1,<\/span> @_EndTime)<\/span><\/p>\n

\u00a0\u00a0\u00a0 if <\/span>(<\/span>dbo.<\/span>pValidReportingDateTime(<\/span>@_StartTime,<\/span> @_EndTime,<\/span> @_Interval,<\/span> @_WindowSize) =<\/span> 0) <\/span>begin<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 set<\/span> @Msg =<\/span> 50500<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 goto<\/span> errorhandler<\/p>\n

\u00a0\u00a0\u00a0 end<\/span><\/p>\n

\u00a0\u00a0\u00a0 exec<\/span> @Status =<\/span> dbo.<\/span>RtcPopulateTimeAxis @_StartTime,<\/span> @_EndTime,<\/span> @_Interval<\/p>\n

\u00a0\u00a0\u00a0 if <\/span>(<\/span>@Status <><\/span> 0) <\/span>begin<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 set<\/span> @Msg =<\/span> 50500<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 goto<\/span> errorhandler<\/p>\n

\u00a0\u00a0\u00a0 end<\/span><\/p>\n

 <\/p>\n

Nach diesem Gepl\u00e4nkel folgt hier der eigentliche Code:<\/p>\n

 <\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — decide, if the call is inbound or outbound traffic<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT CASE WHEN <\/span>LEFT(<\/span>Users1.<\/span>UserUri,<\/span>1) = <\/span>‚+‘ <\/span>THEN <\/span>‚inbound‘ <\/span>ELSE <\/span>‚outbound‘ <\/span>END AS<\/span> Typ,<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VoipDetails.<\/span>SessionIdTime [Date],<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CONVERT<\/span>(<\/span>varchar<\/span>(<\/span>10),<\/span>SessionDetails.<\/span>SessionEndTime –<\/span> VoipDetails.<\/span>SessionIdTime,<\/span>108)<\/span> [Time],<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Phones.<\/span>PhoneUri [From Number],<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Users1.<\/span>UserUri [FromSip],<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Phones1.<\/span>PhoneUri [Number Dialed],<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SessionDetails.<\/span>SessionEndTime,<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VoipDetails.<\/span>SessionIdTime<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — write into temporary table<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INTO<\/span> #pstntable<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM<\/span> VoipDetails LEFT OUTER JOIN<\/span> SessionDetails<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON<\/span> VoipDetails.<\/span>SessionIdTime =<\/span> SessionDetails.<\/span>SessionIdTime AND<\/span> VoipDetails.<\/span>SessionIdSeq =<\/span> SessionDetails.<\/span>SessionIdSeq<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEFT OUTER JOIN<\/span>\u00a0 Phones<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON<\/span> VoipDetails.<\/span>FromNumberId =<\/span> Phones.<\/span>PhoneId<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEFT OUTER JOIN<\/span>\u00a0 Phones Phones1<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON<\/span> VoipDetails.<\/span>ConnectedNumberId =<\/span> Phones1.<\/span>PhoneId<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEFT OUTER JOIN<\/span>\u00a0 Users Users1<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON<\/span> SessionDetails.<\/span>User1Id =<\/span> Users1.<\/span>UserId<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 group by<\/span> Phones.<\/span>PhoneUri,<\/span> Users1.<\/span>UserUri,<\/span> VoipDetails.<\/span>SessionIdTime,<\/span> SessionDetails.<\/span>SessionEndTime,<\/span> Phones1.<\/span>PhoneUri<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 T.<\/span>StartTime as Sample<\/span>,<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sum<\/span>(<\/span>case when<\/span> Typ = <\/span>‚outbound‘ <\/span>then<\/span> 1 else<\/span> 0 end<\/span>) <\/span>as<\/span> outbound,<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sum<\/span>(<\/span>case when<\/span> Typ = <\/span>‚inbound‘ <\/span>then<\/span> 1 else<\/span> 0 end<\/span>) <\/span>as<\/span> inbound<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 from<\/span> #TimeAxis T<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 left join<\/span> #pstntable p on<\/span> T.<\/span>Starttime <=<\/span> p.<\/span>Date <\/span>and<\/span> T.<\/span>EndTime >=<\/span> p.<\/span>Date<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 group by<\/span> T.<\/span>StartTime<\/p>\n

 <\/p>\n

…und noch die standard Fehlerbehandlung und das Aufr\u00e4umen:<\/p>\n

errorhandler:<\/p>\n

\u00a0\u00a0\u00a0 if <\/span>(<\/span>@Msg <><\/span> 0) <\/span>begin<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exec<\/span> dbo.<\/span>DbRaiseError @@procid<\/span>,<\/span> @Msg<\/p>\n

\u00a0\u00a0\u00a0 end<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –delete temporary tables<\/span><\/p>\n

\u00a0\u00a0\u00a0 drop table<\/span> #TimeAxis<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 drop table<\/span> #pstntable<\/p>\n

\u00a0\u00a0\u00a0 return<\/span> @Msg<\/p>\n

end<\/p>\n

 <\/p>\n

Aufruf der Stored Procedure mit Powershell<\/h4>\n

Der Aufruf kann jetzt ganz analog wie bei den built-in Summary Reports unter dem gew\u00e4hlten Namen PSTNCallSummaryReport\u00a0<\/em>erfolgen. Das Ergebnis ist eine aggregierte CSV-Datei mit nach Richtung getrennt summierten Anrufen.\u00a0Im Splunk kann die Datei wie im Teil 2 beschrieben indiziert werden.<\/p>\n","protected":false},"excerpt":{"rendered":"

Siehe Teil 1 und Teil 2. Statistiken f\u00fcr Telefonanrufe F\u00fcr die Auswertung der eingehenden und ausgehenden PSTN Anrufe gibts es keine passende Stored Procedure. Hier zeigt sich erneut der nicht konsistente Entwicklungsstand der Monitoring Server Reports. Es ist aber nicht schwer, eine passende Stored Procedure PSTNCallSummaryReport zu schreiben. Die Anrufe sind in der Tabelle\u00a0dbo.VoipDetails aufgelistet […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[130],"yoast_head":"\nSkype CDR Daten mit Splunk auswerten (Teil 3) - 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:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Skype CDR Daten mit Splunk auswerten (Teil 3) - Merkbar.\" \/>\n<meta property=\"og:description\" content=\"Siehe Teil 1 und Teil 2. Statistiken f\u00fcr Telefonanrufe F\u00fcr die Auswertung der eingehenden und ausgehenden PSTN Anrufe gibts es keine passende Stored Procedure. Hier zeigt sich erneut der nicht konsistente Entwicklungsstand der Monitoring Server Reports. Es ist aber nicht schwer, eine passende Stored Procedure PSTNCallSummaryReport zu schreiben. Die Anrufe sind in der Tabelle\u00a0dbo.VoipDetails aufgelistet […]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Merkbar.\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-20T20:07:50+00:00\" \/>\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=\"3 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/#website\",\"url\":\"http:\/\/wp.andreas.bieri.name\/myblog\/\",\"name\":\"Merkbar.\",\"description\":\"IT, Elektronik und Mathematik\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/wp.andreas.bieri.name\/myblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#webpage\",\"url\":\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/\",\"name\":\"Skype CDR Daten mit Splunk auswerten (Teil 3) - Merkbar.\",\"isPartOf\":{\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/#website\"},\"datePublished\":\"2016-10-20T20:07:50+00:00\",\"dateModified\":\"2016-10-20T20:07:50+00:00\",\"author\":{\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d\"},\"breadcrumb\":{\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"http:\/\/wp.andreas.bieri.name\/myblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Skype CDR Daten mit Splunk auswerten (Teil 3)\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/wp.andreas.bieri.name\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d\",\"name\":\"wp_blogadmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/wp.andreas.bieri.name\/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:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/author\/wp_blogadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Skype CDR Daten mit Splunk auswerten (Teil 3) - 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:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/","og_locale":"de_DE","og_type":"article","og_title":"Skype CDR Daten mit Splunk auswerten (Teil 3) - Merkbar.","og_description":"Siehe Teil 1 und Teil 2. Statistiken f\u00fcr Telefonanrufe F\u00fcr die Auswertung der eingehenden und ausgehenden PSTN Anrufe gibts es keine passende Stored Procedure. Hier zeigt sich erneut der nicht konsistente Entwicklungsstand der Monitoring Server Reports. Es ist aber nicht schwer, eine passende Stored Procedure PSTNCallSummaryReport zu schreiben. Die Anrufe sind in der Tabelle\u00a0dbo.VoipDetails aufgelistet […]","og_url":"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/","og_site_name":"Merkbar.","article_published_time":"2016-10-20T20:07:50+00:00","twitter_card":"summary","twitter_misc":{"Verfasst von":"wp_blogadmin","Gesch\u00e4tzte Lesezeit":"3 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/wp.andreas.bieri.name\/myblog\/#website","url":"http:\/\/wp.andreas.bieri.name\/myblog\/","name":"Merkbar.","description":"IT, Elektronik und Mathematik","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/wp.andreas.bieri.name\/myblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"WebPage","@id":"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#webpage","url":"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/","name":"Skype CDR Daten mit Splunk auswerten (Teil 3) - Merkbar.","isPartOf":{"@id":"http:\/\/wp.andreas.bieri.name\/myblog\/#website"},"datePublished":"2016-10-20T20:07:50+00:00","dateModified":"2016-10-20T20:07:50+00:00","author":{"@id":"http:\/\/wp.andreas.bieri.name\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d"},"breadcrumb":{"@id":"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/wp.andreas.bieri.name\/myblog\/2016\/10\/20\/skype-cdr-daten-mit-splunk-auswerten-teil-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"http:\/\/wp.andreas.bieri.name\/myblog\/"},{"@type":"ListItem","position":2,"name":"Skype CDR Daten mit Splunk auswerten (Teil 3)"}]},{"@type":"Person","@id":"http:\/\/wp.andreas.bieri.name\/myblog\/#\/schema\/person\/47691942dec3f2eb9d34bb8b5507870d","name":"wp_blogadmin","image":{"@type":"ImageObject","@id":"http:\/\/wp.andreas.bieri.name\/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:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/author\/wp_blogadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/posts\/1787"}],"collection":[{"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/comments?post=1787"}],"version-history":[{"count":0,"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/posts\/1787\/revisions"}],"wp:attachment":[{"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/media?parent=1787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/categories?post=1787"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ec2-52-29-166-97.eu-central-1.compute.amazonaws.com\/myblog\/wp-json\/wp\/v2\/tags?post=1787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}