From Powershell:
(New-Object -ComObject Microsoft.Update.AutoUpdate).DetectNow()
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 } }
FOR /F "usebackq" %%i IN (`hostname`) DO SET HOST=%%i ECHO %HOST%
$ADgroup = "testgroup" Get-ADGroupMember $ADgroup | ForEach-Object {Remove-ADGroupMember $ADgroup $_ -Confirm:$false}