$AllProtocols = [System.Net.SecurityProtocolType]’Ssl3,Tls,Tls11,Tls12′
[System.Net.ServicePointManager]::SecurityProtocol = $AllProtocols
[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}
$webClient = New-Object System.Net.WebClient
$content = $webClient.DownloadString(‘https://somesite’)
$content
net stop w32time
w32tm /config /syncfromflags:manual /manualpeerlist:”servername1, servername2″
net start w32time
w32tm /config /update
w32tm /resync /rediscover
Check with:
w32tm /query /status
robocopy source: destination: /MIR /R:1 /W:1 /MT:32 /SEC
/MIR – MIRror a directory tree
/SEC – copy files with SECurity
/R:1 – number of Retries on failed copies
/W:1 – Wait time between retries
/MT:32 – Do multi-threaded copies with n threads (default 8)
From Exchange Shell
$mailpf = get-mailpublicfolder emailaddress@domain.com get-publicfolder $mailpf.entryID
From Powershell:
(New-Object -ComObject Microsoft.Update.AutoUpdate).DetectNow()
Import-Module Activedirectory
Get-ADUser -Filter * -Properties DisplayName,memberof | % {
$Name = $_.DisplayName
$_.memberof | Get-ADGroup | Select @{N="User";E={$Name}},Name
} | Export-Csv C:\temp\report.csv -nti
Get-MailPublicFolder email@domain.com | Get-PublicFolder
SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files ORDER BY SizeMB DESC
Find usernames and IP of connections to Microsoft SQL
SELECT DB_NAME(database_id) as [DB]
, login_name
, nt_domain
, nt_user_name
, status
, host_name
, program_name
, COUNT(*) AS [Connections]
FROM sys.dm_exec_sessions
WHERE database_id > 0 -- OR 4 for user DBs
GROUP BY database_id, login_name, status, host_name, program_name, nt_domain, nt_user_name;