From Exchange Shell
$mailpf = get-mailpublicfolder emailaddress@domain.com get-publicfolder $mailpf.entryID
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
http://www.bobpusateri.com/archive/2010/09/a-look-at-the-sql-server-browser-service/
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
}
}
FOR /F "usebackq" %%i IN (`hostname`) DO SET HOST=%%i ECHO %HOST%