Information Technology Grimoire
Version .0.0.1
IT Notes from various projects because I forget, and hopefully they help you too.
Home
Contact
About
Donate
Contribute
Book Appointment
SQLite
Articles, Tips, Tricks in the SQLite Category:
create table
delete record
import/export
modify table
Last updated on 10 Jan 2024
Published on 10 Jan 2024
Prev - Database
Next - create table
Home
AI
+
AI Create Custom GPT
AI Process Multiple Documents
Fabric Open Source GPT
openAI Personality Bot
Python AWS Polly SSML FFMPEG
Cloud
+
Azure
AWS
+
EC2 Backup/Restore
How to Set Up Free Amazon VPS (EC2)
GCP
Data
+
Base Converter
Check Sums
Deduplicate
Left Strip
List Compare
Mime Types
Database
-
SQLite
+
create table
delete record
import/export
modify table
MySQL
+
msyqldump
DLP
+
How to Delete the Hiberfile.sys in Windows 10
Bluecoat
+
pcap
Forcepoint
+
forcepoint API port
DNS
+
Change Registrars
DKIM
DMARC
DNS Cache
DNS Fuzzer
DNS Investigation
DNS Record Types
DNSSEC
Resolve DNS Records
Route 53
Slow Test
SPF
Troubleshooting
Encryption
+
Ciphers
+
XOR Cipher
x509
+
certutil
Expired Certificates
Get-CRL
x509 Conversions
x509 Details
Firewalls
+
Fortinet
+
Fortinet Layer by Layer Cheat Sheet
Fortinet Network Troubleshooting
Fortinet System CLI Cheat Sheet
Fortinet VPN Troubleshooting
Cisco ASA
+
show log
ASA Cheat Sheet
iptables
+
iptables automated blacklist threat intel
Fail2Ban Ubuntu 22.04
ufw
+
UFW Tutorial for Ubuntu
Check Point
+
How to Troubleshoot SIC on Check Point Firewall
API Scripting
backups
Bash Scripting
cheatsheet
Check Point Hardware
Check Point Ports
clusterxl
corexl
cpinfo
dbset crontab
disk space logs
fw monitor
fwaccel dos
hotfix install
log export
mgmt_cli export
ntp
old file backup
packet-flow
py log parser
rule export
shells
snmp VPN
standard services
vpn debugging
vpn tu
Check Point Maestro
+
arp
asg diag
asg if
asg monitor
asg perf
asg resource
asg search
asg stat
asg_conns
asg_ifconfig
asg_igmp
asg_mroute
asg_perf_hogs
asg_pim
asg_route
config backup
drop_monitor
interfaces
mac madness
osi troubleshooting
show smo verifiers
smo policies
sx_api_ports_dump.py
Check Point VSX
+
cphaprob show_bond
show virtual-system all
vsx stat
Juniper
+
SRX
Palo Alto
+
CIS Benchmark
log messages
Palo Alto Cheat Sheet Device Management
Palo Alto Cheat Sheet High Availability
Palo Alto Cheat Sheet Networking
Palo Alto Cheat Sheet User ID
Palo Alto Cheat Sheet VSYS
Palo Alto Cheat Sheet Panorama
Palo Alto Cheat Sheet VPN
Palo Scripting
show system info
Hardware
+
BIOS
bluetooth
CPU
Disk I/O
Disk Space
Firmware
Memory
HTTP Servers
+
Hugo
+
Hugo Github Netlify Checklist
Hugo Markdown Editor
Hugo Installation
Hugo New Project Creation
Hugo Create Site Structure Template
Hugo Front Matter
Hugo Directory Structure
Hugo Themes
Hugo Custom CSS
Hugo Partials
Hugo Short Codes
Hugo + Github
Hugo + Github + Netlify CDN
Hugo Github Reinstall
Export Wordpress to Hugo
Hugo YAML 2 TOML
Python Change Markdown Globally
Bulk Create toml menus python
Apache
+
301 Redirects Move Domain
404 Error Rewrite
Apache Benchmarking
Apache Configs
Apache htdigest
Apache Logs
Apache Modules
Apache Security
Apache Services
Apache VirtualHost
Developer Tools
Flask
Jekyll
NGINX
+
NGINX certbot ssl
NGINX Server Blocks
Node.js
Python
Status Codes
Network
+
Console Connections
Routing
+
Routing Notes
BGP Overview
BGP System Logs
BGP Missing Routes
BGP Path Selection
BGP Route Advertisment
BGP Session Establishment
BGP Session Establishment
BGP Suboptimal Routing
Troubleshooting
+
ARP
Bandwidth
DHCP
ethtool
Interface Errors
Latency
Link Detection
Link Speeds
MTU
Network I/O
Open Ports
Packet Captures
Traceroute
WiFi
+
WiFi Password Cache
Operating System
+
Windows
+
netstat interface statistics
cipher Permanently Delete Files
Change Default Browser in Thunderbird Client
Disable Automatic Reboot Win11
query user
windows firewall
Doskey CLI Persistence
Remove Bloatware PowerShell
Linux
+
apt
rsyslog Client Forwarder on Raspberry Pi
ssh-agent and ssh-add Automated Passwords
LAMP Stack Ubuntu 18.04 LTS
IPv6 Disable Ubuntu 18.04
ed25519 SSH Keys
ufw Bash Script for Dynamic Rule Updates
Crontab Troubleshooting
Crontab Messages
Crontab Examples
Crontab Scheduling
Crontab Basics
alpine
centos
codium
curl
dd
df and du Disk Space
ffmpeg
find
find public ip
flatpak steam
grep
hidden characters
iptables
Java JAR
logrotate
lsof
netdata server resources
netplan
RDP to Linux
rpm
rsyslog
samba
screen
sed
set ubuntu hostname
snmpwalk
ssh ipv4 only
ssh keys
ssh setup
ssh tunnels
sudo
swapfile
tar
tcpdump
top
ufw
users
vim
vmstat
webdav
wget
yum
zoom setup
gtk themes for XFCE
ChromeOS
+
ChromeOS LXC
crosh
Developer Mode
display app
Networking
SSH on Chrome
Host Firewalls
LDAP
+
ldapsearch
PS list accounts
Py Service Accounts
Permissions
+
File Permissions
General Permissions
Policies
Scheduled Tasks
Services & Processes
System Logs
System Updates
Time
WSL
+
distros
file location
import/export
installation
kex
list installed
update/rollback
version
windows terminal
reset wsl password?
Penetration Testing
+
Security Tools
+
SSH Tunnel as Socks Proxy in Firefox
View HTTP Headers With wget
OWASP
+
Setup DVWA to Practice Application Security Pentesting
CORS
OWASP ZAP
Scanning & Enumeration
Banner Grabs
Banner Grabs Powershell
DNS
DNS enumeration
Dorks
netcat
nmap
Real IP
WordPress
+
wpscan
Programming
+
Excel
+
Excel Date and Time
Excel LEFT, RIGHT, MID
Excel Logic
Excel TEXTJOIN
Excel VLOOKUP
Google App Script
+
Scripted Google Forms
Bash
+
Net I/O Current Bandwidth
Bash, Dungeon Crawl Save Game Skimmer
Bash Make mp4 with ffmpeg
Bulk Renamer
Server Monitor
Simple Logger Script
SSH Socks Proxy Menu
Thumbnail Gallery
HTML
+
HTML Picture Instruction Book
HTML crash course
HTML Prettifier
Jekyll
+
Jekyll Installation
Jekyll Markdown
Jekyll Sitemap
Jekyll Themes
Jekyll Transfer
Git
+
Use SSH Keys with Git
Basic Git Tutorial Crash Course
git Cheat Sheet
WSL Git
Visual Basic
+
Windows SAPI Using Visual Basic
PowerShell
+
Hostname < > IP Converter
WMI Saved Commands GUI
Check Open Ports with Powershell
Get Hash in Powershell Via Right Click Context Menu
Python
+
Python3 Debian Network Monitor
Python3 boto3 Route53 delete hosted zones
Python3 Digital Ocean Bulk DNS Editor
Python3 Bible App in Tkinter
Python3 AES 128 File Encryption
Python3 Base64 Maker
Python3 Flask Royalty Free Images
Basic tkinter usage for Python3
Verify SSL Expiration with Python3
Read and Write JSON File Python3
Python3 Create SVG Gameboard 9 Mens Morris
Python3 Single Threaded Ping Sweeper
Python3 Multi Threaded Port Scanner
Python3 Multi Threaded Ping Sweep Scanner
Python3 Code Library
Python3 Markdown/HTML to Docx
Python3 PDF Page Numberer
Python3 Python HTML Pretty
programming python venv
Perl
+
Compile Perl Script Using PAR
Count Lines in CSV Using Perl
Reorder Text With Perl Split and Splice
Check Perl Module Versions
Check Supported Encoding Types Using Perl
Annuvin Game Board from Perl SVG
Agnon Board Game in Perl SVG
Screen Saver Quotes With Perl GD
Add HTML to List Using Perl
Rename Files to Modified Time with Perl
Sort IP Addresses Using Perl
Watermelon Chess SVG Using Perl
Extract URI Using Perl Regexp::Common
Perl List Files in Directory
SVG Perl Script to Make Alquerque Game Boards
SVG Perl Script to Make 6 Point Star
Create Graph Paper or Checkerboard in Perl
Pretwa Game Board Using Perl to Create SVG
SVG Perl Script to Make 9 Mens Morris Game
Compare List of IP Addresses With Perl and Tk
Join Similar CSV Using Perl
DNS Lookups with Perl Net::DNS::Resolver
Fix Encoding Issues With Perl
Perl Script to Splice CSV Files
Use Perl to Match IP to Subnets
Hex Dump with Perl Scripting
Use Perl Mechanize and LWP to Scrape Site Data
Perl Script to Test URI Status
base64 encoding
check ports
csv2jmemorize
extract ipv4
fastest URL
host to ip
kw density
lwp
md5sum
one liners
par
shorthand if
strip HREFS
strip HTML
WordPress
+
optiPNG vs PNGcrush vs Gimp to Reduce PNG Size
WordPress Custom Template Short Code
WordPress PHP Fails After Ubuntu 18.04 Update
How to Delete Wordpress Revisions (Correctly)
Remove Duplicate Featured Image With CSS
ftp error
permissions
Markdown
SIEM
+
Splunk
+
Cheat Sheet
Splunk Licensing
Virtualization
+
Proxmox
+
apt proxmox
Backups
Force Stop VM
GPU Passthrough
lxc/pveam
nfs
nfs synology
Partition Ghosts
Storage
Proxmox ISO Storage
VmWare
Docker
+
iperf benchmark