Create, insert, and Query SQLite with PowerShell.

So I have C# code that grabs the print records from the Windows event logs on the print servers in order to create reports and easy searches from my web environment. I dump this data into a SQLite database, because I am a control freak and the place where I work is also a control […]

Collect user logons from Windows 10 with Python 3.

This is basically how I collect physical user logons along with reboots, etc. I dump this shit into a database and deliver via a web-page so folks can do dated searches by workstation or user ID. Works beautifully. You will need the Win32api libraries. I am running this on a Win 2019 server from Python3.7, […]

Get all installed software on Windows 10 with Python 3 and WMI.

This is very basic and I’d lie if I said I hadn’t tried looping through the registry for 64/32 bit, but this works great and isn’t missing entries. I deliver this in a web page making it easy to do look ups on most machines in my org. Tweak as you need, add some error […]

List of Linux IDEs with GUI designers.

If you are looking to develop GUI applications on Linux but don’t really want the tediousness of hand coding the interface, below are a few options with WYSIWYG ability. Many of these tools also run on Windows and/or Mac and can compile for all three platforms.

Execute PowerShell from Python

I originally wrote this to execute PowerShell scripts from a Flask web interface. You can now install Powershell on Linux. Crazy, ain’t it?

List or search all installed apps on Ubuntu 18.04 with Python.

I was bored… Of course this can be done easily in the terminal, but what’s the fun in that? This should work on any flavor of Debian/Ubuntu. import os import subprocess as sp ”’ Pipe to file in terminal: $ flatpak list –app –show-details > ~/Documents/installed-flatpack.log $ dpkg –get-selections > ~/Documents/installed-software.log Not using Debian? Here’s […]

Extract CAB files with Python and Patool.

Install 7zip. This assumes you are on Windows. Add the 7zip path to the system path. In the searchbar type env and open the result. Click Environment Variables in the dialog. Add to PATH. Windows 10 just click add and browse to the folder 7zip installed to, i.e., C:\Program Files\7-zip. Otherwise, paste the path making […]

Python3 Gtk3 Thread Example

Quick Python3 Gtk3 app to execute Python scripts to test long running threads in Gtk3 app. Some things could be better, like the python paths collection and displaying the PID, but I was focused on running threads without freezing the GUI and it just kind of happened. Hope it’s useful to someone.