Yet Another IT Professional Blog

A lot of the times, I find myself having multiple Excel or CSV files with different tables & data that at some point, I need to merge them... Here is a not to myself! Use Index and Match formulas. Index Function The INDEX function returns a value or the reference to a value from within a table or range. Match Function The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range. Ex : INDEX ( return_range , MATCH ( lookup_value ,  lookup_range , 0)) =INDEX(Sheet1!$B$2:$B$218,MATCH($A2,Sheet1!$A$2:$A$218,0)) In this example, with Match, we're trying to find cell A2's exact value by looking in the "Sheet1", from A2 to A218. When the exact value of A2 is found in the range of Sheet1!$A$2:$A$218, with the Index ...

Although I don't consider myself a real gamer, I do enjoy playing games from time to time. Since, I've started working at Ubisoft, I'm trying to take advantage of the games available to me. One does not simply work for one of the greatest gaming companies in the world and simply refuse to play their games ;) So after installing uPlay on my computer, I downloaded & installed huge packages of the Assassin's Creed, Crew, South Park, For Honor, etc... Everything was working fine until I decide to lunch on of the Assassin's Creed games.

Problem Description; I had this issue on one of my backup jobs recently and I was able to fix the issue with the solution explained below. After a quick google search, I realized that I'm not the only one and neither you are :) Full Error Description; Failed to prepare guest for hot backup. Error: VSSControl: Failed to prepare guest for freeze, wait tim eout 9 00 sec Error: VSSControl: Failed to prepare guest for freeze, wait timeout 900 sec

Almost all of the obvious bugs and errors are all related to Microsoft new environment and the APPs... Recently, I was trying to prepare a VM Template but I was stuck at the Sysprep process with the following error.

If you're getting an internal error while trying to run the Get-VMHostFirmware command with vSphere PowerCli, chances are the problem comes from a corrupt scratch directory on the hypervisor. The Get-VMHostFirmware command is one of my favorites if I'm doing any maintenance on the hosts. It saved me hours of configuration multiple times... Very handy! But recently, I needed to run the command on one of my hosts and I was getting an internal error! Nothing more... Even after a reboot and trying all the other methods of configuration backup mentioned here, still no luck!

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

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