{"id":5293,"date":"2016-06-23T10:59:18","date_gmt":"2016-06-23T08:59:18","guid":{"rendered":"https:\/\/www.derdack.com\/de\/?p=5293"},"modified":"2016-06-23T10:59:18","modified_gmt":"2016-06-23T08:59:18","slug":"automatisch-maintenance-datenbank-log-files-powershell","status":"publish","type":"post","link":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/","title":{"rendered":"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert"},"content":{"rendered":"

Enterprise Alert generiert im Laufe der Zeit einige Datenbank-Eintr\u00e4ge und Log-Files. Viele\u00a0davon sind sehr hilfreich f\u00fcr Reporting-Zwecke aber nach einer gewissen Zeit wird immer mehr Speicherplatz verbrauche und das System kann dadurch Performance einb\u00fc\u00dfen.<\/p>\n

Es ist daher empfehlenswert historische Datenbank-Eintr\u00e4ge und alte Log-Files von Zeit zu Zeit zu l\u00f6schen. Um dies komfortable zu erm\u00f6glichen, stellt Derdack ein Maintenance Script in PowerShell bereit. Dieses kann manuell oder automatisiert ausgef\u00fchrt werden. Zum Beispiel kann das vom Windows Task Scheduler aus in bestimmten Intervallen (zum Beispiel\u00a0w\u00f6chentlich oder\u00a0monatlich) \u00a0geschehen. Wir empfehlen das Script zu Zeiten mit m\u00f6glichst geringer Last auszuf\u00fchren, da das Script selber die Datenbank zus\u00e4tzlich belastet.<\/p>\n

Am Anfang des Scripts findet sich eine Sektion mit der Konfiguration. Diese kann entsprechend dem jeweiligen Szenario angepasst werden.<\/p>\n

Das PowerShell Script sieht wie folgt aus:
\n<#<\/em>
\nThis script deletes Log messages from Enterprise Alert<\/em>
\nfrom Folders and Tables older than configured in $keeplogdays.<\/em><\/p>\n

To set up this script, please configure settings below in the CONFIGURATION section.<\/em><\/p>\n

Works with Enterprise Alert 2012, 2015, 2016<\/em><\/p>\n

\u00a9 2008-2016 Derdack GmbH, www.derdack.com, Enterprise Alert is a registered trademark of Derdack GmbH<\/em>
\n#><\/em><\/p>\n

# History:<\/em>
\n# 22.06.2015 HF – Delete Version and Logging revised for EA 2015<\/em>
\n# 14.04.2015 HF – Tables added [EmergencyCalloutAlerts], [RemoteActionsHistory], [RemoteJobsHistory]<\/em>
\n# 17.04.2014 HF – Connection String<\/em>
\n# 16.04.2014 HF – add writes Log File<\/em>
\n# 07.04.2014 HF – First Version<\/em><\/p>\n

#requires -version 3<\/em>
\n#endregion – Header<\/em><\/p>\n

#region – Configuration<\/em>
\n#=============================================================================<\/em>
\n#CONFIGURATION<\/em>
\n#=============================================================================<\/em><\/p>\n

# Database connection String<\/em>
\n$dbConnectionString = „Server=sqlserver;Trusted_Connection=No;UID=SA;PWD=Derdack!;Database=EnterpriseAlert;“<\/em>
\n# „Server=localhost\\SQLEXPRESS;Database=MMEA;Trusted_Connection=True;“<\/em><\/p>\n

#keep all logs from the last xx days<\/em>
\n$keeplogdays = „60“<\/em><\/p>\n

#Main log Folder<\/em>
\n$logFolders = @(„C:\\Program Files (x86)\\Enterprise Alert\\Logs“,“C:\\Program Files (x86)\\Enterprise Alert\\ScriptingHost\\Logs“)<\/em><\/p>\n

#Tables to truncate Log Tables (tablename,columnname of time to compare)<\/em>
\n$DBlogTables = @(@(„MMEVENTS“,“MSGTIMESTAMP“) ,@(„EAEvents“,“Timestamp“))<\/em><\/p>\n

#Tables to truncate Message and Tickt Tables<\/em>
\n$DBMsgTables = @(@(„MMINBOUND“,“MSGTIMESTAMP“),@(„MMOUTBOUND“,“MSGTIMESTAMP“),@(„MMTICKETS“,“CREATIONTIME“),@(„MMTICKETMESSAGES“,“SENDINGTIME“),@(„PolicyExecutionJournal“,“Timestamp“), @(„EmergencyCalloutAlerts“,“CreationTime“),@(„EmergencyCalloutInstances“,“LastTimestamp“), @(„RemoteActionsHistory“,“Created“), @(„RemoteJobsHistory“,“CreationTime“))<\/em><\/p>\n

#logMessage for E-mail<\/em>
\n$emailMessage = „Run Log Message“<\/em><\/p>\n

#Name of log File for this Script<\/em>
\n$LogfileNameFQDN = $logFolders[0] + „\\LOG_DELETE\\{0:yyyy-MM-dd}_{1}_{2}.log“ -f (Get-Date),$env:COMPUTERNAME,““<\/em><\/p>\n

#static variables<\/em>
\n$crlf = „`r`n“<\/em><\/p>\n

#endregion – Configuration<\/em><\/p>\n

#region – Function<\/em><\/p>\n

#truncates Tables from MMEA Database<\/em>
\nfunction .runSQL<\/em>
\n{<\/em>
\nparam( [String]$dbConnectionString,<\/em>
\n[String]$SQLStatement<\/em><\/p>\n

)<\/em>
\ntry {<\/em>
\n$conn = New-Object System.Data.SqlClient.SqlConnection<\/em>
\n$conn.ConnectionString = $dbConnectionString<\/em>
\n$conn.Open()<\/em>
\n$emailMessage = $emailMessage + $crlf + „Run SQL “ + $SQLStatement<\/em>
\n$cmd = New-Object System.Data.SqlClient.SqlCommand($SQLStatement,$conn)<\/em>
\n$rdr = $cmd.ExecuteNonQuery()<\/em>
\n$emailMessage = $emailMessage + $crlf + „Run SQL “ + $rdr<\/em><\/p>\n

}<\/em>
\ncatch{<\/em>
\nreturn „Error running: “ + $SQLStatement<\/em>
\n}<\/em>
\nreturn [string]$rdr<\/em>
\n$conn.close()<\/em><\/p>\n

}<\/em><\/p>\n

function .checkTableCount<\/em>
\n{<\/em>
\nparam( [String]$dbConnectionString,<\/em>
\n[String]$SQLStatement<\/em>
\n)<\/em><\/p>\n

#Write-output „IDcounter is: “ $SQLStatement<\/em>
\n$connectionString = $dbConnectionString<\/em><\/p>\n

$connection = New-Object System.Data.SqlClient.SqlConnection<\/em>
\n$connection.ConnectionString = $connectionString<\/em>
\n$connection.Open()<\/em>
\n$command = $connection.CreateCommand()<\/em>
\n$command.CommandText = $SQLStatement<\/em>
\n$ID = $command.ExecuteScalar()<\/em>
\n$connection.Close()<\/em><\/p>\n

return $ID<\/em>
\n}<\/em><\/p>\n

# Thank you goes to: http:\/\/blog.danskingdom.com\/powershell-functions-to-delete-old-files-and-empty-directories\/<\/em><\/p>\n

# Function to remove all empty directories under the given path.<\/em>
\n# If -DeletePathIfEmpty is provided the given Path directory will also be deleted if it is empty.<\/em>
\n# If -OnlyDeleteDirectoriesCreatedBeforeDate is provided, empty folders will only be deleted if they were created before the given date.<\/em>
\n# If -OnlyDeleteDirectoriesNotModifiedAfterDate is provided, empty folders will only be deleted if they have not been written to after the given date.<\/em>
\nfunction Remove-EmptyDirectories([parameter(Mandatory)][ValidateScript({Test-Path $_})][string] $Path, [switch] $DeletePathIfEmpty, [DateTime] $OnlyDeleteDirectoriesCreatedBeforeDate = [DateTime]::MaxValue, [DateTime] $OnlyDeleteDirectoriesNotModifiedAfterDate = [DateTime]::MaxValue)<\/em>
\n{<\/em>
\nGet-ChildItem -Path $Path -Recurse -Force -Directory | Where-Object { (Get-ChildItem -Path $_.FullName -Recurse -Force -File) -eq $null } |<\/em>
\nWhere-Object { $_.CreationTime -lt $OnlyDeleteDirectoriesCreatedBeforeDate -and $_.LastWriteTime -lt $OnlyDeleteDirectoriesNotModifiedAfterDate } |<\/em>
\nRemove-Item -Force -Recurse<\/em><\/p>\n

# If we should delete the given path when it is empty, and it is a directory, and it is empty, and it meets the date requirements, then delete it.<\/em>
\nif ($DeletePathIfEmpty -and (Test-Path -Path $Path -PathType Container) -and (Get-ChildItem -Path $Path -Force) -eq $null -and<\/em>
\n((Get-Item $Path).CreationTime -lt $OnlyDeleteDirectoriesCreatedBeforeDate) -and ((Get-Item $Path).LastWriteTime -lt $OnlyDeleteDirectoriesNotModifiedAfterDate))<\/em>
\n{ Remove-Item -Path $Path -Force }<\/em>
\n}<\/em><\/p>\n

# Thank you goes to: http:\/\/blog.danskingdom.com\/powershell-functions-to-delete-old-files-and-empty-directories\/<\/em>
\n# Function to remove all files in the given Path that were created before the given date, as well as any empty directories that may be left behind.<\/em>
\nfunction Remove-FilesCreatedBeforeDate([parameter(Mandatory)][ValidateScript({Test-Path $_})][string] $Path, [parameter(Mandatory)][DateTime] $DateTime, [switch] $DeletePathIfEmpty)<\/em>
\n{<\/em>
\nGet-ChildItem -Path $Path -Recurse -Force -File | Where-Object { $_.CreationTime -lt $DateTime } | Remove-Item -Force<\/em>
\nRemove-EmptyDirectories -Path $Path -DeletePathIfEmpty:$DeletePathIfEmpty -OnlyDeleteDirectoriesCreatedBeforeDate $DateTime<\/em>
\n}<\/em><\/p>\n

# Funktion send a E-mail to the SMTP Server<\/em>
\nfunction sendSmtpMail<\/em>
\n{<\/em>
\nparam( [String]$Smtpserver,<\/em>
\n[String]$MessageBody<\/em>
\n)<\/em><\/p>\n

$from = „mmea-check-{0}@XXX.net“ -f $env:COMPUTERNAME<\/em>
\n$to = „mmea-smtp-check@XXX.net“<\/em>
\n$Subject = „MMEA-SMTPCHECK-{0}“ -f $env:COMPUTERNAME<\/em>
\n$Body = $MessageBody<\/em>
\nSend-MailMessage -From $from -To $to -SmtpServer $Smtpserver -Body $Body -Subject $Subject -ErrorAction SilentlyContinue<\/em>
\n#return $?,$null<\/em><\/p>\n

}<\/em><\/p>\n

# Function writes a Log File<\/em>
\nfunction writeLogFile<\/em>
\n{<\/em>
\nparam(<\/em>
\n[String]$Message,<\/em>
\n[String]$LogfileName<\/em>
\n)<\/em><\/p>\n

if ((Test-Path $LogfileName) -eq $false)<\/em>
\n{<\/em>
\nNew-Item $LogfileName -ItemType file -Force | Out-Null<\/em>
\n}<\/em>
\n$Message | Out-File $LogfileName -Append<\/em><\/p>\n

}<\/em><\/p>\n

function .deleteDBLogEntries{<\/em>
\nparam(<\/em>
\n$DBTables<\/em>
\n)<\/em><\/p>\n

# Delete all DB Logs<\/em>
\nforeach ($Tables in $DBTables) {<\/em><\/p>\n

#getlast ID<\/em>
\n$IDcounter = 100<\/em>
\n$Iterations = 0<\/em>
\n#Write-output „IDcounter Start is: “ $IDcounter<\/em>
\nwhile ($IDcounter -ne 0) {<\/em>
\n$sqlstaementCounter = „Select Top(1000) CAST(id as int) as lastID FROM “ + $Tables[0] +“ WHERE DATEDIFF(dd,“ + $Tables[1] + “ , GETDATE()) >= „+ $keeplogdays + “ order by ID desc“<\/em>
\n$LastID = .checkTableCount -dbConnectionString $dbConnectionString -SQLStatement $sqlstaementCounter<\/em><\/p>\n

if ($LastID -le 0 ){<\/em>
\n$IDcounter = 0<\/em>
\nbreak<\/em>
\n}<\/em>
\n#now delete first part<\/em>
\n$sqlstaement = „DELETE top(1000) FROM “ + $Tables[0] + “ WHERE ID < “ + $LastID<\/em>
\n$Iterations = $Iterations + 1<\/em>
\n$Success = (.runSQL -dbConnectionString $dbConnectionString -SQLStatement $sqlstaement)<\/em><\/p>\n

$RestNumbersStaetment = „Select CAST(count(id) as int) as Maxnumbers FROM “ + $Tables[0] + “ WHERE ID < “ + $LastID<\/em>
\n$IDcounter = .checkTableCount -dbConnectionString $dbConnectionString -SQLStatement $RestNumbersStaetment<\/em><\/p>\n

}<\/em>
\n$Message = $Message + $crlf + „Cleanup for: “ + $Tables[0] + “ Iterations: “ + $Iterations<\/em>
\n}<\/em>
\nreturn $Message<\/em>
\n}<\/em><\/p>\n

#endregion – Function<\/em><\/p>\n

#region – Main<\/em>
\n$emailMessage = „Start “ + (Get-Date)<\/em>
\n$emailMessage = $emailMessage + $crlf + „Cleanup Days from “ + ((Get-Date).AddDays(-$keeplogdays))<\/em><\/p>\n

# Delete all files<\/em>
\nforeach ($logFolder in $logFolders) {<\/em>
\n$emailMessage = $emailMessage + $crlf + „Cleanup “ + $logFolder<\/em>
\nRemove-FilesCreatedBeforeDate -Path $logFolder -DateTime ((Get-Date).AddDays(-$keeplogdays)) -DeletePathIfEmpty<\/em><\/p>\n

}<\/em><\/p>\n

# Delete all DB Logs<\/em>
\n$emailMessage = $emailMessage + $crlf + [string](.deleteDBLogEntries -DBTables $DBlogTables)<\/em>
\n$emailMessage = $emailMessage + $crlf + [string](.deleteDBLogEntries -DBTables $DBMsgTables)<\/em><\/p>\n

$emailMessage = $emailMessage + $crlf + „Log End “ + (Get-Date)<\/em>
\n#sendSmtpMail -Smtpserver $env:COMPUTERNAME + -MessageBody $emailMessage<\/em>
\nwriteLogFile -Message $emailMessage -LogfileName $LogfileNameFQDN<\/em><\/p>\n

#endregion – Main<\/em><\/p>\n

<\/div>","protected":false},"excerpt":{"rendered":"

Enterprise Alert generiert im Laufe der Zeit einige Datenbank-Eintr\u00e4ge und Log-Files. Viele\u00a0davon sind sehr hilfreich f\u00fcr Reporting-Zwecke aber nach einer gewissen Zeit wird immer mehr Speicherplatz verbrauche und das System kann dadurch Performance einb\u00fc\u00dfen. Es ist daher empfehlenswert historische Datenbank-Eintr\u00e4ge und alte Log-Files von Zeit zu Zeit zu l\u00f6schen. Um dies komfortable zu erm\u00f6glichen, stellt<\/p>\n

Continue Reading<\/i><\/a><\/p>\n","protected":false},"author":11,"featured_media":5294,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[478,479,477,274,480],"yoast_head":"\nAutomatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert<\/title>\n<meta name=\"description\" content=\"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert\" \/>\n<meta property=\"og:description\" content=\"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"Derdack DE\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/derdack?ref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-23T08:59:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"311\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@derdack\" \/>\n<meta name=\"twitter:site\" content=\"@derdack\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"ronald\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.derdack.com\/de\/#website\",\"url\":\"https:\/\/www.derdack.com\/de\/\",\"name\":\"Derdack DE\",\"description\":\"Alarmierung und mobile St\u00f6rfallreaktion f\u00fcr kritische Systeme\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.derdack.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de-DE\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#primaryimage\",\"url\":\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg\",\"contentUrl\":\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg\",\"width\":600,\"height\":311,\"caption\":\"Man in headphones with a laptop\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#webpage\",\"url\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/\",\"name\":\"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert\",\"isPartOf\":{\"@id\":\"https:\/\/www.derdack.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#primaryimage\"},\"datePublished\":\"2016-06-23T08:59:18+00:00\",\"dateModified\":\"2016-06-23T08:59:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123\"},\"description\":\"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.derdack.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123\",\"name\":\"ronald\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g\",\"caption\":\"ronald\"},\"url\":\"https:\/\/www.derdack.com\/de\/author\/ronald\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert","description":"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.","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:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/","og_locale":"de_DE","og_type":"article","og_title":"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert","og_description":"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.","og_url":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/","og_site_name":"Derdack DE","article_publisher":"https:\/\/www.facebook.com\/derdack?ref=ts","article_published_time":"2016-06-23T08:59:18+00:00","og_image":[{"width":600,"height":311,"url":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg","type":"image\/jpeg"}],"twitter_card":"summary","twitter_creator":"@derdack","twitter_site":"@derdack","twitter_misc":{"Verfasst von":"ronald","Gesch\u00e4tzte Lesezeit":"5 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.derdack.com\/de\/#website","url":"https:\/\/www.derdack.com\/de\/","name":"Derdack DE","description":"Alarmierung und mobile St\u00f6rfallreaktion f\u00fcr kritische Systeme","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.derdack.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de-DE"},{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#primaryimage","url":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg","contentUrl":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/06\/Smiling-man.jpg","width":600,"height":311,"caption":"Man in headphones with a laptop"},{"@type":"WebPage","@id":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#webpage","url":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/","name":"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert","isPartOf":{"@id":"https:\/\/www.derdack.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#primaryimage"},"datePublished":"2016-06-23T08:59:18+00:00","dateModified":"2016-06-23T08:59:18+00:00","author":{"@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123"},"description":"Maintenance - Automatischen L\u00f6schen von historischen Datenbank-Eintr\u00e4gen und alten Log-Files in Enterprise Alert mit einem einfachen PowerShell Script.","breadcrumb":{"@id":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.derdack.com\/de\/automatisch-maintenance-datenbank-log-files-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.derdack.com\/de\/"},{"@type":"ListItem","position":2,"name":"Automatische Maintenance f\u00fcr Datenbank und Log-Files von Enterprise Alert"}]},{"@type":"Person","@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123","name":"ronald","image":{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g","caption":"ronald"},"url":"https:\/\/www.derdack.com\/de\/author\/ronald\/"}]}},"_links":{"self":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/5293"}],"collection":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/comments?post=5293"}],"version-history":[{"count":3,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/5293\/revisions"}],"predecessor-version":[{"id":5297,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/5293\/revisions\/5297"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/media\/5294"}],"wp:attachment":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/media?parent=5293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/categories?post=5293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/tags?post=5293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}