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;
$users = quser
foreach ( $user in $users) {
if ($user -like"*Disc*") {
logoff $user.substring(40,6).Trim()
}
}
function Test-Port($hostname, $port)
{
# This works no matter in which form we get $host - hostname or ip address
try {
$ip = [System.Net.Dns]::GetHostAddresses($hostname) |
select-object IPAddressToString -expandproperty IPAddressToString
if($ip.GetType().Name -eq "Object[]")
{
#If we have several ip's for that address, let's take first one
$ip = $ip[0]
}
} catch {
Write-Host "Possibly $hostname is wrong hostname or IP"
return
}
$t = New-Object Net.Sockets.TcpClient
# We use Try\Catch to remove exception info from console if we can't connect
try
{
$t.Connect($ip,$port)
} catch {}
if($t.Connected)
{
$t.Close()
$true
}
else
{
$false
}
}