{"id":151,"date":"2012-08-09T17:39:32","date_gmt":"2012-08-09T15:39:32","guid":{"rendered":"http:\/\/workplace.skyworker.de\/?p=151"},"modified":"2023-08-22T10:39:23","modified_gmt":"2023-08-22T08:39:23","slug":"powershell-auswertung-von-empirum-installationsauftraegen-fuer-einen-bestimmten-zeitraum-eines-rechners-oder-rechnergruppe","status":"publish","type":"post","link":"http:\/\/workplace.skyworker.de\/?p=151","title":{"rendered":"Powershell: Auswertung von Empirum Installationsauftr\u00e4gen f\u00fcr einen bestimmten Zeitraum eines Rechners, oder Rechnergruppe"},"content":{"rendered":"
\r\n
\r\n \r\n <\/i>\r\n <\/a>\r\n 0 <\/span>\r\n<\/div>
\r\n \r\n <\/i>\r\n <\/a>\r\n 0<\/span>\r\n<\/div><\/div>

Im Kundenumfeld gab und gibt es oft die Anforderung, das man f\u00fcr einen Rechner, oder eine Rechnergruppe die \u00fcber Empirum durchgef\u00fchrten Installationen f\u00fcr einen Zeitraum x ermitteln soll, oder muss.<\/p>\n

Hierf\u00fcr habe ich ein Skript geschrieben welches die Paketinstallationen eines Rechners, oder einer Rechnergruppe f\u00fcr einen bestimmten Zeitraum auswertet. Dabei werden die Daten aus der Empirum Datenbank gelesen und in einem Excel Sheet aufbereitet zur Verf\u00fcgung gestellt.<\/p>\n

Die Steuerung findet \u00fcber eine GUI statt.
\n\"ps_auswertung_01\"<\/a><\/p>\n

Bei der Auswertung werden die Benutzerteile eines Empirum Paketes herausgefiltert, so das nur die eigentlichen Paketinstallation \u00fcbrig bleiben.<\/p>\n

\"ps_auswertung_02\"<\/a><\/p>\n

\"Actions-help-about-icon\"<\/a> Tipp<\/strong><\/span>: \u00dcber die exclusion.ini k\u00f6nnen Pakete hinterlegt werden, die nicht in die Auswertung mit einbezogen werden sollen. Ebenfalls k\u00f6nnen die PatchInstallationen exkludiert werden.<\/p><\/blockquote>\n

Hinweis: <\/strong>Im PowerShell Skript muss noch entsprechend der Datenbankserver und die Datenbank der Umgebung angepasst werden!<\/em><\/p>\n

Powershell Skript:\u00a0\u00a0 [ddownload id=163]<\/p>\n

[php]#—–Auslesen des Skriptpfad———————————————–
\nfunction Get-ScriptDirectory {
\n$Invocation = (Get-Variable MyInvocation -Scope 1).Value
\nSplit-Path $Invocation.MyCommand.Path
\n}
\n#—————————————————————————<\/p>\n

#—–Variablen————————————————————-
\n$global:cc_single_output = ""
\n$global:cc_multi_output = ""
\n$global:DataSet = ""
\n$cc_input_pcname = ""
\n$cc_input_datemin = ""
\n$cc_input_datemax = ""
\n$cc_input_customname = ""
\n$cc_input_checkpatches = "no"
\n$cc_input_checkexc = "no"
\n$cc_exclusion_file = Join-Path (Get-ScriptDirectory) exclusion.ini;
\n#—————————————————————————<\/p>\n

#—–GUI——————————————————————-
\n[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
\n[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")<\/p>\n

$objForm = New-Object System.Windows.Forms.Form
\n$objForm.Text = "Empirum Auswertungs-Tool"
\n$objForm.Size = New-Object System.Drawing.Size(600,280)
\n$objForm.StartPosition = "CenterScreen"<\/p>\n

$objForm.KeyPreview = $True
\n$objForm.Add_KeyDown({if ($_.KeyCode -eq "Enter")
\n{$x=$objTextBox.Text;$objForm.Close()}})
\n$objForm.Add_KeyDown({if ($_.KeyCode -eq "Escape")
\n{$objForm.Close()}})<\/p>\n

$OKButton = New-Object System.Windows.Forms.Button
\n$OKButton.Location = New-Object System.Drawing.Size(200,210)
\n$OKButton.Size = New-Object System.Drawing.Size(75,23)
\n$OKButton.Text = "OK"
\n$OKButton.Add_Click({$cc_input_customname=$objTextBox_Fname.Text; $cc_input_pcname=$objTextBox_PCName.Text;$cc_input_datemin=$objTextBox_startdate.Text;$cc_input_datemax=$objTextBox_enddate.Text;$objForm.Close()})
\n$objForm.Controls.Add($OKButton)<\/p>\n

$CancelButton = New-Object System.Windows.Forms.Button
\n$CancelButton.Location = New-Object System.Drawing.Size(320,210)
\n$CancelButton.Size = New-Object System.Drawing.Size(75,23)
\n$CancelButton.Text = "Cancel"
\n$CancelButton.Add_Click({$objForm.Close()})
\n$objForm.Controls.Add($CancelButton)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,20)
\n$objLabel.Size = New-Object System.Drawing.Size(400,20)
\n$objLabel.Text = "PC Name\/n: (Mehrere PCs mit Semikolon trennen >> vm9900111;vm9900112)"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objTextBox_PCName = New-Object System.Windows.Forms.TextBox
\n$objTextBox_PCName.Location = New-Object System.Drawing.Size(10,40)
\n$objTextBox_PCName.Size = New-Object System.Drawing.Size(400,20)
\n$objForm.Controls.Add($objTextBox_PCName)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,70)
\n$objLabel.Size = New-Object System.Drawing.Size(120,20)
\n$FontBold = new-object System.Drawing.Font("Arial",8,[Drawing.FontStyle]’Bold‘ )
\n$objLabel.Font = $fontBold
\n$objLabel.Text = "Auswertungszeitraum"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,90)
\n$objLabel.Size = New-Object System.Drawing.Size(160,20)
\n$objLabel.Text = "Anfangsdatum (dd.mm.yyyy):"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objTextBox_startdate = New-Object System.Windows.Forms.TextBox
\n$objTextBox_startdate.Location = New-Object System.Drawing.Size(170,90)
\n$objTextBox_startdate.Size = New-Object System.Drawing.Size(100,20)
\n$objForm.Controls.Add($objTextBox_startdate)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(290,90)
\n$objLabel.Size = New-Object System.Drawing.Size(130,20)
\n$objLabel.Text = "Enddatum (dd.mm.yyyy):"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objTextBox_Enddate = New-Object System.Windows.Forms.TextBox
\n$objTextBox_Enddate.Location = New-Object System.Drawing.Size(430,90)
\n$objTextBox_Enddate.Size = New-Object System.Drawing.Size(100,20)
\n$objForm.Controls.Add($objTextBox_Enddate)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,120)
\n$objLabel.Size = New-Object System.Drawing.Size(150,20)
\n$FontBold = new-object System.Drawing.Font("Arial",8,[Drawing.FontStyle]’Bold‘ )
\n$objLabel.Font = $fontBold
\n$objLabel.Text = "Dateiname:"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objTextBox_Fname = New-Object System.Windows.Forms.TextBox
\n$objTextBox_Fname.Location = New-Object System.Drawing.Size(170,120)
\n$objTextBox_Fname.Size = New-Object System.Drawing.Size(100,20)
\n$objForm.Controls.Add($objTextBox_Fname)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(270,124)
\n$objLabel.Size = New-Object System.Drawing.Size(180,20)
\n$objLabel.Text = "_01.01.2012_01.04.2012.xlsx"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,150)
\n$objLabel.Size = New-Object System.Drawing.Size(280,20)
\n$objLabel.Text = "MS Patche in die Auswertung mit einbeziehen"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$Checkbox = new-object System.Windows.Forms.Checkbox
\n$Checkbox.Location = new-object System.Drawing.Size(290,150)
\n$Checkbox.size = new-object System.Drawing.Size(20,20)
\n$objForm.Controls.Add($Checkbox)<\/p>\n

