July 12, 2019 Vignesh Sathiyanantham

Recently we faced an issue in our product Nimesa Cloud Data protection, our QA Director raised a bug that Nimesa is listing two networks during Virtual Machine clone but while editing the VM in vSphere web client he was getting only one network. When I checked in the vSphere web client I can see one network as Uplink port group but in the manage object browser two networks are listed and there is no difference between them to identify that as an uplink port group and ignore while listing in the clone after scratching my head and wondered “ But…

July 11, 2019 Vignesh Sathiyanantham

Removing the old snapshots of the Virtual Machine is one of the easiest ways that a virtualization administrator can reclaim storage capacity in their environment. Unlike reclaiming other resources like CPU or Memory, deleting old snapshots doesn’t require downtime. Now, many of us are guilty of having snapshots that are months old, and sometimes for reasons, we can’t even remember. But unless you have a tool like vRealize Operations Manager, finding and deleting old snapshots can be a lengthy manual process. There are multiple ways to find the old/stale VM snapshots, you can leverage some smart tools like RVTools to…

July 8, 2019 Vignesh Sathiyanantham

Java 8 has Collectors.joining() and its overloads. It also has String.join.Using a Stream and a Collector Function<String,String> addQuotes = s -> “\”” + s + “\””; String result = listOfStrings.stream() .map(addQuotes) .collect(Collectors.joining(“, “)); String result = listOfStrings.stream() .map(s -> “\”” + s + “\””) .collect(Collectors.joining(“, “)); String result = listOfString.isEmpty() ? “” : “\”” + String.join(“\”, \””, listOfStrings) + “\””; Happy Coding!

May 9, 2019 Vignesh Sathiyanantham

Changing the individual database recovery model is very simple with the Microsoft SSMS. But recently in one of our Nimesa customer environments, he had 200 databases in a non-production instance and all the databases are in the simple recovery model. That user wanted to do POC of Nimesa Application-aware backup and Point in time recovery for MS SQL database server, Log backups are not possible with the simple recovery model, so I executed a small PowerShell script which changes all the databases to the FULL recovery model from the simple recovery model Get-SqlDatabase -ServerInstance NW1\CLUST2 The above Powershell command gets…

May 2, 2019 Vignesh Sathiyanantham

Creating a full backup in the SQL server using SSMS is very simple, but if you have 10’s of databases you find bit difficult to backup all databases in one go. So i write a small Powershell script which gets the list of databases and takes the backup except the system databases https://gist.github.com/asvignesh/9c2f275c9418b038022ceffa94ba2152 Run the script with Server name and the backup directory as parameters .\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir

April 20, 2019 Vignesh Sathiyanantham

To Disable UAC on the Windows Server, change the registry value EnableLUA to 0, to change it using the powershell Set-Itemproperty -path ‘HKLM:\Software\Microsoft\Windows\CurrentVersion\policies\system’ -Name ‘EnableLUA’ -value 0 Below is the script to change on multiple Windows Machines using RemotePS https://gist.github.com/asvignesh/ae5a1ad1cf036f2481ef26f67816242d

April 19, 2019 Vignesh Sathiyanantham

  While testing our product Nimesa with Microsoft SQL Server 2016 on Microsoft Windows 2019 i hit with some scenarios my nodes in SQL cluster has some shadows, i wanted to check in all the machine and delete the shadows. What i did is, i wrote a small powershell script which connects to all the nodes in my test bed and run diskshadow command  delete shadows all  For that, First i need to enable the PowerShell Remoting on all the nodes ( My nodes are connected to active directory and all are part of Windows Failover clustering ) Enable-PSRemoting -Force…

April 12, 2019 Vignesh Sathiyanantham

To do some testing of the on going release of Nimesa which do the application aware ( AppAware ) Backup of Microsoft SQL Server Cluster on SQL 2016 i created a small powershell scripts which create ( actually restores ) the databases from Adventure Works backup file Change the total and volume drive letter in the below code and run it. If you want to have Data files (.mdf ) and Log Files (.ldf) in the same volume, set the volume1 and volume2 with same value If you want to create data and log files on different volume, set different…

April 10, 2019 Vignesh Sathiyanantham

Copy and Paste the following command to install this package using PowerShellGet Install-Module -Name VMware.PowerCLI If you are getting any error related to the privilege PS C:\Users\asvig> Install-Module -Name VMware.PowerCLI Install-Module : Administrator rights are required to install modules in ‘C:\Program Files\WindowsPowerShell\Modules’. Log on to the computer with an account that has Administrator rights, and then try again, or install Run with adding -Scope CurrentUser Install-Module -Name VMware.PowerCLI -Scope CurrentUser In addition to that you may need to set Execution policy to RemoteSigned Set-ExecutionPolicy -ExecutionPolicy RemoteSigned by running the above command in Administrator mode, and also import Import-Module VMware.VimAutomation.Core before…

January 2, 2019 Vignesh Sathiyanantham

Deploying a virtual machine from a template is an easy task but cloning a virtual machine will maintain its computer name, serial number and the license information and deploying multiple Virtual machines for dev test is also a painful job We can achieve it more easily using vSphere powercli, modify the below script according to your lab details and run it Change the vCenter HostCredentials ( username and password )Number of VM to deployFrom which template you want to create a cloneOS Custom specificationTo which datastore you want to clone the virtual machinesTo which ESXi node you want to attach…