Contacts CSV Import into Microsoft Exchange 2013 Public Folders

This was a ripper of a project. It allowed me to get my hands dirty with PowerShell and using the EWS Managed API with Exchange 2013 SP1. The code for this came from various sources and I have hand picked the bits I needed to make it all work. I have also had to add code to make the additional fields work and to vet the information that comes in from the CSV. How is this different to anything else out there? Simple. It contains nearly every field that can be imported into a Contact!! Yep. All those miscellaneous fields and User Fields!!!! Everything else on Google either only does… Read More

Continue Reading

Exchange 2007 to Exchange 2013 Migration

Great source for those wanting to / needing to Migrate from Exchange 2007 to 2013 On Premise. For those wanting to do cross site or Different Domains even. Have a look at https://www.bittitan.com/products/#migrationwiz. Pricing isn’t too bad, but it works fantastically as long as your OWA, ECP etc work as expected!! Gotcha to NOTE: You are exporting all your emails from one server to another. Check your Database size as this will be roughly your download size!!! If you have a limited download plan on your Internet Connection, IT IS GOING TO COST YOU BIG!! Any way, back to the On Premise. I have followed this process myself and had many… Read More

Continue Reading
SSL Certificate

SSL Certificates – Open SSL – Private Key

SSL Certificates are a critical part of any hosted page or service that operates on Port 443 or SSL!!! Great program for messing around with SSL Certs and Private keys is Open SSL One thing I find that I am constantly doing is pulling out the Private Key from a PFX File that I have created as a backup for my SSL Certificate. Install OpenSSL NOW, If you want to extract private key from a pfx file and write it to PEM file >> openssl.exe pkcs12 -in publicAndprivate.pfx -nocerts -out privateKey.pem Of course the other thing I find myself doing is importing a Private Key in with a Certificate to… Read More

Continue Reading

Exchange – Export Messages Sent or Received

To Get a CSV of messages sent or received. Run the following PowerShell command get-messagetrackinglog -Sender “emailaddress@domain.com.etc” -Server “ServerName” -Start “2013/01/28 6:00:00 AM” -End “2013/01/31 6:00:00 PM” | select timestamp, eventid, source, messagesubject, sender, {$_.recipients}, totalbytes | export-csv c:\sentmail.csv

Continue Reading

Request an UCC SSL Certificate for Exchange 2007

To Generate a Certificate Signing Request — Microsoft Exchange Server 2007 Click Start, All Programs, and then Microsoft Exchange Server 2007 Click Exchange Management Shell. (You may need to Run As Administrator Copy following command and paste it into a plain-text editor like Windows® Notepad in order to edit some of the fields: New-ExchangeCertificate -generaterequest -keysize 2048 -subjectname “c=Your Country, l=Your Locality/City, s=Your State, o=Your Corporation Name,cn=YourMainDomain.com” -domainname SubjectAlternativeName1, SubjectAltName2, SubjectAltName3, SubjectAltName4 -PrivateKeyExportable $true -path c:\certrequest.txt Update the following fields: c — Two-letter country code of your organization’s country of residence l — Full name of your organization’s locality or city s — Full name of your organization’s state or province o — Your… Read More

Continue Reading

Import SSL Certificate into Exchange 2007

There are two processes involved in installing your certificate: Installing our intermediate certificate on your server Installing your signed SSL certificate on your server To Install Our Intermediate Certificate From the Start menu, click Run… Type mmc and click OK. The Microsoft Management Console (Console) window opens. From the File menu, click Add/Remove Snap In. Select Certificates, and then click Add. Select Computer Account, and then click Next. Select Local Computer, and then click Finish. Click OK to close Add or Remove Snap-ins. In the Console window, expand the Certificates folder. Right-click Intermediate Certification Authorities, mouse-over All Tasks, and then click Import. In the Certificate Import Wizard, click Next. Click… Read More

Continue Reading

ActiveSync not working for Some users – DatabaseGUIDnotfound – Post Migration Exchange 2007 to Exchange 2013

There are some issues with ActiveSync for both Exchange 2007 and Exchange 2010 users whereby some users can connect their Mobile Devices (Windows Mobile Phones / iPhones / Motorola Droid etc) quite happily and ActiveSync pushes mail to the devices, but other users cannot connect and cannot sync anything at all. There appear to be plenty of potential solutions for this problem around if you search the web, but the solution to the majority of these problems can be solved quite simply. If you open up Active Directory Users and Computers and locate one of your users that is not working, Double-Click into the account and click on the Security… Read More

Continue Reading