PowerShell Exported CSV is Garbled?
May22

PowerShell Exported CSV is Garbled?

KB ID 0001557 Problem I was exporting a list of enabled Active Directory users to a CSV file for some documentation, the finished article was not what I was expecting; Contents; Microsoft.PowerShell.Commands.Internal.Format.FormatStartData ClassId2e4f51ef21dd47e99d3c952918aff9cd,  pageHeaderEntry pageFooterEntry autosizeInfo shapeInfo groupingEntry 033ecb2bc07a4d43b5ef94ed5a35d280...

Read More
VMware: Export a VM to OVA With PowerCLI
Jan21

VMware: Export a VM to OVA With PowerCLI

KB ID 0001507 Problem It’s pretty easy to create an OVA/OVF from the vCenter Web console, but what about from Powershell / PowerCLI? Below I run though converting a 2008 x32 Windows server to OVA. Solution I’ll leave the web console in the background so you can see whats happening. From PowerCLI the first task is to connect to the vCenter. Connect-VIServer {vCenter-FQDN} Supply a username and password. Now remove any...

Read More
PowerShell: Bulk Add/Remove Users From Groups
Oct15

PowerShell: Bulk Add/Remove Users From Groups

KB ID 0001475 Problem I had to do this a few weeks ago, so I documented it. I had a list of usernames in a CSV file and I needed to bulk-add them to a security group. Bulk Add Group Users Solution Firstly you will need the usernames (sAMAccountNames) in .csv format like so,  (Note: As a header Im using User-Name.) I’ve saved the file to C:\Temp on my server. Execute the following commands; Import-Module ActiveDirectory ...

Read More
PowerShell: Bulk Enable / Disable Users
Sep11

PowerShell: Bulk Enable / Disable Users

KB ID 0001469 Problem I needed to work out how to bulk disable some domain users from a .CSV file this week, so I thought I’d write it up. Disable Domain Users in Bulk from CSV Well firstly, you need to have your users in a CSV file. For the live job I just exported all the SamAccountNames to a CSV, but here for testing I just loaded a few in manually; Then execute the following two commands; Import-Module ActiveDirectory ...

Read More
Exchange and the LegacyExchangeDN Problem
Sep07

Exchange and the LegacyExchangeDN Problem

KB ID 0001468 Problem Why do we have the Exchange LegacyDN? It’s a throwback, from a time when we had our users, and our mail users in different databases. Below you can see the ExchangeLegacyDN for this Exchange on-premise user; /O=First Organisation/OU=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn={something-user-specific} Who cares? Well they are still important, if you send an internal email (to someone in...

Read More
Forward Mail From Exchange (On-Prem) To Office 365
Sep06

Forward Mail From Exchange (On-Prem) To Office 365

KB ID 0001467 Problem WARNING: Do not do this, if you are carrying out a Hybrid migration to Office 365! I’ve been doing an On-Prem to Office 365 migration recently. It was a little unusual because the ‘on-prem’ Exchange was not in the clients domain. So rather than migrate all the mail to their domain, and them migrate it to Office 365  we chose to use a third party migration solution ODME (Quest On Demand Migration...

Read More