http://www.benhall.com/doku/ 2026-04-21T14:23:04-04:00 http://www.benhall.com/doku/ http://www.benhall.com/doku/lib/tpl/dokuwiki/images/favicon.ico text/html 2010-02-18T15:50:42-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting_project:database_queries&rev=1266526242&do=diff Reporting/Database Queries For now this will only consist of useful queries. Maybe in the future I'll try to setup a reporting web page for the database. All non-bes users in a store: select displayName,bes,size from exchange_info where server='cuit-exchange1' AND mdb='Mailbox Store 10 (CUIT-EXCHANGE1)' AND bes IS NULL order by size; text/html 2010-02-02T07:21:16-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting_project:issues&rev=1265113276&do=diff Outstanding Issues Problems with Unicode without Unicode LDAP output "CN=Mimi N~RDiaye,OU=URH,DC=ais,DC=columbia,DC=edu",X'4d696d69204ee280994469617965',Mimi N'Diaye,/o=Columbia/ou=ALPHA/cn=Recipients/cn=on2106 Results in: insert into exchange_info (dname,cname,displayName,legacyExchangeDN) values ('CN=Mimi N~RDiaye,OU=URH,DC=ais,DC=columbia,DC=edu','X\'4d696d69204ee280994469617965\'','Mimi N\'Diaye','/o=Columbia/ou=ALPHA/cn=Recipients/cn=on2106'); insert into exchange_info (dname,cname,… text/html 2009-12-11T11:53:27-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting_project:query_notes&rev=1260550407&do=diff LDAP All Exchange Mailboxes The Exchange System Manager uses the “displayName” attribute, not common name, therefore, the displayName must be included in the initial lookup. I think three fields is fine, CN, DN, displayName... The base query to get all Exchange mailboxes is: