Amit at 08:38, 14 April 2015

2015-04-14T08:38:12Z

← Older revision		Revision as of 08:38, 14 April 2015
Line 1:		Line 1:
			[[category:Heromotocorp Biz]]
			[[category:Tetra Clients]]
	== Script To get the user after a created date ==		== Script To get the user after a created date ==

Amit: Created page with " == Script To get the user after a created date == [zimbra@mail ~]$ cat /tmp/usr_list.sh #!/bin/bash #Display date will contain the date which is acceptable by ldap disp..."

2015-04-14T08:36:30Z

Created page with " == Script To get the user after a created date == [zimbra@mail ~]$ cat /tmp/usr_list.sh #!/bin/bash #Display date will contain the date which is acceptable by ldap disp..."

New page

== Script To get the user after a created date ==

[zimbra@mail ~]$ cat /tmp/usr_list.sh
#!/bin/bash
#Display date will contain the date which is acceptable by ldap
displaydate=`date -d "87 days ago" +%Y%m%d`"000000Z"
# Get ldap password from zimbra config
ldappass=`/opt/zimbra/bin/zmlocalconfig -s -m nokey zimbra_ldap_password`
# Get ldap dn from zimbra config
ldapdn=`/opt/zimbra/bin/zmlocalconfig -s -m nokey zimbra_ldap_userdn`
# Get ldap URL from zimbra config
ldapurl=`/opt/zimbra/bin/zmlocalconfig -s -m nokey ldap_url`
# ldapsearch and arguments
ldapsearch='/opt/zimbra/bin/ldapsearch'
ldapargs="-LLL -x -H $ldapurl -w $ldappass -D $ldapdn "
# We're only interested in the e-mail address and creation time
ldapattrs="zimbraMailDeliveryAddress createTimestamp"
# ldapsearch for all zimbra accounts that are active, created on or after $displaydate
$ldapsearch $ldapargs -b 'ou=people,dc=heromotocorp,dc=biz' "(&(objectclass=zimbraAccount)(!(objectclass=zimbraCalendarResource)) (zimbraAccountStatus=Active)(createTimestamp>=$displaydate))" $ldapattrs \| awk '
# Set Field Seperator to : and initialise our variables
BEGIN {FS=": ";email=0;timestamp=0}
# If line contains the email address, store it
/zimbraMailDeliveryAddress/ {email=$2}
# If line contains the create time, store it in a more readable format
/createTimestamp/ {timestamp=substr($2,0,4) "-" substr($2,5,2) "-" substr($2,7,2)}
# If the line contains dn: we know we are starting with a new entry, print our
# previous data and reset variables
/dn:/ {if (email) print email "," timestamp; email=0; timestamp=0}
# If we reach the end of input, print the last entry
END {if (email) print email "," timestamp}' > /tmp/accounts_created_last_87_days_from_`date +%F`.csv

Script to checkuser after createded date - Revision history

Amit at 08:38, 14 April 2015

Amit: Created page with " == Script To get the user after a created date == [zimbra@mail ~]$ cat /tmp/usr_list.sh #!/bin/bash #Display date will contain the date which is acceptable by ldap disp..."