$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,170)
\n$objLabel.Size = New-Object System.Drawing.Size(280,20)
\n$objLabel.Text = "Paketausschl\u00fcsse in die Auswertung mit einbeziehen"
\n$objForm.Controls.Add($objLabel)<\/p>\n

$CheckboxExc = new-object System.Windows.Forms.Checkbox
\n$CheckboxExc.Location = new-object System.Drawing.Size(290,170)
\n$CheckboxExc.size = new-object System.Drawing.Size(20,20)
\n$objForm.Controls.Add($CheckboxExc)<\/p>\n

# Auswertung der Checkbox
\n$Checkbox.add_CheckStateChanged({
\nIf ($Checkbox.CheckState -eq "unchecked" )
\n{$cc_input_checkpatches = "no"}
\nElse
\n{$cc_input_checkpatches = "yes"}
\n})<\/p>\n

# Auswertung der CheckboxExc
\n$CheckboxExc.add_CheckStateChanged({
\nIf ($CheckboxExc.CheckState -eq "unchecked" )
\n{$cc_input_checkexc = "no"}
\nElse
\n{$cc_input_checkexc = "yes"}
\n})<\/p>\n

$objForm.Topmost = $True<\/p>\n

$objForm.Add_Shown({$objForm.Activate()})
\n[void] $objForm.ShowDialog()<\/p>\n

