Notice; None of this is very advanced.. :)<br />
<br />
-------------------<br />
= VMware PowerCLI =<br />
-------------------<br />
<br />
find VMs based on IP<br />
Get-VM * |where-object{$_.Guest.IPAddress -match "10.10.10.5"}<br />
<br />
count number of powered on vms<br />
Get-VM | Where-Object {$_.PowerState -eq "PoweredOn"} | measure<br />
<br />
create vlan, remember to adjust the options!!!!<br />
Get-Cluster FuKluster | Get-VMHost | Get-VirtualSwitch -Name "vSwitch3" | New-VirtualPortGroup -Name "VLAN666-PirateServerGroup" -VLanId 666<br />
<br />
unmount ALL cd's in the vcenter ;)<br />
Get-VM * | Get-CDDrive | Set-CDDrive -NoMedia -Confirm:$false<br />
<br />
unmount ALL tools CDs in the vcenter.<br />
Get-VM | Get-CDDrive | where{$_.IsoPath -match "vmware/isoimages"} | Set-CDDrive -NoMedia -Confirm:$false<br />
<br />
list all snapshots and their vms powered on VMs<br />
get-vm | get-snapshot | format-list<br />
<br />
get cluster memory usage<br />
Get-Cluster | Select Name,@{N="Memory used MB";E={ $_ | Get-VM | %{$_.ExtensionData.Summary.QuickStats.HostMemoryUsage} |  Measure-Object -Sum | Select -ExpandProperty Sum}}<br />
<br />
get cluster vm memory allocation<br />
Get-Cluster | Select Name,@{N="Memory used MB";E={$_ | Get-VM | where-object {$_.PowerState -eq "PoweredOn" } | %{$_.MemoryMB} | Measure-Object -Sum | Select -ExpandProperty Sum}}<br />
<br />
set advanced option on hosts<br />
Get-VMHost |  Set-VMHostAdvancedConfiguration Syslog.global.logDir -Value '[vsanDatastore] Logs' <br />
<br />
get list of HA events<br />
Get-VIEvent -MaxSamples 100000 -Start (Get-Date).AddDays(-1) -Type Warning | Where {$_.FullFormattedMessage -match "restarted"} |select CreatedTime,FullFormattedMessage | sort CreatedTime -Descending<br />
<br />
get CPU overcommit ratio<br />
((get-cluster RH |Get-VM | where {$_.PowerState -eq "PoweredOn"}|measure-object NumCPU -sum).sum/(get-cluster RH |get-vmhost | where {$_.ConnectionState -eq "Connected"} |measure-object NumCpu -sum).sum)<br />
<br />
--------------<br />
= PowerShell =<br />
--------------<br />
Get SQL server edition<br />
$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances<br />
foreach ($i in $inst)<br />
{<br />
   $p = (Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL').$i<br />
   (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Edition<br />
   (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Version<br />
}<br />
<br />
------------------<br />
= Linux (Debian) =<br />
------------------<br />
<br />
Delete all mails that match a domain in postfix queue<br />
# for i in `mailq |grep spammerdomain.org|awk '{print $1}'|cut -d\* -f1`;do postsuper -d $i;done<br />
<br />
Exact starttime of PID<br />
# ps -o lstart= -p the-pid<br />
<br />
If you need to remotely hard-reset your Linux system because of a read-only file system (or anything else), try Magic SysRq:<br />
# echo 1 >/proc/sys/kernel/sysrq ; echo b >/proc/sysrq-trigger<br />
<br />
Refresh scsi devices (eg. for adding a disk hot in a VM)<br />
# for i in /sys/class/scsi_host/*;do echo "- - -" > $i/scan;done<br />
<br />
Switch default editor in Debian to vim.tiny (eg. if you don't like shit fuck editor nano)<br />
# update-alternatives --set editor /usr/bin/vim.tiny<br />
<br />
Null route an IP for some reason ...<br />
# route add -host 66.66.66.66 reject<br />
<br />
Get public IP<br />
# curl http://ipecho.net/plain<br />
<br />
Disable historyfile, when being naughty<br />
# export HISTFILE=/dev/null<br />
<br />
Display size of files and folders in human readable...<br />
# du -hs * | sort -h<br />
<br />
Time to calculate PI with 5000 decimals (I get about 33sec on a "PM" with a E5420, about the same on a (vmware) VM running on a E5620)<br />
# time echo "scale=5000; a(1)*4" | bc -l<br />
<br />
List memory modules in Linux<br />
# dmidecode -t 17 (or lshw)<br />
<br />
Convert unixtime to readable.. <br />
# date -d @1278999698<br />
<br />
Remove the first 5 characters on each line in a file<br />
# sed -i  's/^.....//' shittyfile<br />
<br />
Enable hot-added memory in Linux (under VMware)<br />
# for i in `grep offline /sys/devices/system/memory/*/state|cut -d: -f1`;do echo online > $i;done<br />
<br />
Check memory used by Apache (for tuning MaxRequestWorkers shite)<br />
# ps -ylC apache2 | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print "Average Process Size (MB): "x/((y-1)*1024)}'<br />
<br />
Mysql add index..<br />
# ALTER TABLE `wp_postmeta` ADD INDEX wp_postmeta_index(`meta_key`);<br />
<br />
-------<br />
= VIM =<br />
-------<br />
<br />
Save a file you edited in vim without the needed permissions<br />
:w !sudo tee %<br />
<br />
-----------<br />
= Windows = <br />
-----------<br />
<br />
Add route persistent<br />
# route ADD 192.168.35.0 MASK 255.255.255.0 192.168.0.2<br />
<br />
Tail a logfile<br />
# Get-Content myTestLog.log –Wait<br />
# Get-Content myTestLog.log -wait | where { $_ -match “WARNING” }<br />
<br />
---------------<br />
= Media stuff =<br />
---------------<br />
<br />
Timelapse with mencoder (this example is for use with GoPro photos, files.txt should include a list of the frames, find . -name *JPG > files.txt)<br />
# mencoder -nosound -ovc lavc -lavcopts vcodec=mpeg4:mbd=2:trell:vqscale=3:threads=4 -vf scale=1920:1080 -mf type=jpeg:fps=20 mf://@files.txt -o time-lapse.avi<br />
<br />
Add embedded timestamp to GoPro files and crop them to 16:9<br />
# convert originalfile.jpg -crop 4000x2250+0+200 -font fixed -pointsize 72 -fill red -annotate +3320+2400 %[exif:DateTimeOriginal] with_time/output.jpg<br />