27 April, 2017

HOW TO IMPORT / EXPORT ActiveDirectory User List with Properties (French Characters – UTF8)

HOW TO IMPORT / EXPORT ActiveDirectory User List with Properties (French Characters – UTF8)
1- Export Users to a CSV file from an OU with the following command. (Don’t forget to “import-module ActiveDirectory” when you start PowerShell)

Get-ADUser -Filter * -SearchBase "OU=Administrateurs Systeme,OU=Utilisateurs,dc=domain,dc=com" -properties * | Export-Csv C:\AdminSysteme.csv -Encoding UTF8

This command will grab all users from the Administrateurs Systeme OU and Export it into a CSV file in C:\AdminSysteme.csv in UTF8 encoding for French characters.

2- Open the exported CSV file with Excel. Remove the first line and unused columns from the file. Save As the file and make sure you select the “Save as type” to “CSV (Comma delimited) (*.csv)”. You need to make sure that the file encoding is still UTF8. To do so, while in the “Save As” dialogue, click on “Tool”, “Web Options” and under “Encoding” make sure that the “Save this document as” is set to “Unicode UTF-8)”.  
  
3- Open back the same file and enter all the data you want to modify and save back the file same way as step #2!

4- Open the file in “Notepad” and without changing anything, “Save as” the file again and make sure that the encoding is UTF-8 and if it is not, save as with UTF8.

5- Now that you have all your data in a compatible CSV file. Import the user data with the following command in powershell. 

import-csv "C:\Users\user\Desktop\ADUserList\NEw folder\AdminSysteme1.csv" –Encoding UTF8 |  {Set-ADUser -Identity $_.samaccountname -Description $_.Description -StreetAddress $_.StreetAddress -City $_.City -PostalCode $_.PostalCode -Country $_.Country -Department $_.Departement -Fax $_.Fax -HomePage $_.HomePage -Office $_.Office -OfficePhone $_.OfficePhone -State $_.State -Title $_.Title} 

Known Issues!
All imported properties must be filled with values!
If you have an error of this kind while importing back the csv file;

PS C:\Windows\system32> C:\Users\user\Desktop\ADUserList\New folder\Untitled2.ps1
Set-ADUser : replace
At C:\Users\kelmas\Desktop\ADUserList\New folder\Untitled2.ps1:1 char:104
+ ...  | ForEach {Set-ADUser -Identity $_.samaccountname -Description $_.De ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (calexandre:ADUser) [Set-ADUser], ADInvalidOperationException
    + FullyQualifiedErrorId : ActiveDirectoryServer:0,Microsoft.ActiveDirectory.Management.Commands.SetADUser

Either not all the fields are filled in or the CSV file is not compatible (Comma delimited?, UTF8?)



08 April, 2017

Server 2016 - PerfNet Application Error Event ID 2006

Server 2016 is out and although it's still a baby, I've decided to slowly put it in production as a secondary storage/backup server. I was testing on a Dell PowerEdge T320 server with 10GB & 1GB nics and other than some iscsi configuration, everything else was at default settings on the system. Please note that this is a physical machine and not a VM!

Server 2016 is great and I have to admit, the experience has been really good so far... I'm sharing one of the difficult issues I had

08 March, 2017

Veeam Backup Warning - SQL VSS Writer is missing: databases will be backed up in crash-consistent state

Problem:


When Veeam backup job is running for a SQL server VM and the "application aware processing" is activated on the job Veeam is not capable of using the VSS Writers to backup the databases. Instead, Veeam will proceed with a full backup. The disadvantage is when you need to restore backups in crash-consistent state, you won't be able to recover just the application items (databases, mailboxes, AD objects, etc...), you'll have to do a full restore or just OS files but no application objects recovers.

Notes:

Veeam even has a KB article for the issue. https://www.veeam.com/kb2095

Most of the time, it looks like it's a database naming issue. If your database names contains spaces in them, Veeam is not able to use the SQL VSS Writers.

I strongly suggest that you go trough that article before trying the solution found here. However, in my case, none of the solutions worked from veeam's article.

Solution:

I had to login to my SQL server and under services, change the "SQL Server VSS Writer" service logon account to a domain user account instead of "Local System" account.

Once you do this, your next backup will be processed properley with the application aware processing.




09 June, 2016

Windows Update 80070000E Error

If you're getting a 80070000E issue when trying to update a Windows 7 follow the steps below to solve the issue.

15 June, 2015

BES Express 5 Web Page Issues because of KB3061518 Windows Update

Windows 10 is coming and Microsoft is pushing out its updates to prepare our computers for this fresh operating system from Microsoft. But do they really need to be that aggressive so that our existing services stops working? Frustrating monday!

22 April, 2015

iSCSI Storage Performance & Benchmarking with IOMeter



This is a storage performance report that I have done on 3 different storage types. I was curious to see the performance difference between different types of iSCSI storage units. I wanted to share the results with others because when I wanted to compare my results with others, I was surprised to see that there are a lot of people discussing about storage technologies and all but no one is actually sharing their benchmarks openly.
Because, a storage benchmark can vary a lot depending on your environment, I am going to list my setup so you can compare these results to your own environment as close as possible.

11 December, 2014

WDS, PXE Boot, DHCP and VLANs… How to manage?



I’m a big fan of easy deployment, scripting, automating etc… Therefore I love deployment tools. I am constantly using tools like Microsoft System Center, WDS, MDT, etc… Thanks to these kinds of tools, I can be alone and have the workforce of an IT army :)