Todd's Blog

Todd's Tips for System Adminstrators

  • TechDays
  • Speaking Engagements
  • Contact Me
  • About Me

Connect

  • LinkedIn

Powered by Genesis

Generating a CSV file from Office 365

posted on September 2, 2013

Powershell LogoSometimes you need to run a command against multiple users. Maybe like me, you have 40,000 to run against. Entering each user name manually sucks, using the GUI would be unusable.

To generate a CSV file that lists all users in a particular domain in Office 365:



Get-MsolUser -DomainName "contoso.com" -All | Select UserPrincipalName |Export-Csv -path "C:\Exports\MyNewCSVFile.csv"

Which in turn generates a file with a list of the UPNs in Office365.

From there I can the run a command which sets something against each user in my Office 365 tenant.

Import-Csv -Path "C:\Exports\MyNewCSVFile.csv"  |%{Set-MsolUser -userPrincipalName $_.UserPrincipalName -"Rest of the commands you want here"}

Pretty simple and straight forward. If you want to add say a date to the filename add this to the script.

$CurrentDate = Get-Date -format dd.MMM.yyyy
$filename = "C:\exports\yourfile" + $CurrentDate + ".csv"

This will allow you to create a variable $filename which will contain your file name and a date added to it.

Now for the path variable you can put $filename rather than the full c:\xxxx information. It also allows you to use it in a script that can be automated and you will have files left behind to look it for checks.

 

 

Filed Under: Technology Tagged With: Exchange Server, Office 365, Powershell

Update Rollup 5 for Exchange Server 2010 SP1

posted on August 24, 2011

Just noticed today that Microsoft has release update rollup 5 for Exchange 2010 SP1.

It contains the Exchange 2010 change called out in  KB Article 2543879: PDF attachment from a Mac Mail client is not displayed when you use Outlook 2010 to open the email message in an Exchange Server 2007 SP3 environment.

I have seen this problem more and more lately.We can’t see the PDF file as an attachment at all in Outlook but can see the attachment fine on our mobile devices.

Go to http://blogs.technet.com/b/exchange/archive/2011/08/23/released-update-rollup-5-for-exchange-2010-sp1.aspx to get more information.

Filed Under: Technology Tagged With: Exchange, Exchange Server

Exchange 2007 to 2010 Migration

posted on January 10, 2010

An upcoming project I have at work is to migrate our Microsoft Exchange 2007 Server to Microsoft Exchange 2010. There is no direct upgrade from 2007 to 2010, and my Exchange 2007 server is running Windows Server 2003 x64.

At a high level, in order to upgrade, I will need to install new temporary server running Windows Server 2008 and Exchange Server 2010. I will then have to migrate the user mailboxes to the new temporary server. Once the migration is complete and Exchange 2007 is no longer being used or needed, I can then reinstall the operating system and install Exchange 2010 on the old machine. From there, I would move the mailboxes one more time from the temporary Exchange 2010 server to the permanent Exchange server.

I am lucky in that my migration is pretty straight forward and there isn’t more than a couple of dozen mailboxes to move. Hopefully it goes well.

Filed Under: Technology Tagged With: Exchange Server, Migration, Upgrade

  • 1
  • 2
  • Next Page »

Recent Posts

  • Office 365 – Creating Custom SKUs
  • Setting a Default Printer in Windows 10
  • Deploying Windows to the Correct Drive in Configuration Manager
  • Surface Pro 4, Surface Dock and DVI Problems
  • Enabling UEV in Windows 10 1607

Recent Comments

  • Moore Details on Setting up a Delayed Charge in Quickbooks Online
  • MCP Exam Training on Using PowerShell to Get a List of Groups from Active Directory
  • Kac on Setting up an Office 2010 KMS Host Server
  • prabumedia.com | Pilih lisensi MAK atau MKS untuk aktifasi produk Microsoft ? on Setting up a KMS Server
  • prabumedia.com | Pilih lisensi MAK atau MKS untuk aktifasi produk Microsoft ? on Setting up an Office 2010 KMS Host Server

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org