Get server information

report.sh

#!/bin/bash

######################## INFORMACOES DO SCRIPT #####################################################################
# Nome: report.sh                                                                                                  #
# Objetivo: Obter informacoes do servidor, tais como:                                                              #
#              - Taxa de uso do disco                                                                              # 
#	       - Uso da memoria                                                                                    #                                      
#	       - Tamanho das bases de dados Postgres                                                               #
# Requisitos: Para rodar o script com sucesso, e necessario os seguintes requisitos:                               #
#                 - aplicativo figlet                                                                              #
#                 - rodar o script com sudo ou usuario root                                                        #
# Criado por: Carlos Augusto Moreno Ribeiro Junior                                                                 #
# Versao: 0.1                                                                                                      #
####################################################################################################################


IP=localhost
PORTA=5432
USUARIO=postgres
COMANDO_SQL="SELECT 
                 datname AS banco, 
		 pg_database_size(datname) AS tamanho, 
		 pg_size_pretty(pg_database_size(datname)) AS tamanho_pretty 
	     FROM 
	         pg_database 
	     WHERE 
	         datname NOT IN ('template0', 'template1', 'postgres') 
	     ORDER BY 
	         tamanho DESC, banco ASC;"

$(top -n 1 -b > exit_of_top_command)

cat << EOF
$(figlet -w 150 -ck SERVIDOR `hostname`)
$(seq -s "=" 150 | tr -d [:digit:])
$(printf "%*sINFORMACAO DA DISTRIBUICAO" 60)
$(cat /etc/os-release)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sCARGA DO SISTEMA" 60)
$(head -5 exit_of_top_command)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sTAXA DE OCUPACAO DE ESPACO EM DISCO" 60)
$(df -h)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sUSO DA MEMORIA" 60)
$(free -h)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sTAMANHO DAS BASE DE DADOS" 60)
$(psql --host=$IP --port=$PORTA --username=$USUARIO --no-password --command="$COMANDO_SQL" | head -3)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sULTIMOS 10 LOGIN'S COM SUCESSO" 60)
$(last | head)
$(seq -s "=" 150 | tr -d [:digit:])

$(printf "%*sULTIMAS 10 TENTATIVAS DE LOGIN'S COM FALHA" 60)
$(lastb | head)
$(seq -s "=" 150 | tr -d [:digit:])

EOF