Run a program as admin from command line.

Ever run into a situation where you need to run a program as admin and Windows is not allowing you because you're in a screenshare with someone and UAC is prompting you but not let you type in your administrator credentials?  Give the following a try!

1. Open a command prompt.
2. Type in the following command.  
   • runas /user:Administrator cmd
   • type in your Administrator password
3. Another command prompt will open up but this time, its run under the Adminstrator account.
4. Navigate to the executable file you want to run, if its not in the environment path and type in the name and hit enter.

• Note:  for some reason, you can't open the control panel by running control.exe from this.  If anyone knows why, please let me know.

APC UPS and Powerchute

Today, while trying to set up a static IP for a production UPS, I mistakenly powered off the UPS taking down a network switch that's running off of.  Normally, to configure an IP on a device, I would normally use a console/serial (here's where the confusion lies for me) cable.  I saw a port marked "Serial" and thinking that was the console port when in fact its a port to configure the Powerchute, which is a power down management software from APC that is in most of their UPS devices.  The issue lies in that serial port.  If anything but a Powerchute serial cable that is plugged into that port marked "Serial" on the UPS, once a unrecognized signal is sent to that serial port, Powerchute will shutdown the entire UPS along with the devices that's plugged into it.  Bad.  Why?  I don't know.

Took me about 10 mins to figure out what had happened and went to power the UPS back on.  There is a port labeled "Console" on the back of the UPS but I didn't think too much of it since there was just a little hole next to it.  The little hole is actually for the real console cable in the form of a 2.5mm jack.  I've never seen a console cable like that until now.

What could APC have done?  Well maybe rename the "Serial" port as "Serial for Powerchute" and maybe have some warning if plugging in a non-Powerchute serial will result in UPS shutdown if any unrecognize signal is passed to it.

I digress.  

How to clear your variables in Powershell.

After running a Powershell command with a variable, the contents in that variable will stay in memory unless its cleared or overwritten to.  The command below is how to clear it from memory.  This helps when you're writing and testing a script to make sure you get accurate results and not results from stale memory in variables.

Remove-Variable * -ErrorAction SilentlyContinue

Power on a batch of VM's using Powershell

If you have a list of vm's and you need it to be powered on, the script below will help you do that.  To give the storage system air to breathe and not cause a boot storm, it powers on a VM every 2 seconds and waits 5 minutes after ever 50 VM is powered on.

Import-Module vmware.vimautomation.core

Remove-Variable * -ErrorAction SilentlyContinue

$vcenter = "hostname of vCenter or ESX host"

connect-viserver $vcenter

$count = 0

$csvfile = import-csv "Path to csv file"

foreach($vm in $csvfile)

{

    $vm_info = Get-VM -Name $vm.VMName   #VMName refers to column header in the  csv file.

    if ($vm_info.PowerState -eq "PoweredOff")

    {

        Write-Host "Powering on "$vm_info.Name

        $poweron = Get-VM $vm_info.Name | Start-VM -Confirm:$false

        Sleep 2             #power on a vm every 2 seconds.

        $count++

        if($count -eq 50)   #powers on 50 vm's then waits for 5 minutes for  storage to breathe.

        {

            Sleep 300

            $count = 0

        }

    }

}

Find a file in linux

To find a file in linux called "myfile", use the command below.

    [root@testbox /]# find / -name "myfile"

Power on a batch of virtual machines in a csv file using PowerCLI.

Use the following PowerCLI script to power on a list of Virtual Machines from a CSV file.

import-module vmware.vimautomation.core

$vcenter = <my vCenter server>

connect-viserver $vcenter

$allvms = import-csv RVTools_tabvInfo.csv

foreach ($strNewVMName in $allvms)

{   

        #gets all the VM's properties.  We're interested in the PowerState  Property.

        $vmdata = Get-view -ViewType VirtualMachine -Filter @{"name" =  $strNewVMName.vm}  #vm is the column header name in the csv on the first line.

        #if the PowerState is not PoweredOn, then power it on.

        if ($vmdata.Runtime.PowerState -ne "PoweredOn")

        {

            Write-Host "Powering on "$strNewVMName.vm

            Start-VM -VM $strNewVMName.vm

            Sleep 2

        }

}

Speed test on Google GCP instance.

Spun up a GCP instance today and ran a speed test.   No speed issues there.

Change IP from Windows command line using netsh.

Use the following command to change the ip of a network interface in Windows.

netsh interface ipv4 set address name="Ethernet0" static <new ip address> <subnet mask> <gateway>

Change IP address using Powershell.

1. Get-NetIPAddress
   1. get the InterfaceIndex number for the nic you want to change the IP address on.
2. Remove-NetIPAddress -InterfaceIndex X
3. New-NetIPAddress -InterfaceIndex X -IPAddress x.x.x.x -PrefixLength 23 -DefaultGateway x.x.x.x
4. Set-DnsClientServerAddress -InterfaceIndex X -ServerAddresses  x.x.x.x, x.x.x.x

Get regkey value on a batch of computers remotely.

Here's a Powershell script I created to get value in the registry on a batch of computers remotely.  Very handy if you have many computers to check.  Will output 'Offline' if the computer is turned off.

$strMachineName = Get-Content computer_name.txt
foreach ($line in $strMachineName)
{
    try{
            $reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $line)
            $regkey = $reg.OpenSubkey("<registry path>")
            $serialkey = $regkey.GetValue("LicenseInformation")
            if ($serialkey -eq ""){
                  write-host $line
           }
     }
    catch{
                write-host $line ----- "Offline"
    }
}