September 2012

Exchange 2010 ; Mailbox Statistics with sAMAccountName

I needed to get mailbox statistics, alongside user sAMAccountName in order to plan an Exchnage 2010 migration; the script below is a modified version of one I found here. Save as a “.ps1” file and run from the Exchange Management Shell, the script will create a csv file under C:\Temp.

{code lang:php showtitle:false lines:false hidden:false}$r=@()
get-mailboxdatabase * | get-mailbox -resultsize unlimited | foreach {$l = “”| Select sAMAccountName,displayName,Size,serverName,databaseName,ItemCount; $l.sAMAccountName = $_.samaccountname; $l.Size =
(get-mailboxstatistics -id $_.distinguishedname).totalitemsize; $l.displayName = $_.DisplayName; $l.ItemCount = (get-mailboxstatistics -id $_.distinguishedname).ItemCount; $l.databaseName = $_.database; $l.serverName = $_.serverName; $r += $l};
$r | export-csv c:\Temp\Sizing.csv -notype -encoding ascii {/code}

Windows 7 : SoftAP / Access Point Configuration

So I recently needed to share a 3G USB connection from a Windows 7 laptop with a variety of different devices; it turns out that this funcitonality is built-in to the OS and can be configured in a few simple steps. There are some GUI-type tools available to help you perform this operation should you want to simplify it…

Check for SoftAP Support

Execute the following command:
{code lang:ini showtitle:false lines:false hidden:false}netsh wlan show drivers{/code}

Look for “Hosted network supported : Yes”, provided this is supported you’re good to go. If this is not supported make sure you are running the most recent version of the drivers for your wireless card, if you are then unfortunately there isn’t anything else you can do…

Configuring the SoftAP

Now, from an Administrative command prompt execute the following commands:
{code lang:ini showtitle:false lines:false hidden:false}netsh wlan set hostednetwork ssid=PRVNet key=MyPassword1 keyUsage=persistent{/code}

Configure your Internet Connection for Sharing

Modify your “internet connected” adapter so that sharing is enabled, you also need to select the correct home networking connection that you want to share the connection with – make sure you select the new Microsoft Virtual Wifi Miniport adapter.

Enabling the SoftAP

Use the following command to switch on the SoftAP:
{code lang:ini showtitle:false lines:false hidden:false}netsh wlan start hostednetwork{/code}

You should be able to connect to your new SoftAP now.

Disabling the SoftAP

To disable the SoftAP execute the command:
{code lang:ini showtitle:false lines:false hidden:false}netsh wlan stop hostednetwork{/code}