Category: Programming
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.
Get keywords from YouTube video meta tag.
My wife was wanting to see the meta tags embedded in YouTube videos so I whipped up this quick Python script.
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 […]
Review or Delete Duplicate Files with Python.
My music and photos were getting out of hand. Thought I would share.
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.