..., etc.

====== LDAP ======
===== All Exchange Mailboxes =====
The base query to get all Exchange mailboxes is:
<code>
(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))))
</code>
=== Csvde ===

Csvde format for this query to retrieve CN's:
<code>
csvde -f all_exchange.txt -r "(&(&(& (mailnickname=*) (|(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l cn
</code>
Output of that query is simple to parse, and looks like:
<code>
DN,cn
"CN=102 Philosophy,OU=SIS,DC=ais,DC=columbia,DC=edu",102 Philosophy
"CN=210 Kent Conference Rm,OU=SFS,DC=ais,DC=columbia,DC=edu",210 Kent Conference Rm
"CN=Fred Arce,OU=Central Admin,OU=Medical Center,DC=ais,DC=columbia,DC=edu",Fred Arce
"CN=Adnan Akram,OU=Central Admin,OU=Medical Center,DC=ais,DC=columbia,DC=edu",Adnan Akram
</code>

===== Queries required =====

All users with exchange mailboxes
<code>csvde -f all_exchange.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l cn
</code>
Output: List of DNs,CNs.
Process: Output insert statements for DNs and CNs
Process: Output insert statements for OU

Manual export of CN with mailbox size from System Manager
Process: Output update statements with mailbox size where CN=CN.
..., etc.

User Tools

Site Tools

Page Tools
