#!/bin/bash # Quick one-liner to extract user emails from logs # Usage: ./quick_extract.sh [service_name] SERVICE_NAME="${1:-veo-video-generator}" echo "Extracting user emails from $SERVICE_NAME logs..." echo "user_email,prompt" > quick_users.csv journalctl -u "$SERVICE_NAME" --no-pager | \ grep "Raw JSON data received:" | \ sed -n "s/.*Raw JSON data received: \(.*\)/\1/p" | \ jq -r 'select(.user_email != null) | [.user_email, .prompt] | @csv' 2>/dev/null >> quick_users.csv echo "Results saved to quick_users.csv" echo "Total records: $(($(wc -l < quick_users.csv) - 1))"