Python – Execute command as of 4 weeks ago
Rudy Delete backups older than 4 weeks ago The script uses pbm delete-backup and delete-pitr to clean up backups older than 4 weeks. The script then sends an email when complete…
Python – Upload Sunday Files via S3
Upload Python Script The following code uploads files and directories via S3. This version gets files and directories created on a Sunday How to call from Command line We can…
Python – Upload latest via S3
The following python script uploads a file and directory via S3. The file and directory must match a certain pattern. If the file or folder do not exist, an error…
Python – Zip file and folder created today
The following Python script finds the latest file and folder created today, that match a given pattern. The file and folder are then zipped. The source file and folder remain…
Python File with Zip – Created Yesterday
Look for file and folder created yesterday The python script below gets the newest file and directory created yesterday. The file and directory must match a pattern. The file and…
Python File information
import os import datetime import re def get_newest_in_current_day(path): current_day_files = [] current_day_dirs = [] current_day = datetime.datetime.now().day pattern = re.compile(r"\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}Z(\.pbm\.json)?$") for name in os.listdir(path): # Skip names that do not…
Recently Disabled Active Directory Accounts
# Import Active Directory Module if it's not already loaded if (-not (Get-Module -Name ActiveDirectory)) { Import-Module ActiveDirectory } # Define how recent is "recently" (e.g., past 7 days) $daysAgo…
Aggregation
Aggregation 2
Python Record Counts
Version 2
Backup 003
An enterprise-worthy database monitoring strategy is essential for maintaining the performance, availability, and security of your organization’s data assets. A comprehensive monitoring strategy should encompass various aspects of database performance,…