Esse script exibe os dados do usuário que estam no banco de dados Quota. Muito simples mas me facilitou bastante, pois tenho cerca de 500 usuários.

• Download type_user.sh
• Enviar nova versão

Esconder código-fonte

#!/bin/sh
#
###############################################################################
#   Script TYPE_USERS.SH v1.0                                                 #
#                                                                             #
#  Autor: Alessandro Dias                                                     #
###############################################################################
#
#clear
echo "*********************************************************************************************"
echo "*                                    Programa TYPE_USER 1.0                                 *"
echo "*********************************************************************************************"
echo "Autor: Alessandro Dias"
echo "---------------------------------------------------------------------------------------------"
USERNAME=$1
if [ "$USERNAME" != "" ]; then
  echo "Dados do Usuario: "
  #Deleta o usuario do banco
  QUOTA=$(mysql -u root -ppostfix -e "select quota from user_quota where usuario='$USERNAME'" quota)
  QUOTA=`echo $QUOTA |cut -d " " -f 2`
  USO=$(mysql -u root -ppostfix -e "select uso from user_quota where usuario='$USERNAME'" quota)
  USO=`echo $USO |cut -d " " -f 2`
  NUM_MSG=$(mysql -u root -ppostfix -e "select num_msg from user_quota where usuario='$USERNAME'" quota)
  NUM_MSG=`echo $NUM_MSG |cut -d " " -f 2`
  EMAIL=$(mysql -u root -ppostfix -e "select email from user_quota where usuario='$USERNAME'" quota)
  EMAIL=`echo $EMAIL |cut -d " " -f 2`
  DESCR=$(mysql -u root -ppostfix -e "select descr from user_quota where usuario='$USERNAME'" quota)
  DESCR=`echo $DESCR |cut -d " " -f 2,3,4`
  SENHA=$(mysql -u root -ppostfix -e "select senha from user_quota where usuario='$USERNAME'" quota)
  SENHA=`echo $SENHA |cut -d " " -f 2`
  echo
  echo "Nome:  $USERNAME"
  echo "Quota: $QUOTA MB"
  echo "Uso:   $USO %"
  echo "N.Msg: $NUM_MSG"
  echo "Email: $EMAIL"
  echo "Descr: $DESCR"
  echo "Senha: $SENHA"
else 
  echo -e "\nEntre com a sintaxe correta do comando:\n./type_user.sh <nome_usuario>\n" 
fi
echo -e "---------------------------------------------------------------------------------------------\n"

Select DATAFILES especificando uma Tablespace

Script para criação de pacote rpm.

Disponibilidade de impressoras de rede

Converter arquivos .tif para .pdf

Baixar pdf do "slide share" sem login usando shell script