From Powershell:
(New-Object -ComObject Microsoft.Update.AutoUpdate).DetectNow()
Trigger WSUS update from command line Windows 10
Reply
Get all users and groups AD
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
Find Public Folder from Email address
Get-MailPublicFolder email@domain.com | Get-PublicFolder
Find largest MS SQL databases
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
How to check UDP protocol on SQL Browser service
Find who is connected to MS SQL.
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;
Logoff disconnected users on Remote Desktop Server with Powershell
$users = quser
foreach ( $user in $users) {
if ($user -like"*Disc*") {
logoff $user.substring(40,6).Trim()
}
}
Function for Powershell to test if TCP port answers
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
}
}
Use hostname as variable in CMD/BAT file
FOR /F "usebackq" %%i IN (`hostname`) DO SET HOST=%%i ECHO %HOST%
Remove all members from AD group
$ADgroup = "testgroup"
Get-ADGroupMember $ADgroup | ForEach-Object {Remove-ADGroupMember $ADgroup $_ -Confirm:$false}