#$cc_input_pcname = "vm8700133"
\n#$cc_input_datemin = "20.03.2012"
\n#$cc_input_datemax = "24.04.2012"<\/p>\n

If ($cc_input_pcname -eq "" -and $cc_input_datemin -eq "" -and $cc_input_datemax -eq "" -and $cc_input_customname -eq ""){
\nExit
\n}<\/p>\n

If ($cc_input_pcname -eq ""){
\n$wshshell = new-object -comobject wscript.shell
\n$Answer = $wshshell.popup("Es wurde kein PC Name angegeben. Die Auswertung wird abgebrochen!",30,"Fehler",16)
\nExit
\n}<\/p>\n

If ($cc_input_datemin -eq ""){
\n$wshshell = new-object -comobject wscript.shell
\n$Answer = $wshshell.popup("Es wurde kein Startdatum angegeben. Die Auswertung wird abgebrochen!",30,"Fehler",16)
\nExit
\n}<\/p>\n

If ($cc_input_datemax -eq ""){
\n$wshshell = new-object -comobject wscript.shell
\n$Answer = $wshshell.popup("Es wurde kein Enddatum angegeben. Die Auswertung wird abgebrochen!",30,"Fehler",16)
\nExit
\n}<\/p>\n

If ($cc_input_customname -eq ""){
\n$wshshell = new-object -comobject wscript.shell
\n$Answer = $wshshell.popup("Es wurde kein Dateiname angegeben. Die Auswertung wird abgebrochen!",30,"Fehler",16)
\nExit
\n}<\/p>\n

$cc_input_pcname_split = $cc_input_pcname.split(";")<\/p>\n

$cc_datum_date_min = get-date ($cc_input_datemin)
\n$cc_datum_date_max = get-date ($cc_input_datemax)
\n##Da der aktuelle Tag im Max wert nicht ber\u00fccksichtigt wird
\n$cc_datum_date_max = $cc_datum_date_max.AddDays(1)<\/p>\n

#—–Einlesen der ini Datei f\u00fcr die Paketausschl\u00fcsse——————
\nIf ($cc_input_checkexc -eq "yes"){
\nIf (test-path $cc_exclusion_file) {
\n$cc_input_exclusion = Get-Content $cc_exclusion_file
\n}
\nElse {
\n$wshshell = new-object -comobject wscript.shell
\n$Answer = $wshshell.popup("Ausschlussdatei exclusion.ini existiert nicht im Skriptverzeichnis. Die Auswertung wird abgebrochen!",30,"Fehler",16)
\nExit
\n}
\n}
\n#———————————————————————-<\/p>\n

#—–Erstellen eines xlsx————————————————–
\n$Excel = New-Object -ComObject excel.application
\n$Excel.visible = $false
\n$workbook = $Excel.workbooks.add()<\/p>\n

$excel.cells.item(1,1) = "PC-Systeme"
\n$excel.cells.item(1,2) = "$cc_input_pcname"<\/p>\n

$excel.cells.item(3,1) = "Zeitraum"
\n$excel.cells.item(3,2) = "$cc_input_datemin bis $cc_input_datemax"<\/p>\n

$excel.cells.item(5,1) = "Anzahl an Auftr\u00e4gen"
\n$excel.cells.item(5,3) = "Benutzerteile ausgeschlossen!"<\/p>\n

$excel.cells.item(7,1) = "Nr."
\n$excel.cells.item(7,2) = "Datum"
\n$excel.cells.item(7,3) = "PC Name"
\n$excel.cells.item(7,4) = "Software"
\n$excel.cells.item(7,5) = "Installationsmodus"
\n$excel.cells.item(7,6) = "Ergebnis"<\/p>\n

