Update EBS guid from OID

[thockman]

Code: Select all

#!/bin/bash
#
# Autor: Troy Hockman
# Script to build update file to import into fnd_users table
# It can also be used for a quick search tool.
# It will prompt for search string and password, then build ldpup.ldif
#
clear
ldapsearch="/u01/apps/oracle/product/Middleware/oid10gas/bin/ldapsearch"
ldapf="ldpup.ldif"
ldaph="localhost"

echo " "
echo -n "Enter search filter: "
read sfilter

echo -n "Enter Password: "
stty -echo
read password
stty echo

$ldapsearch -v -h $ldaph -p 3060 -D "cn=orcladmin" -w $password -b "" -s sub "uid=$sfilter" orclguid uid > $ldapf
err=$(cat $ldapf | grep returning)

if [ -n "$err" ]; then
  if [ -e "$ldapf" ]; then
    cat $ldapf | grep uid= | grep -v filter | sed -e "s/orclguid=/USER_GUID='/" -e "s/uid=/user_name='/" > /tmp/$$ && mv /tmp/$$ $ldapf
    awk '{ printf "%s", $0; getline var; printf " %s\n", var }' $ldapf > /tmp/$$ && mv /tmp/$$ $ldapf
    awk '{ printf "update fnd_user set "; print $1 "'"'"' where " $2 "'"';"'"}' $ldapf > /tmp/$$ && mv /tmp/$$ $ldapf
    tr '[:lower:]' '[:upper:]' < $ldapf > /tmp/$$ && mv /tmp/$$ $ldapf
  fi
  echo " "
  echo "Complete. Please use $ldapf for your needs."
else
  echo " "
  echo "Problem! Please read screen output for error."
  rm -f $ldapf
fi