Monday, April 15, 2019

Python Selenium OTRS scraper

Python script to get CMDB entries from OTRS

Another way to do this would be to install the library functions but OTRS system management skills would be required

https://github.com/OTRS/ImportExport

So I have created a quick routine to scrape the data out.

OTRS-Web-Scraper-Clean.py

Friday, January 11, 2019

Awk script to reformat dates in text files.

Script to format a date from MM/DD/YYYY to YYYY-MM-DD



Used to reformat the date from here to make the lessons easier
https://docs.microsoft.com/en-us/sql/integration-services/lesson-1-create-a-project-and-basic-package-with-ssis?view=sql-server-2017

date-format2.sh