Active Directory export script to import into SME Server

I had to migrate users from an Active Directory/Exchange combo to a SME server for temporary disaster recovery event. Here’s the script I wrote to create the export and recreate the users and their aliases in the SME server.

The export was done before the disaster of course :)


#ldapsearch -x -b "dc=customer,dc=com" -h -D "domain\user" -W "(objectclass=user)" > activedirectory.ldiff

#reset files content
echo > sme.users
echo > sme.aliases

cat "$File" | while read line
       #concatenate new line to existing info

       #treat all info if user is finished
        if $(echo -e "$line" | grep -q '^$')
                echo User info finished

                #treat only users with mail address
                if $(echo "$UserInfo" | grep -q '^mail:')
                       #recover data
                        UserName=$(echo "$UserInfo" | grep 
'^sAMAccountName:' | sed -e 's/sAMAccountName: //' | tr '[A-Z]' '[a-z]')
                        UserFirstName=$(echo "$UserInfo" | grep '^givenName:' | sed -e 's/givenName: //')
                        UserLastName=$(echo "$UserInfo" | grep '^sn:' | sed -e 's/sn: //')
                        UserMail=$(echo "$UserInfo" | grep '^mail:' | awk '{print $2}' | tr '[A-Z]' '[a-z]')
                        UserMailAliases=$(echo "$UserInfo" | grep 
'^proxyAddresses: smtp:' | sed -e 's/^proxyAddresses: 
smtp:\(.*\)@.*$/\1/' | sort -u | grep -vi "^${UserName}$" | tr '\n' '|' |
 tr '[A-Z]' '[a-z]')
                        Tmp=$(dd if=/dev/urandom | tr -dc _A-Z-a-z-0-9 | head -c 4)
                        UserPassword=$(echo "${UserName}${Tmp}" | tr '[A-Z]' '[a-z]')

                       #print user info
                        echo "$UserName |$UserFirstName |$UserLastName |$UserPassword" >> sme.users
                        #print aliases if any
                        if [ $(echo "$UserMailAliases" | wc -c) -gt 2 ]
                            echo "$UserName |$UserMailAliases" | sed -e 's/^\(.*\)|$/\1/' >> sme.aliases

                        #cleanup some shit
                        unset UserName
                        unset UserFirstName
                        unset UserLastName
                        unset UserMail
                        unset UserMailAliases
                        unset Tmp
                        unset UserPassword

                unset UserInfo

You can then import all the users and their aliases with the following commands:

lat-users -a -i sme.users
lat-pseudonyms -a -i sme.aliases
This entry was posted in Computer, Exchange, Linux, Microsoft and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.