$excel.cells.item(1,1).Font.Bold = $True
\n$excel.cells.item(3,1).Font.Bold = $True
\n$excel.cells.item(5,1).Font.Bold = $True
\n$excel.cells.item(7,1).Font.Bold = $True
\n$excel.cells.item(7,2).Font.Bold = $True
\n$excel.cells.item(7,3).Font.Bold = $True
\n$excel.cells.item(7,4).Font.Bold = $True
\n$excel.cells.item(7,5).Font.Bold = $True
\n$excel.cells.item(7,6).Font.Bold = $True
\n$excel.cells.item(5,3).Font.Italic = $True<\/p>\n

$excel.cells.item(1,2).Interior.ColorIndex = 37
\n$excel.cells.item(3,2).Interior.ColorIndex = 37
\n$excel.cells.item(5,2).Interior.ColorIndex = 37
\n$excel.cells.item(7,1).Interior.ColorIndex = 37
\n$excel.cells.item(7,2).Interior.ColorIndex = 37
\n$excel.cells.item(7,3).Interior.ColorIndex = 37
\n$excel.cells.item(7,4).Interior.ColorIndex = 37
\n$excel.cells.item(7,5).Interior.ColorIndex = 37
\n$excel.cells.item(7,6).Interior.ColorIndex = 37<\/p>\n

#—————————————————————————<\/p>\n

#—-Datenbankzugriff \/ Auslesen der Pakete \/ Ablage in Datei–
\nfunction execute-sql-multi-output {
\nparam (
\n[string]$dbserver,
\n[string]$db,
\n[string]$SQLCommand
\n)<\/p>\n

#Connection to SQL-Server
\n$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
\n$SqlConnection.ConnectionString = "Server = $dbserver; Database = $db; Integrated Security = True"<\/p>\n

$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
\n$SqlCmd.CommandText = $SQLCommand
\n$SqlCmd.Connection = $SqlConnection<\/p>\n

$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
\n$SqlAdapter.SelectCommand = $SqlCmd<\/p>\n

$global:cc_multi_output = New-Object System.Data.DataSet
\n$SqlAdapter.Fill($global:cc_multi_output)
\n$SqlConnection.Close()
\n}
\n#————————————————————–
\n#—————————————————————————<\/p>\n

