Friday, March 12, 2010

Exchange 2007: Content Filtering System Whitelist GUI

eThis is from this blog:
http://gsexdev.blogspot.com/2009/02/content-filtering-system-whitelist-gui.html
I'm just re-posting them in my blog. I've already tested the script and it worked great.

" If you’re using the built-in Content Filtering in Exchange 2007 on a Hub or Edge server you may want to take advantage of System white lists. But if you have used the Set-ContentFilterSetting cmdlet you may have noticed this isn't the most user friendly cmdlet. If you’re maintaining these lists on a regular basis you may really start to dislike the lack of a GUI well I certainly do so I built a pretty simple GUI to make managing the BypassedSenders and BypassedSenderDomains a more enjoyable experience.
It’s pretty simple code first it uses Get-ContentFilterSetting to get the current setting of both of these properties and then displays then in a DatagridView. You can then add more entries or change existing entries by editing the flexGrid then when you hit the update button it will run back through the datagrid values and then creates a collection which is then used to update the ByPassedSenders or ByPassedSenderDomains properties. "

Download the script here

Tuesday, March 9, 2010

CSV Output of "Get all List of all Archives and all relevent information" using VBscript.

Source: Symantec Website: link below.
http://www.symantec.com/connect/downloads/csv-output-get-all-list-all-archives-and-all-relevent-information-using-vbscript

All credit goes to Wayne Humphrey for writing the SQL query which retrieves this very useful information from the database. This is simply a wrapper which I wrote in vbscript to output the information to a .csv file.

I have not included this in the main script, however to email the output you would need to append something like this to the bottom of the script.

Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "subject"
objMessage.From = "your_from_address"
objMessage.To = "your_to_address"
objMessage.HTMLBody = "body"
objMessage.AddAttachment OutputFile

objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "your_email_server"
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMessage.Configuration.Fields.Update
objMessage.Send

I have blanked out my own environment settings and replaced them with fill-ins.

You will need to rename: EV-User-Report.txt to EV-User-Report.vbs & SQLQuery.txt to SQLQuery.sql

Hope someone gets some use out of this.

Jeremy.

Monday, March 8, 2010

Exchange Server 2007: How to Import PST Files into Mailboxes

Exchange Server 2007: How to Import PST Files into Mailboxes

:
  1. Download and install Windows PowerShell onto a 32-bit workstation.
  2. Download the 32-bit version of Exchange Server and install the management tools.
  3. Install and configure Outlook 2003 SP-2 or later.
  4. If the PST files are on a network share, then map a drive letter to the share and folder, such as P:\PSTFiles
  5. Grant Send-As and Receive-As rights to the user who is doing the importing.
    Run the following command from the Exchange Management Shell, replacing the "My" variables with the correct values. The command should be on a single line of next, not wrapped as it likely appears below.

    Get-MailboxDatabase -identity "\First Storage Group\Mailbox Database" | Add-ADPermission -user "\" -ExtendedRights Receive-As, Send-As
  6. To import a single mailbox, replace the value of UserAccountName as needed and run the following command:

    Import-Mailbox -Identity UserAccountName -PSTFolderPath P:\PSTFiles
  7. To import ALL the mailboxes in a folder:

    Get-Mailbox -Database '\First Storage Group\Mailbox Database' | Import-Mailbox -PSTFolderPath P:\PSTFiles

Source: http://www.fieldbrook.net/TechTips/Exchange/ImportMailboxes2007.asp

WinDirStat:disk usage statistics viewer and cleanup tool

WinDirStat is a disk usage statistics viewer and cleanup tool for Microsoft Windows (all current variants).

WinDirStat - Windows Directory Statistics

WinDirStat reads the whole directory tree once and then presents it in three useful views:

  • The directory list, which resembles the tree view of the Windows Explorer but is sorted by file/subtree size,
  • The treemap, which shows the whole contents of the directory tree straight away,
  • The extension list, which serves as a legend and shows statistics about the file types.
Website:
http://windirstat.info

Tuesday, March 2, 2010

Exchange 2007: Understanding Anti-Spam and Antivirus Mail Flow

Exchange 2007: Understanding Anti-Spam and Antivirus Mail Flow

From: http://technet.microsoft.com/en-us/library/aa997242(EXCHG.80,printer).aspx

When an external user sends e-mail messages to a Microsoft Exchange server that runs the anti-spam features, the anti-spam features cumulatively evaluate characteristics of inbound messages and either filter out messages that are suspected to be spam or assign messages a rating based on the probability that the message is spam. This rating is stored with the message as a message property that is called the spam confidence level (SCL) rating. This rating is persisted with the message when the message is sent to other Exchange servers.

Figure below shows the order in which the default anti-spam features and Microsoft Forefront Security for Exchange Server filter inbound messages from the Internet. By default, the anti-spam and antivirus features are arranged in this order with the filters that use the least resources filtering first, and then the filters with that use the greatest resources filtering last.