[EXC] Convert Values to GB

 =LEFT(B2,LEN(B2)-2)/10^((MATCH(RIGHT(B2,2),{"PB","TB","GB","MB","KB"},0)-3)*3)

to MB, handling error

=IFERROR(LEFT(D2,LEN(D2)-2)/10^((MATCH(RIGHT(D2,2),{"PB","TB","GB","MB","KB"},0)-4)*3),0)

[O365] Collect more than 1000 results in Message Trace

 $P = 1

$messages = $null

do

{

Write-Host “Message Trace – Page $P…”

$temp_Messages = Get-MessageTrace -startdate "09/12/2022 12:00:00 AM" -Enddate "09/12/2022 06:00:00 PM" -PageSize 1000 -Page $P

$P++

$Messages += $temp_Messages

}until ($temp_Messages -eq $null)

#display messages

$Messages.Count

$Messages

[WSRV] Remote Connection saved credentials via powershell

 

To list saved credentials:

cmdkey /list:TERMSRV/*

To delete a saved credential:

cmdkey /delete:TERMSRV/<targetNameOrIp>

To add a credential that will actually work with CG turned on:

cmdkey /generic:TERMSRV/<targetNameOrIp> /user:<username> /pass:<password>

Cmdkey

[LY15] Check user's response group

Get-CsRgsAgentGroup | Where {$_.AgentsByUri -Like “*risual.user*” | FT Name  

[O365] Export reports for quarantined messages

Get-QuarantineMessage | select ReceivedTime,SenderAddress,RecipientAddress,Subject,Type,SystemReleased,PolicyType,Expires | Export-CSV -NoTypeInformation “c:/reports.csv”

[WSRV] Check Hyper-V Host

(get-item "HKLM:\SOFTWARE\Microsoft\VirtualMachine\Guest\Parameters").GetValue("HostName")

[WSRV] Search for file with a special character in the file name?

~="("

~="&"

~="hello you (1"