$excel_line = 8
\nforeach ($cc_pcname in $cc_input_pcname_split){
\n#—–Ausf\u00fchren der Funktion zur Abfrage der Client ID———————-
\n$cc_output_count = execute-sql-multi-output "empirumpro" "empirumdb" "SELECT client_id FROM Clients where name = ‚$cc_pcname’"
\n$h = 0
\n$cc_clientid = ""
\nforeach ($entry in $global:cc_multi_output.Tables[0]){
\n$cc_clientid = $global:cc_multi_output.Tables[0].Rows[$h][0]
\n$h++
\n}<\/p>\n

#Wenn der Name nicht gefunden wird, wird ein break ausgef\u00fchrt
\nIf ($cc_clientid -eq ""){
\ncls
\n#Ausgabetext
\nwrite-host ""
\nwrite-host "——————————————————————————–"
\nwrite-host "\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Bitte warten…"
\nwrite-host "——————————————————————————–"
\nwrite-host ""
\nwrite-host "PC " $cc_pcname " wurde in der Datenbank nicht gefunden"
\nstart-sleep -s 4
\nBreak
\n}
\n#—————————————————————————<\/p>\n

#—–Ausf\u00fchren der Funktion zur Abfrage der Auftr\u00e4ge des entsprechenden Clients–
\n$cc_output_count = execute-sql-multi-output "empirumpro" "empirumdb" "SELECT * FROM ArchiveDistJobs where ClientID = ‚$cc_clientid’"
\n$i = 0
\nforeach ($entry in $global:cc_multi_output.Tables[0]){
\n$cc_clickdown = 0
\ncls<\/p>\n

#Formatierung der R\u00fcckgabewerte
\n$cc_datum = $global:cc_multi_output.Tables[0].Rows[$i][1]
\n$cc_software = $global:cc_multi_output.Tables[0].Rows[$i][7]
\n$cc_mode = $global:cc_multi_output.Tables[0].Rows[$i][11]
\n$cc_result = $global:cc_multi_output.Tables[0].Rows[$i][12]<\/p>\n

$cc_datum_str = [STRING]$cc_datum
\n$cc_datum_dd = "{0:dd.MM.yyyy}" -f [datetime]$cc_datum
\n$cc_software_str = [STRING]$cc_software
\n$cc_mode_str = [STRING]$cc_mode
\n$cc_result_str = [STRING]$cc_result
\n$cc_datum_date = get-date ($cc_datum)<\/p>\n

#Ausgabetext
\nwrite-host ""
\nwrite-host "——————————————————————————–"
\nwrite-host "\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Bitte warten…"
\nwrite-host "——————————————————————————–"
\nwrite-host ""
\nwrite-host "\u00dcberpr\u00fcfung der Softwareauftr\u00e4ge in der Datenbank f\u00fcr PC " $cc_pcname ": " $i
\nwrite-host $cc_software_str<\/p>\n

If ($cc_datum_date -gt $cc_datum_date_min){
\nIf ($cc_datum_date -le $cc_datum_date_max){
\nIf ($cc_mode -match "User") {$cc_clickdown = 1}
\nIf ($cc_input_checkpatches -eq "no") {
\nIf ($cc_software_str -match "Security Update for" -or $cc_software_str -match "Update for Windows" -or $cc_software_str -match "Cumulative Security Update for" -or $cc_software_str -match "Critical Update for Office" -or $cc_software_str -match "Update for Office" -or $cc_software_str -match "Update for Microsoft" -or $cc_software_str -match "Microsoft Office Compatibility Pack Service" -or $cc_software_str -match "Service Pack 3 for Visio" -or $cc_software_str -match "co-install of .net 3.0 sp" -or $cc_software_str -match "Microsoft .NET Framework 2.0 Service Pack" -or $cc_software_str -match "Microsoft .NET Framework 3.0 Service Pack" -or $cc_software_str -match "Microsoft .NET Framework 3.5 Service Pack" -or $cc_software_str -match "Microsoft .NET Framework 3.5 Family Update" -or $cc_software_str -match "Service Pack 3 for Visio")
\n{$cc_clickdown = 1}
\n}
\nIf ($cc_input_checkexc -eq "yes"){
\nforeach ($cc_exclusion in $cc_input_exclusion) {
\nIf ($cc_exclusion -eq $cc_software_str){$cc_clickdown = 1}
\n}
\n}<\/p>\n

If ($cc_clickdown -eq 0){
\n$cc_nr = $excel_line – 7
\n$excel.cells.item($excel_line,1) = "$cc_nr"
\n$excel.cells.item($excel_line,2) = "$cc_datum_dd"
\n$excel.cells.item($excel_line,3) = "$cc_pcname"
\n$excel.cells.item($excel_line,4) = "$cc_software_str"
\n$excel.cells.item($excel_line,5) = "$cc_mode_str"
\n$excel.cells.item($excel_line,6) = "$cc_result_str"
\n$excel_line++
\n}
\n}
\n}
\n$i++
\n}
\n}
\n#—–Speichern des Excel Files———————————————
\n$cc_filename = "Auswertungen\\" + $cc_input_customname + "_" + $cc_input_datemin + "_" + $cc_input_datemax + ".xlsx"
\n$cc_xlsx_file = Join-Path (Get-ScriptDirectory) $cc_filename;
\n$excel.cells.item(5,2) = "$cc_nr"
\nIf (test-path $cc_xlsx_file) {Remove-Item $cc_xlsx_file}
\n$Excel.Cells.EntireColumn.AutoFit()
\n$workbook.saveas($cc_xlsx_file)
\n$Excel.Quit()
\n#—————————————————————————<\/p>\n

#—–\u00d6ffnen des Excel Sheets———————————————–
\nStart-Process Excel -ArgumentList $cc_xlsx_file
\n#—————————————————————————[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"

0 0 Im Kundenumfeld gab und gibt es oft die Anforderung, das man f\u00fcr einen Rechner, oder eine Rechnergruppe die \u00fcber Empirum durchgef\u00fchrten Installationen f\u00fcr einen Zeitraum x ermitteln soll, oder muss. Hierf\u00fcr habe ich ein Skript geschrieben welches die Paketinstallationen eines Rechners, oder einer Rechnergruppe f\u00fcr einen bestimmten Zeitraum auswertet. Dabei werden die Daten … \u201ePowershell: Auswertung von Empirum Installationsauftr\u00e4gen f\u00fcr einen bestimmten Zeitraum eines Rechners, oder Rechnergruppe\u201c<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":1829,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11,3,38],"tags":[5,9],"_links":{"self":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/151"}],"collection":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=151"}],"version-history":[{"count":14,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":1837,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/151\/revisions\/1837"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/media\/1829"}],"wp:attachment":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}