Ping to file with timestamp

Create batch file:
@echo: off 
set host=192.168.1.1
set logfile=Ping.txt
ping -l 1000 -t %host%|cmd /q /v /c "(pause&pause)>nul & for /l %%a in () do (set /p "data=" && echo(!time! !data!)&ping -n 2 %host%>nul" >> %logfile%

To test from command line use %a instead of %%a

Output:
9:21:50.24 Pinging 192.168.1.1 with 1000 bytes of data:
 9:21:51.29 Reply from 192.168.1.1: bytes=1000 time=43ms TTL=61

Source: stackoverflow.com

Change Office 365 resource calendar default permitions

If you want to set that everyone can see who booked the resource - you must change default permissions on resource calendar.
Connect Exchange Online with PowerShell.

See permissions on resource calendar:
Get-MailboxFolderPermission -Identity resource@mail.com:\Calendar

FolderName  User       AccessRights
----------  ----       ------------
Calendar    Default    {AvailabilityOnly}
Calendar    Anonymous  {None}

Set permissions on resource calendar:
Set-MailboxFolderPermission -Identity resource@mail.com:\Calendar -User Default -AccessRights Reviewer

FolderName User     AccessRights
---------- ----     ------------
Calendar   Default  {Reviewer}
Calendar   Anonymous {None}

Resource: exchangeserverpro.com

Get list of Hyper-V VM disks

Run in PowerShell: Get-VMHardDiskDrive | Select-Object -Property VMName, VMId, ComputerName, ControllerType, ControllerNumber, ControllerLocation, Path | Sort-Object -Property VMName | Out-GridView -Title "Virtual Disks"

Enter VM name or * to get all.

PS Get used space on all volumes

gwmi win32_volume -Filter ‘drivetype = 3’ | select driveletter, label, @{LABEL=’GBcapacity’;EXPRESSION={$_.capacity/1GB} }, @{LABEL=’GBfreespace’;EXPRESSION={$_.freespace/1GB} }

Reset VSS Writer status

Get VSS writers:
vssadmin list writers

To reset VSS Writer status from Retryable or Non-retryable error you need to restart Hyper-V Virtual Machine Management service. Service restart does not affect VM only your ability to manage VM  through Hyper-V Manager console.

Source: social.technet.microsoft.com

Reset windows security settings to default.

secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose

Rename folders: WinDir%\System32\GroupPolicyUsers and WinDir%\System32\GroupPolicy

Sourc: microsoft.com and sevenforums.com

Use INDEX(MATCH()) instead of LOOKUP() in Excel

=INDEX ( Column I want a return value from , MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))

Source: www.randomwok.com