http://www.benhall.com/doku/ 2026-04-14T09:08:26-04:00 http://www.benhall.com/doku/ http://www.benhall.com/doku/lib/tpl/dokuwiki/images/favicon.ico text/html 2010-03-06T05:05:13-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:0getallexchange.bat&rev=1267869913&do=diff 0getallexchange.bat csvde -u -f all_exchange.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l cn,displayName,legacyExchangeDN text/html 2010-03-06T05:03:27-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:1.1getidexchange.bat&rev=1267869807&do=diff 1.1getIDexchange.bat csvde -u -f samid_exchange.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user) (|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l sAMAccountName text/html 2010-03-06T05:04:11-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:1getidexchange.bat&rev=1267869851&do=diff 1.1getIDexchange.bat csvde -u -f samid_exchange.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user) (|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l sAMAccountName text/html 2010-03-06T05:02:26-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:2getdisabledexchange.bat&rev=1267869746&do=diff 2getdisabledexchange.bat csvde -u -f disabled_exchange.txt -r "(&(&(& (mailnickname=*) (|(&(objectCategory=person)(objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=2)(|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l dn text/html 2010-03-06T05:01:05-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:3getlastlogon.bat&rev=1267869665&do=diff 3getLastLogon.bat csvde -u -f lastlogon_exchange.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user) (|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l lastLogon text/html 2010-03-06T05:00:14-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:4getallexchangeservermdb.bat&rev=1267869614&do=diff 4getallexchangeServerMDB.bat csvde -u -f all_exchange_mdb.txt -r "(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))))" -l homeMDB text/html 2010-12-06T09:23:49-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:database_definition&rev=1291645429&do=diff Database Definition Name Database name: CU_Exchange Tables Tables: exchange_info Table description: mysql> describe exchange_info; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | cname | varchar(120) | YES | | NULL | | | dname | varchar(256) | YES | UNI | NULL | | | displayName | … text/html 2010-03-06T05:12:43-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:getbesusers.vbs&rev=1267870363&do=diff getBesUsers.vbs I can't remember where I found the source on this one- it's not my code, if/when I find the source I'll post it. 'Setup our objects Set ConWSH=WScript.CreateObject("ADODB.Connection") 'Define our connection string 'strConnection = "Driver={SQL Server};Server=servername;User ID=userid;Password=password;Database=BESMgmt;" strConnection = "Provider=SQLOLEDB;Data Source=blackberry5db;Initial Catalog=BESMgmt;Network=DBMSSOCN;Trusted_Connection=Yes;" 'and parameters with ConWSH … text/html 2010-03-06T04:59:17-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:getexchangemailboxinfo.vbs&rev=1267869557&do=diff getExchangeMailboxInfo.vbs 'the main work was taken from Microsoft's sample code On Error Resume Next Dim aArgs Dim strUsage Dim strArgs Dim server_arg strUsage = "Usage: cscript.exe " & wscript.ScriptName & " ExchangeServerName [ServerName2 ServerName3...]" Set aArgs = wscript.Arguments If aArgs.count = 0 Then wscript.echo strUsage wscript.quit(1) End If 'If aArgs.count > 0 Then ' If aArgs.Count > 1 Then ' wscript.echo strUsage ' wscript.Quit(1) ' End If strArg = aArgs(0) 'some er… text/html 2009-12-17T08:29:27-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:initial_batch_scripts&rev=1261056567&do=diff 0 3lastlogon_insert.sh This script includes conversion of Windows NTTE/NT File time to standard time/data using Unix utils-- #!/bin/bash oldIFS=$IFS IFS=$'\n' export LC_ALL='C' #delete temp files rm lastlogon_tmp.txt >/dev/null rm batch_sql/3lastlogon_insert.sql >/dev/null #start insert sql file echo use cu_exchange\; >> 3lastlogon_insert.sql #remove line endings, sort, etc. cat lastlogon_exchange.txt | grep -v "DN,lastLogon" |tr -d '\r' >> lastlogon_tmp.txt for i in $(cat lastlogon_tm… text/html 2012-11-08T09:35:00-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:new_reporting&rev=1352385300&do=diff Exchange Reporting with Powershell, VBS (to be replaced), WMI, & LDAP * Powershell * Two VBS Scripts for BES & Mailbox status I need one of those “Under Construction” gifs... text/html 2010-04-28T05:29:17-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:reporting_project&rev=1272446957&do=diff Exchange Storage Reconciliation This began as a “I'll just whip this up” type of project, with the goal of being able to report on our Exchange server storage use by group/OU/user/server/mailbox store/etc... Intended goals are/were: * Database definition and creation text/html 2010-03-06T10:27:32-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:run_getexchangedata.bat&rev=1267889252&do=diff run_getexchangedata.bat call 0getallexchange.bat call 1getIDexchange.bat call 1.1getIDexchange.bat call 2getdisabledexchange.bat call 3getLastLogon.bat call 4getallexchangeServerMDB.bat call 5quota_exchange.bat cscript getbesusers.vbs > besusers.txt cscript getExchangeMailboxInfo.vbs cuit-x1 cuit-x2 cuit-x3 cuit-x4 cuit-x5 cuit-x6 > mailbox_sizes.txt text/html 2010-03-06T05:27:05-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:runexchangereporting.sh&rev=1267871225&do=diff runExchangeReporting.sh #!/bin/bash rm ./batch_sql/*.sql > /dev/null rm ./txt/*.txt > /dev/null ./batch/transfer.sh echo echo "Transfer Complete" echo #echo Sort files for good measure... #./batch/sort_files.pl txt/* #convert from UTF16 to UTF8 for file in $(ls txt/*.txt|grep -v bes|grep -v mailbox_sizes.txt) do echo converting file: $file ./batch/unicode.pl $file > "$file"_uni.txt done echo Sort files for good measure... ./batch/sort_files.pl txt/*.txt echo parse_allE… text/html 2010-03-06T04:33:40-04:00 http://www.benhall.com/doku/doku.php?id=exchange:reporting:wmi_vbscript&rev=1267868020&do=diff VB Script to return Exchange Mailbox data via WMI 'the main work was taken from Microsoft's sample code On Error Resume Next Dim aArgs Dim strUsage Dim strArgs Dim server_arg strUsage = "Usage: cscript.exe " & wscript.ScriptName & " ExchangeServerName [ServerName2 ServerName3...]" Set aArgs = wscript.Arguments If aArgs.count = 0 Then wscript.echo strUsage wscript.quit(1) End If 'If aArgs.count > 0 Then ' If aArgs.Count > 1 Then ' wscript.echo strUsage ' wscript.Quit(1) ' End If strAr…