Tag Archives: powershell

Parse IIS logs with powershell

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

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

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

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

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