by skufel | Mar 14, 2016 | Automation, Databases, Infrastructure, Scripting, SysAdmin, Windows
Code snippet from old archives. It shows how to import Windows event log entries to database. Important is to setup database and table accordingly, so it contains apropriate columns. Set objConn = CreateObject("ADODB.Connection") Set...
by skufel | Sep 11, 2015 | Infrastructure, Scripting, SysAdmin, Windows
To remove Event Log Source use this: Remove-EventLog -Source "Desktop Window Manager" Replace Desktop Window Manager with Event Log Source you want to...
by skufel | Sep 11, 2015 | Automation, Infrastructure, Scripting, SysAdmin, Windows
To list all Event Logs and sources associated with them use: Get-EventLog -LogName * |ForEach-Object {$LogName = $_.Log;Get-EventLog -LogName $LogName -ErrorAction SilentlyContinue |Select-Object @{Name= "Log Name";Expression = {$LogName}}, Source...
by skufel | Sep 7, 2015 | HA/DR, Infrastructure, Linux, Network, SysAdmin, Web Servers
Many times there is a need to publish multiple websites from internal network, but there is only one public IP address available. How this can be done easy way? HAProxy can help us with it. In example configuration I have 2 URLs registered to same public IP address:...
by skufel | Aug 4, 2015 | Automation, Infrastructure, Network, Scripting, SysAdmin, Web Servers
If you need to watch IIS application pool and start it once goes down and want to use PowerShell for that here is simple script for that. Script includes also logging all restarts in log file which is created in same folder as script. # AppPool to monitor $AppPoolName...
by skufel | Jul 26, 2015 | Development, SysAdmin, Windows
Many times you think how to extract some information from memory.dmp generated by Windows once it crashes. Let’s have a look into quick process, which might be very helpful in many cases during troubleshooting unexpected BSODs on client computers. Before we...
