Tag Archives: powershell

Parse IIS logs with powershell

Posted on December 24, 2021 by erictummers

With the log4j CVE we’re checking our IIS logs in detail. To automate this we’ve created a powershell script that parses the logs and provides query access. Below a script that searches for 502 responses and prints the fields we … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Lift and shift SSIS package

Posted on October 15, 2020 by erictummers

We use Sql Server Integration Services (SSIS) to import text files into our database. The dtsx files are deployed into the MSDB on the Sql Server. Everything works well with deployment with a powershell DSC script. But times change and … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Webdeploy connectionstrings to xTokenize

Posted on July 10, 2020 by erictummers

We have an asp.net webapplication (full framework) and deploy it using release manager. The bits are in an artifact that is created during build with the contents of the webdeploy zip and a powershell desired state configuration (dsc) script to … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Update SEQ with Powershell DSC

Posted on February 17, 2020 by erictummers

We user Powershell Desired State Configuration (DSC) to install everything. A new installation could be done to a clean machine or by removing existing software prior to installing it. Below is part of the script we use. Now we want … Continue reading →

Posted in Development, Tooling | Tagged , , , | Leave a comment

Invoke-Webrequest UnauthorizedAccessException

Posted on February 20, 2019 by erictummers

Today I got an UnauthorizedAccessException when running the following script in powershell There was no logging on the webserver, there was no access-denied message, there was no traffic at all. What happend? Turns out the problem was the file (data.json) … Continue reading →

Posted in Development | Tagged | Leave a comment